Bridge and Get Sharepoint List Items - No pagination?

Darren Mullen

I'm trying out Bridge's Sharepoint module to get items from a Sharepoint list. The response from Sharepoint only returns a maximum of 200 items.

And the issue is that there doesn't seem to be ANY information in the response about Number of items or pagination.

So… really unsure how this is useful for more than 200 items :)

Seems it will just have to be an API call or am I missing something with this Sharepoint module in Bridge? I do miss obvious settings from time to time. I've looked several times but see nothing about pagination however…

SSFeatures

Hey @Darren Mullen, I think that your assessment is completely accurate.

In this thread Genevieve points out the same limitation, so you might need to perform the API call directly rather than using the SharePoint module.

Here's a link to the SharePoint API documentation for using the $skiptoken to fetch paginated list items:

https://learn.microsoft.com/en-us/sharepoint/dev/sp-add-ins/working-with-lists-and-list-items-with-rest#retrieve-all-list-items

Hope this helps!

Darren Mullen

@SSFeatures appreciated, yes I found that same post from @Genevieve P. .

Thank you for the link, that will help should I go with the API call route. Instead of going down that rabbit hole, I found the Power Automate handles the pagination just fine, so I'll plan on using that should the client be amenable to using Power Automate instead of Bridge because it will be more of a pain to deal with Sharepoint API credentials in Bridge instead of using Power Automate :)

SSFeatures

Hey @Darren Mullen, I think that your assessment is completely accurate.

In this thread Genevieve points out the same limitation, so you might need to perform the API call directly rather than using the SharePoint module.

Here's a link to the SharePoint API documentation for using the $skiptoken to fetch paginated list items:

https://learn.microsoft.com/en-us/sharepoint/dev/sp-add-ins/working-with-lists-and-list-items-with-rest#retrieve-all-list-items

Hope this helps!

Darren Mullen

@SSFeatures appreciated, yes I found that same post from @Genevieve P. .

Thank you for the link, that will help should I go with the API call route. Instead of going down that rabbit hole, I found the Power Automate handles the pagination just fine, so I'll plan on using that should the client be amenable to using Power Automate instead of Bridge because it will be more of a pain to deal with Sharepoint API credentials in Bridge instead of using Power Automate :)

SSFeatures

Oh yea that's a great idea! It makes sense that Power Automate gracefully handles that API call with pagination.

Thanks for explaining that option, so that other people can find it in the future!