Hi Guys, I want to get video url or any resource url from document library in SharePoint using REST GET API in outsystems 11. I don't know what GET API format and structure should I use to get correct url of resource. I am getting binary data from SharePoint successfully but I need url for video streaming. Please let me know if anyone have worked on it.
Hi,
In SharePoint the document libraries are structured in folders and files. For example:
+ site.sharepoint.com/sites/Site1 => Sitecollection / Site / Web
+ Shared Documents
+ Folder1
+ File1.mp4
The URL would be something like this https://site.sharepoint.com/sites/Site1/Shared%20Documents/Folder1/File1.mp4.
You can use 2 useful methods:
• Retrieve all of the files in a folder: GET https://site.sharepoint.com/sites/Site1/_api/web/GetFolderByServerRelativeUrl('Shared%20Documents/Folder1')/Files
• Retrieve URL of a file: GET https://site.sharepoint.com/sites/Site1/_api/Web/Lists/getByTitle('Documents')/items?$select=EncodedAbsUrl&$filter=FileLeafRef%20eq%20%27File1.mp4%27
More info in https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/working-with-folders-and-files-with-rest
Finally, if you are using the Sharepoint Connector, you can add new REST API pointing to second method. You must customize for your needs.
Kinds regards, David.