0 ×

Get SP AccessToken

ExcelPasswordManager-Node extension for KNIME Workbench version 1.0.0.v202104081307 by AnotherFraudExcel

This nodes generates an access token to your Sharepoint using the Sharepoint rest v1 API
For details on the API see: https://docs.microsoft.com/en-us/previous-versions/office/developer/sharepoint-rest-reference
You will have to setup your SharePoint/MS Teams SharePoint: https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/register-sharepoint-add-ins
An example on how to use the rest API manually or through single httpPosts (e.g. with the post node) see: https://global-sharepoint.com/sharepoint-online/in-4-steps-access-sharepoint-online-data-using-postman-tool/
Node Code can be found here: https://github.com/AnotherFraud/AF-Excel-Writer

Options

Client ID
Client ID of the connection you setup in the appregnew SharePoint service e.g.: https://MySharePointOnlineSiteUrl/_layouts/15/appregnew.aspx Can be found in the SharePoint Website app authorization configuration
Tennant ID
Tennant ID of you SharePoint Can be found in the SharePoint Website app authorization configuration
SharePoint Online Site URL
Enter the url to your SharePoint Normally the URL looks like: mySharePoint.sharepoint.com
Client Secret
Client Secret of the connection you setup in the appregnew SharePoint service e.g.: https://MySharePointOnlineSiteUrl/_layouts/15/appregnew.aspx
Proxy Options
In case you are behind an internet proxy. Here you can set the internet host and credentials

Input Ports

Icon
Optional flow variable input

Output Ports

Icon
SharePoint response

Installation

To use this node in KNIME, install AF Utility Nodes from the following update site:

KNIME 4.3

A zipped version of the software site can be downloaded here.

You don't know what to do with this link? Read our NodePit Product and Node Installation Guide that explains you in detail how to install nodes to your KNIME Analytics Platform.

Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform. Browse NodePit from within KNIME, install nodes with just one click and share your workflows with NodePit Space.

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.