Seven Stars

Add JSON Result Into DB Table

Hi,

 

I have fetched JSON using tRESTClient connector as shown in attachment. I want to parse this JSON and insert it into some table. However no rows got inserted in to the table.

 

For your reference in the comment I have also attached TMap section mapping. So that could see if I have done some thing wrong. In this attachment as you can I have added 1 extra column out1 of Object Type in the outputrest section. I if I don’t add this Object Type column then I get an error “cannot cast from string to resultset”.

 

Can anyone please tell me what I am doing wrong.

 

Regards

Tarunjit Singh

1 ACCEPTED SOLUTION

Accepted Solutions
Seven Stars

Re: Add JSON Result Into DB Table

Hi,

 

I have resolved the issue. Please find attached job design which I followed.

 

3 REPLIES
Seven Stars

Re: Add JSON Result Into DB Table

Hi,

 

Referring to my last comment attaching Tmap section mapping.

 

Regards

Tarunjit Singh

Seven Stars

Re: Add JSON Result Into DB Table

Hi,

 

I have resolved the issue. Please find attached job design which I followed.

 

Six Stars

Re: Add JSON Result Into DB Table

Can you show us Jsonextract component?