Icon

05. Integrating External Tools - solution

Integrating External Tools - Solution
Activity: Use REST nodes to call an external web service - Use the GET Request node to access the data at: https://raw.githubusercontent.com/tamingtext/book/master/apache-solr/example/exampledocs/books.json - In case of no internet connection use the JSON Reader to read the file from the data directory. - Extract the book titles to a column. - Extract the price to a column. - Extract the author names to a column, where each author occupies one row.How-to:- Use the JSON Path node to output subparts of the JSON query - Extract all possible subparts - Output the subparts as a list- Use the Ungroup node to split the single JSON queries into separate rows- Use the JSON Path node to separate “name“, “author“, and “price“ from the JSON queries(Hint: Right click on a value in the JSON query and select “Add JSONPath“) Convert the stringrepresentation to JSONExtract rows(don't forget to extract as a JSON type)Ungroup the collectionExtract title, author, and price String to JSON JSON Path Ungroup JSON Path GET Request Activity: Use REST nodes to call an external web service - Use the GET Request node to access the data at: https://raw.githubusercontent.com/tamingtext/book/master/apache-solr/example/exampledocs/books.json - In case of no internet connection use the JSON Reader to read the file from the data directory. - Extract the book titles to a column. - Extract the price to a column. - Extract the author names to a column, where each author occupies one row.How-to:- Use the JSON Path node to output subparts of the JSON query - Extract all possible subparts - Output the subparts as a list- Use the Ungroup node to split the single JSON queries into separate rows- Use the JSON Path node to separate “name“, “author“, and “price“ from the JSON queries(Hint: Right click on a value in the JSON query and select “Add JSONPath“) Convert the stringrepresentation to JSONExtract rows(don't forget to extract as a JSON type)Ungroup the collectionExtract title, author, and price String to JSON JSON Path Ungroup JSON Path GET Request

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Maarit Laukkanen
Created at: 2018-09-11
On NodePit since: 2019-08-19
Last update: 2020-03-23
Created with KNIME version: v4.0.0
Tags: RESTJSONGET Requestweb serviceeducation

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!