How to extract array values from JSON data?

SJeshwani1618330394 — Fri, 15 Nov 2024 23:35:43 GMT

Hi,

I am using tHttprequest component to extract JSON data:

the response looks like this:

{

"xllcorner": "593271.91",

"yllcorner": "5521992.65",

"cellsize": 231.656358264,

"nrows": 9,

"ncols": 9,

"band": "250m_16_days_NDVI",

"units": "NDVI ratio - No units",

"scale": "0.0001",

"latitude": 49.67,

"longitude": 8.26,

"subset": [

{

"modis_date": "A2021249",

"calendar_date": "2021-09-06",

"band": "250m_16_days_NDVI",

"tile": "h18v04",

"proc_date": "2021266003815",

"data": []

{

"modis_date": "A2021265",

"calendar_date": "2021-09-22",

"band": "250m_16_days_NDVI",

"tile": "h18v04",

"proc_date": "2021282010410",

"data": []

}

]

}

From Talend, I am using tJSONExtractFields. However, I am getting the array values in one cell.

Please find the log output in the attached screenshot:

How to separate these values in different columns?

Regards,

Sheetal

Re: How to extract array values from JSON data?

Anonymous — Tue, 26 Oct 2021 05:13:56 GMT

What are your expected result? With this json data, you should be able to extract each array value as one row, see

Regards

Shong