Can we pull the excel data from SharePoint location?

[Rick54]

Hello,

Can we pull Excel data from SharePoint location to populate the data in the ServiceNow?

Thanks!

[Hitoshi Ozawa]

Haven't done this myself but it seems possible to use Sharepoint REST API got the the excel data and then import it into ServiceNow. May require some scripting and a temporary data storage.

https://blog.atwork.at/post/Access-files-in-OneDrive-or-SharePoint-with-Microsoft-Graph-and-the-Exce...

https://www.servicenowelite.com/blog/2019/6/27/import-configuration-items-with-excel-spreadsheets

[Ashutosh Munot1]

Hi,

We do something on similar lines.

What we do it:

1) put data from Sharepoint to MID Server on one location.

2) We have File import in place from MID Server to servicenow in transform maps.

3) We import the raw data nd them fine tune it and push to target table.

Option two:

We have a rest api as well in place for one specific use case to pull data from Sharepoint which brings data to same import set table.

Thanks,
Ashutosh

[Rick54]

Ashutosh - thanks for the reply. Can you please elaborate the 1, 2 process? I'm curios to see how it was done.

Thanks!

[Ashutosh Munot1]

Hi,

You need one PowerShell script for this which is stored in MID Server Files and that is used to import the data from MID Server into ServiceNow using Scheduled Import mechanism.

Also you can check crossfuze product for this.

Thanks,
Ashutosh