Icon

01_​Get_​Request_​Demo

Solution: Sending a GET Request

This workflow retrieves product information via a GET request

Get Request This exercise is about using the Google Sheets nodes in conjunction with the Get Request node. Retrieve information from the Fake Store API using a GET Request. The fakeStoreApi is a free online REST API that you can use which contains emulated e-commerce and shopping data. Before using the service, obtain the sheet named “Products” from a public Google spreadsheet named “Demo Data”. This sheet needs to be copied inside your own google sheets under the email account which you will use for the Google Authentication node. The sheet can be found here: https://docs.google.com/spreadsheets/d/1p-Vf46I_KFzkk9dOYCHlC2BH3JY6bEnjKSa4euCiJ1o/edit? usp=sharing After setting up your Google Sheets Reader, create an automated workflow to search each product against the fakeStoreApi, as: https://fakestoreapi.com/products/category/<product> To authenticate, you must click the "Authenticate" button and enter your own Google credentials!Sheet "Demo Data" has the spreadsheet "Products" which contains a short list of productsGiven an API connection connects to Google SheetsCreate the urlsRequest data from a website. You may need to set the timeout(s) configuration to 10.Extract producttitle and categoryUngroup to getrow-wise recordsGoogleAuthentication Google SheetsReader Google SheetsConnection String Manipulation GET Request JSON Path Ungroup Get Request This exercise is about using the Google Sheets nodes in conjunction with the Get Request node. Retrieve information from the Fake Store API using a GET Request. The fakeStoreApi is a free online REST API that you can use which contains emulated e-commerce and shopping data. Before using the service, obtain the sheet named “Products” from a public Google spreadsheet named “Demo Data”. This sheet needs to be copied inside your own google sheets under the email account which you will use for the Google Authentication node. The sheet can be found here: https://docs.google.com/spreadsheets/d/1p-Vf46I_KFzkk9dOYCHlC2BH3JY6bEnjKSa4euCiJ1o/edit? usp=sharing After setting up your Google Sheets Reader, create an automated workflow to search each product against the fakeStoreApi, as: https://fakestoreapi.com/products/category/<product> To authenticate, you must click the "Authenticate" button and enter your own Google credentials!Sheet "Demo Data" has the spreadsheet "Products" which contains a short list of productsGiven an API connection connects to Google SheetsCreate the urlsRequest data from a website. You may need to set the timeout(s) configuration to 10.Extract producttitle and categoryUngroup to getrow-wise recordsGoogleAuthentication Google SheetsReader Google SheetsConnection String Manipulation GET Request JSON Path Ungroup

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!