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

KNIME Analytics Platform
1

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:

image
image1043×650 113 KB

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

image
image1283×441 128 KB

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?

2

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
3

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
4

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