1

I am using sharepoint REST api. i have query like below:

https://<SITEURL>/_api/lists/getbytitle('listname')/items?$select=ID,StartDate,Modified,DueDate,Body,Status,Assigned/ID,Assigned/Title&$expand=Assigned&$filter=(Status+ne+%27Completed%27)&$orderby=StartDate+desc&$top=20

so i get nexturl in response like below :

https://<SITEURL>/_api/lists/getbytitle('listname')/items?%24skiptoken=Paged%3dTRUE%26p_StartDate%3d20180506%252018%253a30%253a00%26p_ID%3d1426&%24select=ID%2cStartDate%2cModified%2cDueDate%2cBody%2cStatus%2cAssigned%2fID%2cAssigned%2fTitle&%24expand=Assigned&%24filter=(Status+ne+%27Completed%27)&%24orderby=StartDate+desc&%24top=20

But its give some already given data as well it also skip some data also.

Any help will be appreciated.

  • It might be happening because of the encoding. Try to replace '%24' in the nexurl with '$' symbol. – Vishnu S May 30 '18 at 13:01
  • @VishnuS i was tried still not get data some data skipped and give repeated data – Vishal Thakkar May 30 '18 at 13:27
  • Can you try API call with decoded url. Like, decodeURIComponent(nexturl) . – Vishnu S May 31 '18 at 4:28
  • @VishnuS if i decode that url then it will not give next data its just return same data. – Vishal Thakkar May 31 '18 at 4:56
  • Can you try this url in your browser, https://<SITEURL>/_api/lists/getbytitle('listname')/items?%24skiptoken=Paged%3dTRUE%26p_StartDate%3d20180506%252018%253a30%253a00%26p_ID%3d1426&$select=ID%2cStartDate%2cModified%2cDueDate%2cBody%2cStatus%2cAssigned%2fID%2cAssigned%2fTitle&%24expand=Assigned&%24filter=(Status+ne+%27Completed%27)&%24orderby=StartDate+desc&$top=20 – Vishnu S May 31 '18 at 5:11

Your Answer

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

Browse other questions tagged or ask your own question.