Icon

01.1_​Get_​Request_​Solution

Solution: Sending a GET Request

This workflow retrieves product information via a GET request

Data loading Session 1Exercise 1.1 - GET requestsSummary:In this exercise we are going to use GET Request node to load the productsinformation based on the product category. Retrieve data using GETRequests node, transform the JSON output and extract the askedinformation into a data table.Instructions:1) Execute the Table Creator node to load the list of the product categories2) Use a String Manipulation node to create the urls with this format: https://fakestoreapi.com/products/category/{product_category}3) Use a GET Request node to load the list products information related toeach category4) Extract the product id and product price related to each product categorywith the JSON Path and Ungroup nodes Creating and formatting the URLs for theGET Request node Transforming the JSON data and extractingthe products information Requesting for the data using theGET Request node Hint: - While requesting for the data using GETrequest node, make sure to set thetimeout(s) configuration to 15 or above. Product CategoriesUngroup to getrow-wise records Request data from a websiteCreate the urlsExtract productsID and priceTable Creator Ungroup GET Request String Manipulation JSON Path Data loading Session 1Exercise 1.1 - GET requestsSummary:In this exercise we are going to use GET Request node to load the productsinformation based on the product category. Retrieve data using GETRequests node, transform the JSON output and extract the askedinformation into a data table.Instructions:1) Execute the Table Creator node to load the list of the product categories2) Use a String Manipulation node to create the urls with this format: https://fakestoreapi.com/products/category/{product_category}3) Use a GET Request node to load the list products information related toeach category4) Extract the product id and product price related to each product categorywith the JSON Path and Ungroup nodes Creating and formatting the URLs for theGET Request node Transforming the JSON data and extractingthe products information Requesting for the data using theGET Request node Hint: - While requesting for the data using GETrequest node, make sure to set thetimeout(s) configuration to 15 or above. Product CategoriesUngroup to getrow-wise records Request data from a websiteCreate the urlsExtract productsID and priceTable Creator Ungroup GET Request String Manipulation JSON Path

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: victorpalacios
Created at: 2022-02-16
On NodePit since: 2023-04-06
Last update: 2024-05-01
Created with KNIME version: v4.7.2
Tags: education

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

Try NodePit Runner!