JSON parsing

[ssbaek]

Hi, I want to parse the json file and make it into a table.

The data I want to parse is json_parse_.json (546.1 KB)

issue

1. When the json file is imported with a ‘json reader’, some contents of the file are missing.
2. I’d like to know how to divide the key: value part in the column into each column and row. (Workflow)

Can you answer the issue based on the attached file?
Thank you for you time, regards!

[elsamuel]

Welcome to the forum, @ssbaek,

Are you familiar with the json format? I don’t have a lot of experience with json, but it seems to me that the file you supplied isn’t formatted in the most friendly way.

Here’s a quick example of what I’d do to start attacking the problem:

The first step is to use the JSON Reader node. As far as I can tell, there’s no content missing.

I then used a series of String Replacer nodes to adjust the format of the json file to make it more readable:

After converting the string back to json format, the key step is to use the JSON Path node followed by the Ungroup node to extract the fields you want.

There may be more efficient ways of doing this, but the above should get you started.