SharePoint REST API - Get 2 items only

Question

I want to query Calendar list and get the upcoming 2 events. How should I form my query ?

This is the query I have to read the items from required list :

var url = _spPageContextInfo.siteAbsoluteUrl + "/_api/web/lists/getbytitle('Event')/items?$filter=Active eq 1"

Gaurravs · Accepted Answer · 2016-06-23 05:03:21Z

3

You can add $limit in conjunction with orderby=ID desc to restrict no of returned users

/_api/web/lists/GetByTitle('Event')/items?$filter=Active eq 1$limit=2$orderby=ID desc

You can also use $top=2

/_api/web/lists/GetByTitle('Event')/items?$filter=Active eq 1$top=2

answered Jun 23, 2016 at 5:03

Gaurravs

3,55812 gold badges22 silver badges33 bronze badges

Add a comment |

Savan Gupta · Accepted Answer · 2016-06-23 05:03:05Z

1

var url = _spPageContextInfo.siteAbsoluteUrl + "/_api/web/lists/getbytitle('Event')/items?$filter=Active eq 1$top=2"

answered Jun 23, 2016 at 5:03

Savan Gupta

3302 silver badges17 bronze badges

Add a comment |

2 Answers 2