Reading JSON dictionary

Hi,
is there any way to read a JSON file that it is a dictionary? I’ve tried many approaches without success.
Here you can find the file I’m trying to read:

Thanks!
Alfredo

2 Likes

Hi Alfredo,

I’m not sure if I understand your question correctly but I successfully read the dict_artists.json(288.14 MB) file with JSON Reader node.
You can use JS to string then you can split it with some regex and convert it to JS again.
Sorry if I’m completely wrong :sweat_smile:

GL,
Mehrdad

5 Likes

Hi Mehrdad,
were you even able to convert it to a knime table? If so, can you kindly explain to me how you did it or, rather, give me a copy of your workflow?
Thanks a lot,
Alfredo

1 Like

Hello @alfroc

take a look at the attached workflow and see if it makes sense.

I created two different structures from the Source JSON file. Check if this helps you in any way.

obs: I generated a sample of the source JSON file, because it is very large.

I recommend using a machine with more RAM memory available if you are going to process this file on your local machine using KNIME.

thanks

SAMPLE.knar (21.1 KB)

1 Like

Thank you very much, @natanaeldgsantos!
Now the problem is the memory in my PC…
Best
Alfredo

2 Likes

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.