You can easily download and run the workflow directly in your KNIME installation. We recommend that you use the latest version of the KNIME Analytics Platform for optimal performance.
As you may notice, the workflow nodes are currently not executed (indicated by the red light) because first, you must create an OAuth2 Client ID and enable the Calendar API in the Google Cloud Platform.
Next, in the "Credentials Configuration" node, input the Client ID and Client Secret from your Google Cloud Platform account. These credentials will be passed as a flow variable in the "OAuth2 Authenticator" node.
In the "OAuth2 Authenticator" node, set the Service type as 'Google' and choose "Confidential" as the Client/App type. Then, select the previously generated credentials and define the API call Scope. You can find a list of Google scopes in the 'External resources' section. After this, click the login button to authorize the application to perform actions based on the defined scope on behalf of the login user.
You need the calendar ID in the URL to create the calendar event. We use the String Manipulation (Variable) node to inject the calendar ID into the request URL.
Finally, in the lower branch we create the JSON request body for the calendar event. Set details such as the interviewer and candidate emails, meeting duration (45 minutes), etc. Our example is set up to create a calendar event that spans from the present time to 45 minutes later.
To complete the process in the POST Request node configuration window:
1. Connect the OAuth2 Authenticator port with the POST Request node for authentication.
2. In the first tab, "Connection", configure the request URL.
3. In the "Request body" tab of the POST Request node, pass the JSON request body as a column.
The component contains a Table view that shows the link to the calendar event and other meeting details. You can copy and paste the link to your browser.
This workflow can be expanded to become a more complex data application that helps the company's HR department better manage the interview flow of candidates.
URL: Google Cloud Platform https://console.cloud.google.com/welcome?project=endless-grail-346309
URL: Google Calendar API https://developers.google.com/calendar/api/guides/overview?hl=en
URL: Google Calendar API - Create event JSON example https://developers.google.com/calendar/api/v3/reference/events?hl=en
URL: How to find a Google Calendar Id? https://docs.simplecalendar.io/find-google-calendar-id/
URL: GUID Generator Component - KNIME Community Hub https://hub.knime.com/sjporter/spaces/Public/latest/GUID%20Generator~_D5O4za6bToqQAfi
URL: List of OAuth 2.0 Scopes for Google APIs - Docs https://developers.google.com/identity/protocols/oauth2/scopes?hl=en
To use this workflow in KNIME, download it from the below URL and open it in KNIME:
Download WorkflowDeploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.
Try NodePit Runner!Do you have feedback, questions, comments about NodePit, want to support this platform, or want your own nodes or workflows listed here as well? Do you think, the search results could be improved or something is missing? Then please get in touch! Alternatively, you can send us an email to mail@nodepit.com.
Please note that this is only about NodePit. We do not provide general support for KNIME — please use the KNIME forums instead.