Four Stars

Trying to read Json File

 

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\"}"}]}

1 ACCEPTED SOLUTION

Accepted Solutions
Eight Stars

Re: Trying to read Json File

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

Sample job layout - 

tExtractJSONField-1.JPG

tFileInputJSON-1.JPG

tExtractJSONField-2.JPG

2 REPLIES
Eight Stars

Re: Trying to read Json File

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

Sample job layout - 

tExtractJSONField-1.JPG

tFileInputJSON-1.JPG

tExtractJSONField-2.JPG

Four Stars

Re: Trying to read Json File

Hi Abhishek,

Thanks for your solution, it help me alot