How to extract array values from JSON data?

[SJeshwani1618330394]

Hi,

I am using tHttprequest component to extract JSON data:

The URL is: https://modis.ornl.gov/rst/api/v1/MYD13Q1/subset?latitude=49.67&longitude=8.26&band=250m_16_days_NDV...

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,

"header": "https://modisrest.ornl.gov/rst/api/v1/MYD13Q1/subset?latitude=49.67&longitude=8.26&band=250m_16_days...",

"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

[Anonymous]

Hi

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

 

Regards

Shong