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