how to read json data from a web service url and load the data into a table after splitting the json reponse in Talend

Five Stars

how to read json data from a web service url and load the data into a table after splitting the json reponse in Talend

Hi ,

I have a url which on hit gives some json data as response .

Could anyone pls tell me the steps to design a job which calls the web service url and process the json response and then load those attributes into a table ?

 

Could you please elaborate the components and properties in talen  to be set as im new to web service technology??

Sample data after hitting the url :

 

{"@odata.context":"https://api.businesscentral.dynamics.com/v1.0/d8eac0d5-9085-481d-8060-ef90cfce13aa/ODataV4/$metadata#Company('CRONUS%20AU')/G_LEntries","value":[{"Entry_No":1,"Transaction_No":1,"G_L_Account_No":"2110","Posting_Date":"2017-01-17","Document_Date":"2017-01-17","Document_Type":" ","Document_No":"103206","Source_Code":"INVTPCOST","Job_No":"","Business_Unit_Code":"","Reason_Code":"","Gen_Posting_Type":" ","Gen_Bus_Posting_Group":"","Gen_Prod_Posting_Group":"","Tax_Area_Code":"","Tax_Liable":false,"Tax_Group_Code":"","Use_Tax":false,"VAT_Bus_Posting_Group":"","VAT_Prod_Posting_Group":"","IC_Partner_Code":"","Amount":-243,"Debit_Amount":0,"Credit_Amount":243,"VAT_Amount":0,"Additional_Currency_Amount":0,"Add_Currency_Debit_Amount":0,"Add_Currency_Credit_Amount":0,"Dimension_Set_ID":0,"G_L_Account_Name":"Resale Items","AuxiliaryIndex1":"2110"},{"Entry_No":2,"Transaction_No":1,"G_L_Account_No":"7190","Posting_Date":"2017-01-17","Document_Date":"2017-01-17","Document_Type":" ","Document_No":"103206","Source_Code":"INVTPCOST","Job_No":"","Business_Unit_Code":"","Reason_Code":"","Gen_Posting_Type":" ","Gen_Bus_Posting_Group":"","Gen_Prod_Posting_Group":"","Tax_Area_Code":"","Tax_Liable":false,"Tax_Group_Code":"","Use_Tax":false,"VAT_Bus_Posting_Group":"","VAT_Prod_Posting_Group":"","IC_Partner_Code":"","Amount":243,"Debit_Amount":243,"Credit_Amount":0,"VAT_Amount":0,"Additional_Currency_Amount":0,"Add_Currency_Debit_Amount":0,"Add_Currency_Credit_Amount":0,"Dimension_Set_ID":0,"G_L_Account_Name":"Cost of Retail Sold","AuxiliaryIndex1":"7190"},{"

web service  

Five Stars

Re: how to read json data from a web service url and load the data into a table after splitting the json reponse in Talend

Hi Guys,

Could anyone pls help me with this requirement.

Its very urgent 

 

 

Thanks in advance.

Forteen Stars

Re: how to read json data from a web service url and load the data into a table after splitting the json reponse in Talend

@kiran1250,you need to use the below way to extract the json data from URL.

 

tRest--->(main) tExtractjsonfields----->tLogrow

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Five Stars

Re: how to read json data from a web service url and load the data into a table after splitting the json reponse in Talend

Hi,

 

Thanks for the reply.

But what should in add in HTTP headers section in the component properties of tRest.

Could you pls elaborate?

 

Thanks,

Kiran Kumar

Five Stars

Re: how to read json data from a web service url and load the data into a table after splitting the json reponse in Talend

Guys,

Could anyone please help me on this?

 

Thanks in advance

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog