ServiceNow and SharePoint integration using Rest API

[Nitin15]

Hi,

I am trying to integrate ServiceNow and SharePoint.

Basically we need to access List record in SharePoint from ServiceNow or Migrate sharepoint data into ServiceNow.

Any help on this will be highly appreciated.

Regards

Nitin

[ami1]

Hi Nitin,

You will have to specify the header in sharepoint and generate a dynamic view name.

Once this is done prepare URL for REST call to query the required records

Put the required details for the REST call like view name, metadata, row limit and you should be able to export the records to excel/csv

This can be imported in ServiceNow easily using transform maps.

[Nitin15]

Hi Ami,

Thank you for your response.

First step where I am stuck is, how do I authenticate my Rest call from ServiceNow.

Basic auth didn't work.

Do you know how to set up OAuth between the two ?

Regards

Nitin

[Teja31]

Hi Nitin,

Have you done integration with sharepoint using REST API or any other way?

Thanks,

Teja

[sheejajose]

Hi,

We are having same requirement need to import html file from sharepoint to servicenow transform map via Custom(load from script) data source. Can you please provide example scripts so that we can utilize it. Thanks 

[ajay_pal]

Hi Nitin,

Integration between ServieNow and Sharepoint can be achieved using SynQ

Here is a video on how it is performed.

You can also follow this blog for more information on integrating between Servicenow to Sharepoint.

Thanks

Ajay