How can I use Excel file in Sharepoint folder as data source to import data in target table?

Pratiksha_kadam
Tera Contributor

‎09-15-2023 04:11 AM

Hi Community,

I have to the requirement of data load. The data is present in SharePoint folder in excels [.xlsx/xls] format. This data updated on daily basis. How can I achieve this?

Your response will be very valuable for me.

Thanks in advance🙂

0 Helpfuls
  • 623 Views
1 REPLY 1

karthiknagaramu
Kilo Sage

‎09-15-2023 04:20 AM

Hi,

 

This can be achieved by using Microsoft SharePoint Online IntegrationHUB spoke. This action 'Attach Sharepoint File To A Record' can be leveraged to attach the file data source and trigger the import.

 

But this requires IntegrationHUB subscription.

 

https://docs.servicenow.com/bundle/utah-integrate-applications/page/administer/integrationhub-store-...

 

Regards,

Karthik Nagaramu

0 Helpfuls