Trying to read Json File

Anonymous — Fri, 27 Jul 2018 19:14:46 GMT

Hi Experts,

I am learning Talend and Struggling with the below Scenario.

I have an JSON input file which i am unable to read using Talend.

I tried JSON Path,Xpath, but its not working.

Can any anyone help me out regarding this issue.

The JSON file :

{"CustomersInfo":[{"Customers":"{\"CustomerName\":\"DATA-27368-Imp Org1\",\"CustomerTypeCode\":\"ORGANIZATION\",\"Address\":\"DATA-27368-1-100 Oracle Parkway\",\"SiteIdentifyingAddressIndicator\":\"Y\",\"CustomerAccountTypeName\":[],\"AccountNumber\":\"DATA-27368-1-ACCT-1\"}"},{"Customers":"{\"CustomerName\":\"Demo Customer\",\"CustomerTypeCode\":\"ORGANIZATION\",\"Address\":\"Any Street 123\",\"SiteIdentifyingAddressIndicator\":\"Y\",\"CustomerAccountTypeName\":\"External\",\"AccountNumber\":\"8002\"}"}]}

Re: Trying to read Json File

iamabhishek — Mon, 30 Jul 2018 16:33:46 GMT

This could be achieved using tFileInputJSON to read the json file and then use tExtractJSONFields to extract each node separately.

Sample job layout -

Re: Trying to read Json File

Anonymous — Tue, 31 Jul 2018 13:39:58 GMT

Hi Abhishek,

Thanks for your solution, it help me alot

topic Re: Trying to read Json File in Talend Studio

Trying to read Json File

Re: Trying to read Json File

Re: Trying to read Json File