Add JSON Result Into DB Table

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


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.

 


All 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?

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.