2

Can anyone confirm that they are able to page against a SharePoint Online List Items query? Either I'm not understanding how this query is supposed to work or it just doesn't work.

tenant.sharepoint.com/conversations/_api/web/lists/getbytitle('Posts')/items?$skiptoken=Paged=TRUE&P_ID=2

I'm leveraging the documentation here but when using Postman, all items are returned in the same query response. For example, according to the $skiptoken P_ID=2 above, I'm expecting a response without item ID 1. However, I still get ID 1, 2, and 3 in the response.

  • If you're not opposed to using ListData.svc, this still works in Online sjrb.sharepoint.com/sites/welcome/_vti_bin/ListData.svc/… – Colbs Jun 13 '17 at 23:06
  • Interesting, that does work and will probably move forward with this. Thanks! However, I'm still curious to see if anyone's been able to use the REST API to do the same. – Henry Ong Jun 13 '17 at 23:22
  • You're supposed to be able to add the same "top" query string, but it doesn't work for me either – Colbs Jun 13 '17 at 23:32
  • Hmm looks like I was missing out on some URI encoding. This works: tenant.sharepoint.com/conversations/_api/web/lists/getbytitle('Posts')/items?%24skiptoken=Paged%3DTRUE%26p_ID%3D1&%24top=5 – Henry Ong Jun 13 '17 at 23:44
  • there ya go, nice solution! – Colbs Jun 14 '17 at 15:25
6

Needed URI encoding on the $shiptoken parameters - related to this post: Paging using REST/OData with SP 2013

tenant.sharepoint.com/conversations/_api/web/lists/getbytitle('Posts')/items?%24skiptoken=Paged%3DTRUE%26p_ID%3D1&%24top=5
  • Welcome to SharePoint StackExchange :) , Could you please take a quick tour at sharepoint.stackexchange.com/tour to get informed badge! Thank you for your contribution – Mohamed El-Qassas MVP Jun 14 '17 at 0:05
  • Note: "shiptoken" should be "skiptoken." I don't have enough rep to make a 1 character change ;-) – Matt Jun 13 '18 at 20:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.