topic how to read this Json in Talend Studio

how to read this Json

pari1 — Fri, 20 Sep 2019 09:34:26 GMT

{

"data": [{

"Body": "[{\"id\":\"282\",\"Type\":\"Platform\",\"data\":[{\"Date\":\"19\/09\/2019\"]},{\"Date\":\"19\/09\/2019\"]},{\"Date\":\"19\/09\/2019\"]},{\"Date\":\"19\/09\/2019\"]}]"

}]

}

Am trying to read Date Field am getting null values. Can anyone suggest me

Re: how to read this Json

fdenis — Fri, 20 Sep 2019 10:58:46 GMT

guive us more detail how do you try to read it…
what is your component config…
and so on.

Re: how to read this Json

pari1 — Fri, 20 Sep 2019 12:23:33 GMT

Using tfileinputjson to read manually.
Loop Json query: "$.[*].data[*]"
Mapping: "['Report Date']"

If I use the above am getting null values

Re: how to read this Json

abhinav5 — Fri, 20 Sep 2019 12:51:17 GMT

Try this:

Mapping:

Column Json Query

Report Date "$.date"