Icon

google sheets meets REST

Solution: Sending a GET Request
Workflow: Chapter3/Exercise1 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 containsemulated 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 copiedinside 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=sharingAfter setting up your Google Sheets Reader node as described in Chapter 3, create an automated workflow to search each product against thefakeStoreApi, 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 toGoogle Sheetscreate the urlsRequest data from a website.You may need to set the timeout(s) configuration to 10.extract productsID and priceUngroup to getrow-wise recordsGoogleAuthentication Google SheetsReader Google SheetsConnection String Manipulation GET Request JSON Path Ungroup Workflow: Chapter3/Exercise1 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 containsemulated 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 copiedinside 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=sharingAfter setting up your Google Sheets Reader node as described in Chapter 3, create an automated workflow to search each product against thefakeStoreApi, 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 toGoogle Sheetscreate the urlsRequest data from a website.You may need to set the timeout(s) configuration to 10.extract productsID and priceUngroup 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: 2022-08-10
Last update: 2024-05-02
Created with KNIME version: v4.5.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!