SOLVED

REST query Sharepoint 2013

Highlighted
Contributor

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/_api/web/lists/GetByTitle('mylist')/items?$select=Title&$filter=year%20eq%202017&sortlist=%27Title:descending%27 


Thank you!

4 Replies
Highlighted
Highlighted

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

Highlighted
Solution

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
Highlighted
$top is fine. I can retrieve all the items and then work with them. Thank you!