Read JSON File

[Anonymous]

Hi, 

i can't find any solution for this case, so maybe the community can help me with my problem. 

I am trying to import a Json File and Export it to a csv.

My problem is that I am not able to extract the information:

Here is an Example:

{"Test_Recieved":{"KN552":"2022-07-19","KN5524":"2016-07-01","KN55244":"2018-07-17","KN455":"2018-07-09","KN4432":"2018-08-01"}}

Could you please help me to extract the information for my csv file e.g

ID  | Date

KN552 |2022-07-19

...|.....

Best regards!

nuglo

[vapukov]

search is often help

https://community.talend.com/t5/Design-and-Development/Unable-to-parse-JSON-quot-name-quot-using-tEx...

after prepare list of keys you just need iterate over all and extract values for each key