JSON Path Configuration Help

[rfeigel]

I’m trying to extract article data from Semantic Scholar. I’m having problems with the author data. I’d like to extract the authorid(s) and name(s), but can’t figure our how to configure the query. Can some please help?

Here’s my current query and the output:

[mlauber71]

@rfeigel mark the author cell (click until the highlight fits the selection you want), create a collection colum which you later can split or ungroup.

JSON dynamic array search

@Brotfahrer I built a demo workflow to show how you might approach this issue. The key might be to use dynamic searches for certain values in the XML/JSON file and then continue the extraction. KNIME also offers nodes to sort of automatically extract JSON structures but they might run quite long and maybe produce results that can be hard to interpret. OK so first you search for the cell and the path where your desired object “VGSNAG3” might be found. JSON Path should offer a broaf variety of s…

need help formatting json

@bleak welcome to the KNIME forum. Maybe you could check out these hints. The secret is in the combination of a path definition and often an ungroup node. Also the recent Jut KNIME It Challenge worked with this combination. If you could upload a sampel of you data without spelling any secrets someone might have a look.