topic Auto Refresh REST Connector from SharePoint in Connectivity & Data Prep

Auto Refresh REST Connector from SharePoint

Anonymous — Thu, 17 May 2018 11:26:34 GMT

Hi everyone,

I've just created my first REST connector to fetch data from a SharePoint list, and it worked like a charm !!

I wanted to know if there was a way to program the APP to automatically refresh data, as the data in the SharePoint list gets updated frequently and I want to have the latest data updated in my APP.

I initially assumed that "Right Clicking" and APP and choosing "Refresh Published Data" would do the trick, but was definitely wrong as this part would only come after the data inside the APP is refreshed first.

Any help is appreciated

mto, help please, it's critical for a customer demo on Monday

Re: Auto Refresh REST Connector from SharePoint

Michael_Tarallo — Fri, 18 May 2018 23:47:09 GMT

‌Hello Nader

check this out

https://community.qlik.com/blogs/qlikviewdesignblog/2018/01/31/a-beginners-guide-to-incremental-loading

It is a blog and a video that talks about incremental load what you would need to do is replace the data source that I use in the example with your rest connector and then the data would then be written to the QVD file then you would create the script with the logic that then would update the QVD file with the new records and then your app with the visual will read directly from the QVD file and not the rest connector.

I check in on the community occasionally over the weekend so if you reply I might see but basically you want to create a incremental load procedure

Good luck

MIke T

Qlik

Re: Auto Refresh REST Connector from SharePoint

Michael_Tarallo — Fri, 18 May 2018 23:50:51 GMT

After reading this again it actually might be more simple I made a mistake I thought you were looking for refreshing the data in the app from a new load Well keeping data from another load - but if you just want to reload the entire app with new data from the connector then all you need to do is creste a reload task and schedule it in the Qlik management console you do that by adding a task and then selecting the app that you want to refresh You can also select the app in the management console and choose the option to create a reload task

Re: Auto Refresh REST Connector from SharePoint

Anonymous — Sat, 19 May 2018 03:30:01 GMT

Wow, i honestly did not expect a reply that soon.

Thank you for taking the time to do so.

Relating to the above, i thought reload tasks are only available in the Qlik enterprise subscription. Mine is the QSCB, is this also possible here now?

Thank you once again for your help

Re: Auto Refresh REST Connector from SharePoint

Michael_Tarallo — Sat, 19 May 2018 15:00:49 GMT

‌ I thought it might be the business version because of the verbiage you used in your original post so you can schedule

Check this video out and let me know

Qlik Sense Cloud - Refreshing data in Qlik Sense Cloud apps - YouTube

Re: Auto Refresh REST Connector from SharePoint

Anonymous — Sat, 19 May 2018 16:26:59 GMT

Thanks Mike for coming back during weekend time, truly appreciated.

I did try the "Refresh Published Data" earlier on and the problem is that it does not refresh the actual data coming from SharePoint using the REST Connector.

After trying everything, the only thing that actually fetches the latest data from SharePoint is by manually going to the "Data Load Editor" and clicking the "Load Data" button. Even the "Schedule Published Data Refresh" does not work in that perspective.

Is there perhaps a way to schedule the "Data Load Editor" to fetch the data automatically on the QSCB platform?

Many thanks

Re: Auto Refresh REST Connector from SharePoint

Anonymous — Sat, 19 May 2018 16:45:15 GMT

Okay sorry, to clarify a bit further.

It seems the "Published App" gets the latest data which is great, but the same App in "My Workspace" does not.

A bit strange, is this behavior expected?

Thanks

Re: Auto Refresh REST Connector from SharePoint

Michael_Tarallo — Sat, 19 May 2018 18:26:18 GMT

‌hi Nader

That is expected behavior the schedule data refresh is Just for published apps that right clicking and refreshing is just for published apps - to refresh the data in the workspace you have to go into edit mode and load the data from the data manager or from the data load editor hope this helps

Re: Auto Refresh REST Connector from SharePoint

Michael_Tarallo — Sat, 19 May 2018 18:26:49 GMT

‌ after you verify everything please mark the appropriate reply as correct so we can close out this discussion

Re: Auto Refresh REST Connector from SharePoint

Anonymous — Sat, 19 May 2018 19:37:55 GMT

Thank you Mike, got what i need now and working as expected. Appreciated

Re: Auto Refresh REST Connector from SharePoint

james_butler — Mon, 07 Oct 2019 19:53:26 GMT

Hi @Anonymous

Did you use any posts to help you create your first REST connector? If so, please could you post them.

Thanks

James