How to push incident ticket data to SharePoint Online List on create/update

[JC S_]

We are trying to develop an integration with SharePoint online in which whenever there is a new ticket created or a ticket is updated on ServiceNow, it will be pushed real time to SharePoint Online List through the SharePoint Online REST APIs. How do we approach this on the ServiceNow side? Basically ServiceNow will need to issue POST requests to SharePoint Online, perhaps through Business Rule? Or are there better way to implement this.

[Dante Ditan]

Hi Jc,

For ServiceNow to Sharepoint integration I would suggest to create it under Soap or Rest messages.

Things you need to configure:

1. credentials

2. end point

3. Methods

I have one sample method came from amazon webservices.

When you click that record the most helpful part is on the related links "Preview script usage".

You can use this script for get,post etc.

for Sharepoint -> ServiceNow.

1. Get the API methods and credentials from their API.

2. Run a schedule job that runs in every 5-10 minutes to get all the details in the Sharepoint.

3. you can loop each result and query it on the target record. If anything change, update the record.

Thank you

Dante