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

Hi everyone. I’m new to KNIME, and trying to do a few things I have very little experience with. I’m trying to connect to an API, download a JSON file, and convert it to a table.

I have a URL for the API request, which works just fine for outputting a JSON when I paste it into a browser, but when I try using KNIME to get this into a usable data form, I’m not having any luck.

Here’s a screenshot of how I’ve configured the GET Request Tool:

I’ve left almost everything at the default values in the tool, except that I checked the box to “Extract all headers” in the “Response Headers” section.

The response headers seem to come out just fine, but I get a “?” value in the json body. See here:
image

When I hover my mouse over the ?, it says "Missing Value: (not supported content encoding: none)
image

So, I think there’s some issue with how the GET Request node is configured, but I’m not quite sure what to do. I’ve tried using some of the JSON nodes to convert it to a table, but I don’t really know what I’m doing there, and I think my process is failing in the GET Request, so there’s no data to convert to table using JSON nodes.

Any ideas?

Hi;
Maybe these will give you an idea or help. I think it would be useful to review it.

https://www.knime.com/knime-introductory-course/chapter2/section3/sending-get-request-to-rest-service

https://www.knime.com/blog/a-restful-way-to-find-and-retrieve-data

4 Likes

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:

4 Likes

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