Icon

Google Search Console - Get data via API - public

Google_Search_Console_API

URL: Forum Post https://forum.knime.com/t/having-difficulties-setting-up-post-request-to-google-api-requiring-oauth2-0/30000

Y ou can use this workflow to load your website's Googlesearch data into Knime, via the Google Search API.(Based on the 'Google_Search_Console_API' workflow byPhilipp Katz) Build“Authorization” header (based on theretrieved access_token)Create the request URLSpecify HTTP method “POST”GetdataSERPdataTake the *refresh token*and exchange it fora fresh access tokenSet: API Key,API secret,ScopeSet yoursite URLsLoop forevery site URLsSet start andend dateDate asstringsQuerystart dateend datejsonstep 1jsonstep 2SERPdata ina csv file String Manipulation String Manipulation String Manipulation Column Appender HTTP Retriever Parse JSON Response Table View(JavaScript) Column Filter Get Access Token OAuth Connector Table Creator Table Row toVariable Loop Start Loop End Date&TimeConfiguration Variable toTable Row Column Expressions ContainerInput (JSON) JSON to Table Table Rowto Variable Cell Updater Cell Updater Table to JSON Column Filter CSV Writer You can use this workflow to load your website's Googlesearch data into Knime, via the Google Search API.(Based on the 'Google_Search_Console_API' workflow byPhilipp Katz) Build“Authorization” header (based on theretrieved access_token)Create the request URLSpecify HTTP method “POST”GetdataSERPdataTake the *refresh token*and exchange it fora fresh access tokenSet: API Key,API secret,ScopeSet yoursite URLsLoop forevery site URLsSet start andend dateDate asstringsQuerystart dateend datejsonstep 1jsonstep 2SERPdata ina csv file String Manipulation String Manipulation String Manipulation Column Appender HTTP Retriever Parse JSON Response Table View(JavaScript) Column Filter Get Access Token OAuth Connector Table Creator Table Row toVariable Loop Start Loop End Date&TimeConfiguration Variable toTable Row Column Expressions ContainerInput (JSON) JSON to Table Table Rowto Variable Cell Updater Cell Updater Table to JSON Column Filter CSV Writer

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: pk
Created at: 2021-01-27
On NodePit since: 2024-03-09
Last update: 2024-04-27
Created with KNIME version: v5.2.1
Tags: restoauthoauth2palladiangoogle

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

Try NodePit Runner!