Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us at Qlik Connect 2026 in Orlando, April 13–15: Register Here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Abhijeet265
Contributor
Contributor

Reading the MOST recent file in a SharePoint site.

Good Day Everyone 

 

I am using SharePoint365 connector to connect to SP site. Then I use the getFilesList to view all the files and grab the Unique ID of the file I want and then use the getFile function to read the data and Store to finally move it to a different location. 

My requirement is now that the file i need to grab comes on a daily basis, how do I do that ? 

Any ideas ?

Labels (1)
2 Replies
Vicky_Z
Support
Support

some of my thoughts:

 

Use the generated script from the ListFiles table  to load all File Information data including UniqueId for the files

 

Filter the needed UniqueId based on some condition such as TimeCreated or TimeLastMofied value and pass the Id to a variable.

 

Use the variable to create a dynamic url to load data from a single file

 

 

 

fabian3684386
Contributor III
Contributor III

anyone got this to work successfully?