**Overview :**

In this article we will see how to use sharepoint spoke in ServiceNow along with its setup. I will be making three articles on this topic :

1. Mainly to show how to setup the spoke and how it behaves OOB.
2. Second one to show how can you fetch custom attributes and how can you edit the spoke for that.
3. How to make use of CAML query to fetch data from sharepoint using specific query.

**Why sharepoint spoke?**

This spoke helps in fetching folder information, files information and copy/move the file to specific location using ServiceNow and REST API calls from sharepoint. I can imagine that in organization there can be a process to copy attachments from ServiceNow records into sharepoint folder and vice versa, also I am big fan of control testing in GRC and this spoke can be used to get evidences from sharepoint folders and make decision if the control is compliant or not. Another example I can tell is adding and removing user from group in sharepoint, this helps us to follow approval process in ServiceNow and helps in audits and have control on this use case removing the overhead of emails.

More information about sharepoint API can be found here : [LINK](https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/get-to-know-the-sharepoint-rest-service?tabs=csom)

**Pre-requisite :**

1. IntegrationHub Subscription as mentioned [here](https://docs.servicenow.com/bundle/paris-servicenow-platform/page/administer/integrationhub-store-spokes/concept/sharepoint-online-spoke.html)
2. Azure AD account because we are going to use Site collection method in this article. More information is [here](https://docs.servicenow.com/bundle/paris-servicenow-platform/page/administer/integrationhub-store-spokes/task/conf-sharept-site.html)
3. Microsoft Sharepoint spoke activated in instance.

**Set-up :**

Let’s start and see how to set up the spoke and test it with some OOB actions. It is good know that OOB ServiceNow provides more that 60 actions which performs specific function. So you can use them as per your need. If you want to see the list then go [here.](https://docs.servicenow.com/bundle/paris-servicenow-platform/page/administer/integrationhub-store-spokes/concept/sharepoint-online-spoke.html#d1777819e288) Please see the video below to understand the detailed setup procedure. High level the steps are:

1. Azure AD subscription.
2. oAuth Registration in ServiceNow.
3. Credentials in credentials table in ServiceNow
4. Credential alias and connection in ServiceNow.
5. Tenant Setup in ServiceNow.

**Next:**

Stay tuned for next article on how to get custom attributes for a folder in sharepoint from ServiceNow using sharepoint API.

Please see the videos and let me know the feedback. Thank you for watching.

**Thanks and Regards,**
**Ashutosh Munot**

**[ServiceNow Community MVP and Dev MVP 2019/2020](https://community.servicenow.com/community?id=community%5Fblog&sys%5Fid=fb488720dbaacc504819fb2439961900)**

**[My Article and Blogs](https://community.servicenow.com/community?id=community%5Fuser%5Fprofile&user=2a131665db1c1fc09c9ffb651f9619fb)**

**[YouTube Channel](https://www.youtube.com/channel/UCf7bnvR3MOiJN5tDxLZPNuw?view%5Fas=subscriber)**