Issue using Get Request from API with JSON and converting data to table

[stevelp]

Thanks! I spent some time looking around on some other posts, and found that I could use the JSON reader to extract the data directly from the API. Then I followed a few of the steps for converting JSON to Table (which I still don’t fully understand), but I’m happy that I got it to work!

Here are the posts where I found my solutions:

GET fails if the response does not have Content-Type set

You can use the JSON Reader for this. https://hub.knime.com/knime/extensions/org.knime.features.json/latest/org.knime.json.node.reader.JSONReaderNodeFactory I just tried and it works like a charm

GET Request and JSON to Table

Hi, I’ve build a small example and attached it. First of all, the commas after “idBoard”:"…" have to be removed so that it’s valid. Next we take a JSON to Table Node and create a table. The settings of this node are important in this case: Under Arrays we select ‘Expand to columns (max generate many)’. Next under ‘Children Expansion’ we set ‘Only up to level 1’. These settings allows you to split up your original JSON column into three JSON columns (for each row one). Afterwards the Transpos…