SharePoint
Microsoft SharePoint is a collaborative workplace. You can use it as a secure place to store, organize, share, and access information from any device. With the help of this single platform, people from inside and outside of the organization can work together.
- 1 Authorization
- 1.1 Basic Auth
- 1.2 OAuth 2.0
- 2 Sharepoint Connections
- 3 Actions
Authorization
Basic Auth
SharePoint Basic authentication enables a web browser to provide credentials when the browser makes a request during an HTTP transaction. It’s required as the user credentials are not encrypted for network transmission but are sent over the network in plaintext. To use basic authentication, you are required to enable Secure Sockets Layer (SSL) encryption for the website otherwise, the credentials can be intercepted by any harmful user. SharePoint uses a web application named Internet Information Services (IIS) website for creating the server. The configuration of basic authentication can be conducted for one or more zones in the SharePoint. You can get the basic authentication token by passing user name and password. The Basic authentication (password is sent in clear text) in the Claims Authentication Types section of the Create New Web Application dialog.
Key | Description | Example |
|---|---|---|
Username | Username is the sign in name of the users for accessing SharePoint. | w|contoso\adam |
Password | It is a secret phase that helpful for protecting the data. | ****************** |
OAuth 2.0
SharePoint doesn’t support OAuth 2.0 authentication directly. However, you can set up a OAuth 2.0 authentication process for your portal through the SharePoint integration with the Microsoft Azure applications. To do that, you first have to enable and configure SharePoint with the Microsoft Azure.
To register SharePoint with Microsoft Azure click on the access link : https://portal.azure.com/#home.
Now, go to the Search Bar and Search For “App Registration”.
To register the new application click on the “New Registration”, now provide a suitable name to the application.
Provide the URL for redirect, here you need to select “Web”
After the registration copy the “Client ID” and “Tenant ID”
Now, click on the “Certificates and Secrets” from the manage palette.
Add the “New Client Secret”, now copy the secret, i.e., “Value”
Add the required permission from the API Permissions in the Palette.
Key | Description | Example |
|---|---|---|
Client ID | The Client ID is a unique identifier for conducting the authorization server. |
|
Tenant ID | Tenant ID is a unique identifier that is different than your organization name or domain. |
|
Client Secret | The Client Secret is a secret known only to the application and the authorization server. |
|
Certificates and Secrets | The secrets provides secure storage, such as passwords and database connection strings. The certificates, allow you to built the keys and secrets and also add an automated renewal feature. |
|
Sharepoint Connections
Sharepoint Basic Connection
Input | Key | Description | Example |
Select application | application | Select SharePoint application |
|
Connection type | connection type | Select the type of connection. | REST |
Rest connection type | Rest Connection Type | Select the Basic connection type | Basic |
Connection name | name | Provide a name for the connection. | SharePoint |
Connection description | description | Provide a description for the connection. |
|
Host name | host | Provide a string value for the URL of the user's SharePoint account. |
|
Username | username | Provide a valid username for the given SharePoint account. | exampleUser |
Password | password | Provide a password to authenticate all requests with. Cloud users need to generate an API token for this value. | exampleSecurePassword |
Header field | header | Provide the path of the endpoint for authentication. | Authorization |
Header prefix header | header prefix | Select the header prefix - |
|
Sharepoint OAuth 2.0 Connection
Input | Key | Description | Example |
Select application | application | Select SharePoint application |
|
Connection type | connection type | Select the type of connection. | REST |
REST connection type | rest connection type | Select the type of REST connection. | OAuth2.0 |
Connection name | name | Provide a name for the connection. | SharePoint connection |
Connection description | description | Provide a description for the connection. |
|
Host name | host | Provide a string value for the URL of the user's SharePoint account. |
|
Grant type | grant type | Provide the grant type - authorization code, password, client credentials. |
|
Actions
Create Item In the List
Create item in the list | key: createItemlist
Input | Key | Description | Example |
|---|---|---|---|
Site ID | Site_ID | It is a unique identification number that is allocated to your website when added to the Siteimprove platform. The Site ID is presented as the last number of the URL allocated at the time of the siteimprove dashboard for the selected site. | https://graph.microsoft.com/v1.0/sites/{hostname}:/sites/{path}?$select=id |
List ID | List_ID | It’s a unique ID that is associated with a specific list. The list id can’t be modified. The List Id can be navigated from the SharePoint list. You can copy the URL for finding the ID. | Demonstration List |
Create Folder
Create folder | key: createFolder
Input | Key | Description | Example |
|---|---|---|---|
Folder Name | Folder_Name | Provide the name of the SharePoint folder name. This name needs to unique, as a duplicate name will not be accepted. | Sample |
Site ID | Site_ID | It is a unique identification number that is allocated to your website when added to the Siteimprove platform. The Site ID is presented as the last number of the URL allocated at the time of the siteimprove dashboard for the selected site. | https://graph.microsoft.com/v1.0/sites/{hostname}:/sites/{path}?$select=id |
Folder | folder | The folders in SharePoint helps the users to easily manage files in systematic manner. SharePoint list and libraries enables folder view in a default manner. You can also choose the folder by using a filter. It will allow you to get the required file or folder in a appropriate manner. |
|
Get List Items In the Site
Get List Items In the Site| key: createListItemSite
Input | Key | Description | Example |
|---|---|---|---|
Site ID | Site_ID | It is a unique identification number that is allocated to your website when added to the Siteimprove platform. The Site ID is presented as the last number of the URL allocated at the time of the siteimprove dashboard for the selected site. | https://graph.microsoft.com/v1.0/sites/{hostname}:/sites/{path}?$select=id |
List ID | List_ID | It’s a unique ID that is associated with a specific list. The list id can’t be modified. The List Id can be navigated from the SharePoint list. You can copy the URL for finding the ID. | Demonstration List |
Get Item Details By ID
Get item details by ID | key: getItembyID
Input | Key | Description | Example |
|---|---|---|---|
Site ID | Site_ID | It is a unique identification number that is allocated to your website when added to the Siteimprove platform. The Site ID is presented as the last number of the URL allocated at the time of the siteimprove dashboard for the selected site. | https://graph.microsoft.com/v1.0/sites/{hostname}:/sites/{path}?$select=id |
List ID | List_ID | It’s a unique ID that is associated with a specific list. The list id can’t be modified. The List Id can be navigated from the SharePoint list. You can copy the URL for finding the ID. | Demonstration List |
Item ID | Item_ID | The Item Id is the unique number or id for the specific item or folder of the SharePoint. The specific items or folders can be found by using filters. | Sample |
Update Item In the List
Update item in the list | key: updateItemList
Search Items In the List
Search item in the list | key: searchItemList
Input | Key | Description | Example |
|---|---|---|---|
Search Text | search_text | The search text option allow you to search the particular document from the library. With the help of this option you will be able to find the document by typing the specific text/Keyword. | “Sample”, “Support” |
Create Item In Sapper DataBase
Create item in Sapper Database | key: createItemSapperDatabase
Input | Key | Description | Example |
|---|---|---|---|
Site ID | Site_ID | It is a unique identification number that is allocated to your website when added to the Siteimprove platform. The Site ID is presented as the last number of the URL allocated at the time of the siteimprove dashboard for the selected site. | https://graph.microsoft.com/v1.0/sites/{hostname}:/sites/{path}?$select=id |
List ID | List_ID | It’s a unique ID that is associated with a specific list. The list id can’t be modified. The List Id can be navigated from the SharePoint list. You can copy the URL for finding the ID. | Demonstration List |
Update Employee In Sapper Database
Update employee in Sapper Database | key: updateEmployeeSapperDatabase
Input | Key | Description | Example |
|---|---|---|---|
Site ID | site_ID | It is a unique identification number that is allocated to your website when added to the Siteimprove platform. The Site ID is presented as the last number of the URL allocated at the time of the siteimprove dashboard for the selected site. | https://graph.microsoft.com/v1.0/sites/{hostname}:/sites/{path}?$select=id |
List ID | list_ID | It’s a unique ID that is associated with a specific list. The list id can’t be modified. The List Id can be navigated from the SharePoint list. You can copy the URL for finding the ID. | Demonstration List |
Item ID | item_ID | The Item Id is the unique number or id for the specific item or folder of the SharePoint. The specific items or folders can be found by using filters. | Sample |