Read JSON File

Anonymous — Sat, 16 Nov 2024 07:27:46 GMT

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

Re: Read JSON File

vapukov — Tue, 16 Oct 2018 02:40:31 GMT

search is often help

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