HTTP request to get list items while including image thumbnail links

Copper Contributor

Hi all,

 

In Power Automate, if you use the "Get files (properties only)" SharePoint action, the JSON response will include multiple thumbnail URLs (small, medium, large) for each file in the following format: 

 

https://eastus1-mediap.svc.ms/transform/thumbnail?provider=spo&inputFormat=jpg&cs=N2FiNzg2MmMtNDIzFNQ&docid=https%3a%2f%2fmytenant.sharepoint.com%3a443%2f_api%2fv2.0%2fdrives%2fb!XwWFqzfnlvrVjzA9Fk%2fitems%2f01UCDPGRBBQ%3fversion%3dPublished&access_token={long-token-edited-out}&width=800&height=800 

 

 

If possible, I'd like to be able to select one of those URLs while doing an API call like this: 

 

/_api/Web/Lists/GetByTitle('big_document_library')/Items?$select=ID,FileLeafRef,{something-to-get-thumbnail?}&$top=5000

 

Does anyone know if this is possible or what would be the best way to get both items and their corresponding thumbnails in bulk? If possible, I'd like to avoid making separate API requests just to get the thumbnails. Thanks!

 

 

2 Replies

@keenan2345 were you able to get this working? I am also trying to grab viewslifetime count

Ah, unfortunately not! I ended up using the workaround described here to create thumbnail links for each file based on the file path: https://vitalyzhukov.com/en/sharepoint-online-document-thumbnail.

https://{tenant}.sharepoint.com/_layouts/15/getpreview.ashx?path={pathToTheDocument}&resolution=1