How to configure Get Request to retrieve JSON

Dear all,

I was wondering is there any of you ever tried to retrieve the data using GET REQUEST node from any URL, especially contain JSON?

Since there are no more KREST extension in latest version of KNIME,  I tried to retrieve the data using the new node available called "GET REQUEST"  and I found some difficulties using it and configure it. Here is one of the example of URL that I want to retrieve :  http://api.dailymile.com/entries.json .

What I have done so far is I tried to configure the Get Request node by put the url into it and write JSON on the body column name under Flow Variables configuration, and connect this node to JSON Path, but It doesn't work and there's a warning from JSON Path as wel which is: No Column in Spec compatible with JSONValue

Anyone can help me out of this?

 

Thanks!

The current blog post is doing this https://www.knime.org/blog/IBM-Watson-meets-Google-API

It refers to the workflow on the EXAMPLES Server under 01_Data_Access/05_REST_Web_Services/02_IBM_Watson_News-Google_News.

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