Reading JSON dictionary

[alfroc]

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:

Spotify Dataset 1922-2021, ~600k Tracks

Thanks!
Alfredo

[mehrdad_bgh]

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

GL,
Mehrdad

[alfroc]

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

[natanaeldgsantos]

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)

[alfroc]

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