[Sharepoint Connector] How to get video URL from document library in share point
Forge component by Chris Johnson
Application Type
Reactive
Service Studio Version
11.10.8 (Build 37957)
Platform Version
11.9.0 (Build 17011)

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.

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.