JSONPath node not interpreting JSON.

[Eltoti]

Hello everyone,

I was just introduced to knime and I’m trying to get along with this.
My goal was to extract a JSON file via get request parse it with JSONPath .

I can do the API request, however when I connect to the JSONPath node there is nothing I can do because I get this message:
"No column in spec compatible with JSONValue

When I try to parse the json value with a online parser, I don’t get any errors.

The get request is the following:
https://agserver.sg.min-economia.pt/arcgis/rest/services/TDP/OpenData_Alojamento_Turistico/MapServer/6/query?where=1%3D1&outFields=*&outSR=4326&f=json

I’ve tried with other requests, some work, other also don’t.

(I also wanted to upload the project, but I’m not sure what file I need to upload. Tried a zip but not possible )

Thank you

[ArjenEX]

Hi @Eltoti

Although you have a json parameter in the query, it’s probably not fully correct because the API returns text/plain;charset=utf-8 as Content-Type. The documentation of the API should help you out what the correct one is. You can pass this as Request Header in the GET request.

You can work around this by adding a String to JSON node. You’ll find that the JSON Path becomes alive subsequently and you can add your desired queries.

[Eltoti]

Thank you so much! That never came across my mind! Have a nice day