Extracting fields from a JSON output

Anonymous — Sat, 16 Nov 2024 07:48:28 GMT

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.

Thank you

Raj.

Re: Extracting fields from a JSON output

Anonymous — Thu, 16 Aug 2018 20:00:24 GMT

try the following

Re: Extracting fields from a JSON output

Anonymous — Thu, 16 Aug 2018 23:22:49 GMT

The bellow setting worked.

Thank you

Raj.

topic Extracting fields from a JSON output in Talend Studio

Extracting fields from a JSON output

Re: Extracting fields from a JSON output

Re: Extracting fields from a JSON output