topic Re: SharePoint Excel Data update triggers reload in Connectivity & Data Prep

SharePoint Excel Data update triggers reload

T-Lambourne — Tue, 28 Mar 2023 20:21:43 GMT

I am trying to accomplish a live data scenario where an update to an excel file in SharePoint will trigger a reload of an app so it will pull the data in. I can do the load script to pull the data but I can't figure out a way to trigger the reload besides a scheduled reload. We would like it so after an excel update is saved, the app immediately started to reload.

We currently have this using Qlik Data Transfer but the company is trying to accomplish the same but for a file in SharePoint online.

We are using Qlik Sense Enterprise Saas.

Thanks in advance

Re: SharePoint Excel Data update triggers reload

williejacobs — Thu, 06 Apr 2023 12:17:08 GMT

Hi @T-Lambourne

I would suggest using the sync offline option from SharePoint.

Then use Data Transfer as you would usually.

Re: SharePoint Excel Data update triggers reload

EdgarOlmos — Fri, 07 Apr 2023 00:19:29 GMT

Hi.

In Qlik SaaS you can use this connector to get data directly from SharePoint.

Regards