Icon

KNIME Weather Station Web Service

Weather Station Web Service
Getting Request from client and convertingit into Table form Producing Response as:- input data - timestamp - Status Snowflake update (200 / 315)- Status Google Sheet update (200 / 315) Weather Station Web Service- Request includes {humidity, temperature,pressure} JSON format- Response includes {humidity,temperature, pressure, timestamp, statussnowflake update, status Googlesheetupdate} JSON formatStatus succsess = 200Status failure for Snowflake= 312Status failure for Google Sheets= 315Each component based on Try-Catchconstruct and including update of log file.Log file with details in:current workflow data area / log_details.csv get weather datafrom RequestConvert JSONto TableJoin Timestampwith input dataSelect columnsto convert to JSONoutput at client endFinal Respponseat client endUpdates theSnowflake DatabaseUpdates a Google Sheet asbackupexecution timeas timestamp ContainerInput (JSON) JSON to Table Joiner Columns to JSON ContainerOutput (JSON) Update SnowflakeDatabase Update GoogleSheets Timestamp = now Getting Request from client and convertingit into Table form Producing Response as:- input data - timestamp - Status Snowflake update (200 / 315)- Status Google Sheet update (200 / 315) Weather Station Web Service- Request includes {humidity, temperature,pressure} JSON format- Response includes {humidity,temperature, pressure, timestamp, statussnowflake update, status Googlesheetupdate} JSON formatStatus succsess = 200Status failure for Snowflake= 312Status failure for Google Sheets= 315Each component based on Try-Catchconstruct and including update of log file.Log file with details in:current workflow data area / log_details.csv get weather datafrom RequestConvert JSONto TableJoin Timestampwith input dataSelect columnsto convert to JSONoutput at client endFinal Respponseat client endUpdates theSnowflake DatabaseUpdates a Google Sheet asbackupexecution timeas timestamp ContainerInput (JSON) JSON to Table Joiner Columns to JSON ContainerOutput (JSON) Update SnowflakeDatabase Update GoogleSheets Timestamp = now

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: Ali.Marvi
Created at: 2021-06-01
On NodePit since: 2021-09-20
Last update: 2024-04-26
Created with KNIME version: v4.4.1
Tags: WebServiceAPISnowflakeGoogleSheets

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

Try NodePit Runner!