Icon

05. Integrating External Tools

Integrating External Tools
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“) 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“)

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: jon
Created at: 2016-01-29
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!