Reading values in JSON collections

[wanglunberlin]

Hi!
Reading JSON collections does not work with the JSON-to-Table node.
I have a workflow that I use to query JSON data from an API and put it into a table. I can read most values using the JSON-to-Table node.
However, collections are not extracted.
I need the information from:
‘authors’: [
{
‘name’: ‘xyz/example.de’
}
]
With the Collection-to-String node, I only get the brackets of the collection ‘’ as a value in the table.
I would be very grateful for any tips on how to read the value of ‘name’.
Best regards,
Sebastian

[gonhaddock]

Hello @wanglunberlin
You can check the following linked topic in KNIME forum, the provided solution may fit to your use case. Otherwise you can provide a sample data for a customized solution.

Not able to convert json to table

Hello @ravi13 I would try to extract the JSON with the following nodes sequence: ‘JSON Path’, then ‘Ungroup’ JSON sets. You can achieve the JSON Path configuration by selecting the table fields, and adding them with the ‘Add collection query’ option. The output will display your data group in sets. And finally Ungroup the JSON sets. [image] [image] BR

BR