Unanswered

How to use the Sharepoint HTTP widget to get more that 100 rows

(0) Share

Report

Posted on by AlexLindberg

Simple request. I'm using the HTTP widget on a flow to get only the 'Title' and 'ID' columns. The URI looks like:

/_api/Web/Lists/getByTitle('MyListName')/Items/?$select=ID,Title

Returns: (just a ship)

{
 "odata.nextLink": "https://SharepointSiteURL/_api/Web/Lists/getByTitle(%27MyListName%27)/Items?%24skiptoken=Paged%3dTRUE%26p_ID%3d3583&%24select=ID%2cTitle",
 "value": [
 {
 "Id": 3484,
 "Title": "0010c00001stVwwAAE",
 "ID": 3484
 },
 {
 "Id": 3485,
 "Title": "0010c00001stgqOAAQ",
 "ID": 3485
 }
 ... snip ...
 ]
}

That works fine if there are less than 100 rows.

In my case the list may be more that 1000 rows. I have seed posts on how to set the top and pagination when using the SharePoint GET widget. ( @grantjenkins is one example here).

How can I set the "Top" and Pagination values when using the SharePoint HTTP widget?

Thank you for your time.

Alex

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-yueyun-msft on at

Like (1)

Report
Hi , @AlexLindberg

You can add this code after your http request.

&$top=5000

And for more information, you can refer to :
SharePoint REST API read large list items with pagination - SharePoint Stack Exchange

And this is the Share Point API , you can post this issue to the Share Point forum.

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
AlexLindberg 87 on at

Like (0)

Report

That works. I was missing the '&'.

Is there a method to specify pagination so if there are more rows that $top the HTP Get request will 'loop' to get all rows?

Was this reply helpful? Yes No