topic Add JSON Result Into DB Table in Talend Studio

Add JSON Result Into DB Table

Anonymous — Wed, 14 Feb 2018 06:11:41 GMT

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

Re: Add JSON Result Into DB Table

Anonymous — Wed, 14 Feb 2018 06:13:55 GMT

Hi,

Referring to my last comment attaching Tmap section mapping.

Regards

Tarunjit Singh

Tmap.png

Re: Add JSON Result Into DB Table

Anonymous — Wed, 14 Feb 2018 07:29:47 GMT

Hi,

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

Job Design.png

Re: Add JSON Result Into DB Table

Anonymous — Sat, 07 Jul 2018 10:24:56 GMT

Can you show us Jsonextract component?