Four Stars

Trying to read Json File

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