Answered

Sharepoint HTTP request

(0) Share

Report

Posted on by renanfm

I would like to create an HTTP request action to get the same results as Get Files (properties only). However, I can't get the same results when using the HTTP request.
This is the JSON output from Get files (properties only):

This is the JSON output of the SharePoint HTTP request:

Is it possible to get the same results using the request? The reason I want to do this is because it's immensely faster to use the request method.

Categories:

Building flows

All responses (6)

Answers (1)

Sort by

Expiscornovus 33,997 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @renanfm,

With the HTTP request you can use query parameters to retrieve specific details. With a $select query parameter you can specify which fields you want to retrieve. Which fields do you need? Some would require and $expand query parameter as well (like the Editor and Author).
https://learn.microsoft.com/en-us/sharepoint/dev/sp-add-ins/use-odata-query-operations-in-sharepoint-rest-requests

Below is an example

_api/web/lists/getbytitle('Documents')/items?$select=ID,Author/EMail,Editor/EMail&$expand=Author,Editor
renanfm 21 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Expiscornovus,

Thanks for reply, I've tried to adapt this query, but it wasn't work.

I have to change the Uri, because I only want to get by specific folder and when I used the expression "getbytitle" it isn't work.

Even with the change, the output return only ID. And I really need those fields that I post above, like: Filename, link, editor, author

The Output:
Expiscornovus 33,997 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @renanfm

Can you try the below instead? (I used the ID of your folder in the items method)

_api/web/lists/getbytitle('Documentos Compartilhados')/items(210102)?$select=ID,Author/EMail,Editor/EMail&$expand=Author,Editor
renanfm 21 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Expiscornovus,

I got this error message. In translation, it says that the list doesn't exist. That would be because I'm trying to fetch information from a library, right?
Verified answer

Expiscornovus 33,997 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!

Hi @renanfm,

What is the name of your document library? It looks like I used the wrong name in my example.

Can you find the right name in the interface and use that instead?

Happy to help out 😁

I share more #PowerAutomate and #SharePointOnline content on my Blog, Bluesky profile or Youtube Channel
renanfm 21 on at

Like
a
(1)

Report
Copy link

Link copied!

It Worked! Thanks @Expiscornovus