Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Extracting fields from a JSON output

Hi,

 

I am building a talend standard job to make a call to Rest api and extract the results. The response from the API is a JSON. I am unable to extract the fields using textractJson. Can someone please help.

 

 

Json format is as a follows:

 

{
"validatePostalCodeResponseData" : {
"PostalIdResponse" : [ {
"City" : "WASHINGTON",
"PostalCode" : "20011",
"Province" : "District Of Colombia",
"ProvinceCode" : "DC"
} ],
"ServiceStatus" : {
"ResponseStatus" : 0,
"ErrorCode" : null,
"ErrorDescription" : null
}
}
}|

 

 

The textractjson component settings are attached as image.

 0683p000009LzSr.png

 

Thank you 

Raj.

Labels (4)
2 Replies
Anonymous
Not applicable
Author

try the following

0683p000009LzYe.png0683p000009LzYo.png

 

Anonymous
Not applicable
Author

The bellow setting worked.

 

Thank you

 

Raj.0683p000009LzYy.png