Add JSON Result Into DB Table

[Anonymous]

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

[Anonymous]

Hi,

Referring to my last comment attaching Tmap section mapping.

Regards

Tarunjit Singh

Tmap.png

[Anonymous · Accepted solution]

Hi,

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

Job Design.png

[Anonymous]

Can you show us Jsonextract component?