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!

[Ashutosh Munot1]

Great now please walk me through your use case in detail. What i understood is that you want to fetch the excel from sharepoint and put it in servicenow?

For now ignore MId server.

Thanks,
Ashutosh

[Niranchana2]

Sure @Ashutosh Munot 

Requirement is one of our 3rd party application will place daily call data via Excel in sharepoint site for every 2 hrs once or 24 hrs once.

we need to import the Excel data to our custom table in servicenow.

we have one separate sharepoint site with External user access to place the Excel file.

How can we achieve this using IntegrationHub?

[Ashutosh Munot1]

HI,

That is possible using sharepoint spoke in integrationhub. You can attach that excel to a data source record and trigger that data source which will create record in target table.

Thanks,
Ashutosh

[Niranchana2]

Thanks @Ashutosh Munot  

you mean to say using 'Attach a sharepoint file to a record' Action in SharePoint spoke.

Have you done this?

[Ashutosh Munot1]

Yes. That is the one.

Thanks,
Ashutosh