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

[Nitin15]

Hi Ankur,Ami

I simply just want to fetch the list data from Servicenow using rest API.

was looking at sharepoint rest documentatuon but it didn't help me much.

Poins where I am stuck are :

1) I know the endpoint for my list ,but do I have to declare any header atributes etc.

2) what will be the authentication type and parameters ? Token ?

Is there some document or snippet that you can share ?

@Ami scheduled or event driven is no issue , it's only a one time task.

[Ankur Bawiskar]

Hi Nitin,

You want to pull data from sharepoint and you have the end point. If pulling the data is one time task then just use the GET method for getting all the information from sharepoint.

When you configure the REST message just check their documentation whether they are using JSON or XML.

Set your REST message header as below

Authentication type will be basic and just use the id and password for creating basic auth profile if using helsinki or else put username and password in the field and save.

Check in the documentation what GET method accepts as parameter since there should be some query or filter based on which you need to fetch the list from sharepoint.

May be this will help you

CRUD Operation to List Using SharePoint 2013 Rest API - CodeProject

/_api/Web/Lists this can be the end point for REST method GET method

Regards

Ankur

[Nitin15]

I tried, It didn't work.

Have you tried doing it yourself ?

[Ankur Bawiskar]

Hi Nitin,

I have not tried using the sharepoint api.

Regards

Ankur

[kemmy1]

Does this export/import attachments as well?