0

I have a url I am using to query a list in Sharepoint formatted as below.

http://sites/sites/site/_api/web/lists/getbytitle%example%/items?$select=Email/EMail&$expand=Email

Because my list has over 100 items, I would like to add a $top=1000 to get all of the items.

However, I can't seem to figure out how to add this to my query.

Is this possible or do I have to rework something?

  • Nevermind, I added the & sign and it is working – Ryan Aug 12 at 19:03
1

Yes, It is possible to fetch the 1000 items using $top.

Use something like below:

 https://domain/sites/site/_api/web/lists/getbytitle('example')/items?$select=Email/EMail&$expand=Email&$top=1000

Also, I noticed in URL, you have used:

/lists/getbytitle%example%/

Is it working correctly?

If Not, it should be like :

/lists/getbytitle('example') 

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.