"Get Request" vs. "JSON Reader" - Breaking collection into multiple rows

KNIME Analytics Platform
1

I’m trying to break a JSON collection into multiple rows, so I can create a table with “JSON to Table”.

When I use “JSON Reader”, and specify the JSON path, all is well: it breaks the collection into multiple rows, which “JSON to Table” can use.

I have another API I have to use, though, that requires “GET Request” for the authentication. I use a similar JSON path, but I only get 1 row, for the whole collection! I don’t know what to do… :frowning:

2

FYI, I found a solution: using the “Ungroup” node after the “JSON Path” node.

In my case, it seems like the “Ungroup” functionality is built into the “JSON Reader” node, but not the “JSON Path” node. At least for the way I configured the nodes (having limited JSON and KNIME experience)… :slight_smile:

1 Like
3

Glad it’s working! Thanks for posting your solution.

4

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