Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
pari1
Contributor
Contributor

how to read this Json

{

"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 

Labels (2)
3 Replies
fdenis
Master
Master

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

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

If I use the above am getting null values
abhinav5
Contributor
Contributor

Try this:

Mapping:

Column            Json Query

Report Date    "$.date"