Read excel file on sharepoint using datasource

[Belal Salas1]

Hi

We have a requirement currently to read excel file from SharePoint location and transform the excel using transform map, currently we keep doing this manually, download the file, upload it to data source and transform it, so we want to automate the process by scheduling the import from SharePoint.

I am aware of Microsoft SharePoint Spoke that might be capable of doing so but the client doesn't have integration hub professional.

I am looking for an alternative solution

[Mike_R · Accepted solution]

The simplest way to to just have SharePoint email the file to ServiceNow. Setup the schedule within SharePoint.

When ServiceNow receives the file, automatically put the attachment into a data source and run the transform map

[Belal Salas1]

This sounds a great idea, I have to reach out to sharepoint team for this.

[avivs]

Is it doable with encrypted file? I believe most clients will want SharePoint to send SN encryption file.