how do I read and transform jason files?

KNIME Analytics Platform
1

Hi, I’ve received a JSON file from our PIM and I would like to read this, transform this and write it back to a JSON file. How do I start? I got as far as the JSON reader. I am not so familiar with connecting to other sources than oracle, excel and tables. So all help is welcome.

2

Hello @cinthy ,
Once you have the JSON file, I am guessing that you might want to parse the JSON data which you can do it using the JSON Path node.

Here’s a simple example by @mlauber71 on parsing JSON data on the KNIME Hub.

Let us know if it helps

Thanks,
Sanket

2 Likes