Forum Discussion
María José Pedreira
Jun 28, 2017Copper Contributor
REST query Sharepoint 2013
Hello, I need to retrieve items with Title repeated twice or more. Can we do it with a REST query? Next url give me all the items, but I need to filter items with occurence 1 https://mysite.com...
- Jun 28, 2017
The 100 items is a way to protect your system. you can overrise this by using $top like this:
_api/web/lists/getByTitle( 'Books')/items?$select=Title&$filter=Author eq 'Mark Twain'&$top=2
Jun 28, 2017
That option doesn't exist.
There is as a solution though:
https://stackoverflow.com/questions/25744763/get-distinct-data-of-sharepoint-list-using-rest-api
María José Pedreira
Jun 28, 2017Copper Contributor
Hi Pieter Veenstra,
My result should retrieve several hundred of items. But the fact is I receive only the first 100 items. Perhaps this behaviour is because my default view shows 100 items. Does this behaviour have sense? Or perhaps I'm understanding something wrong....
My goal is detect repeated items, so I thought about retrieve only the items repeated 1 or more time. But I have to obtain them just after my ajax call, not working with them in an array, because my array populates only with 100 items by call
- Jun 28, 2017
The 100 items is a way to protect your system. you can overrise this by using $top like this:
_api/web/lists/getByTitle( 'Books')/items?$select=Title&$filter=Author eq 'Mark Twain'&$top=2
- María José PedreiraJun 28, 2017Copper Contributor$top is fine. I can retrieve all the items and then work with them. Thank you!