# How to add a return limit in Sharepoint's API URL

**URL:** <https://community.synatic.com/t/how-to-add-a-return-limit-in-sharepoints-api-url/224>\
**Category:** API Builder/Gateway\
**Tags:** helper-functions\
**Created:** [May 11, 2022, 1:59pm UTC](https://community.synatic.com/t/how-to-add-a-return-limit-in-sharepoints-api-url/224 "2022-05-11T13:59:50Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![navessa](https://yyz2.discourse-cdn.com/flex032/user_avatar/community.synatic.com/navessa/32/58_2.png) [@navessa](https://community.synatic.com/u/navessa)\
**Post date:** [May 11, 2022, 1:59pm UTC](https://community.synatic.com/t/how-to-add-a-return-limit-in-sharepoints-api-url/224/1 "2022-05-11T13:59:50Z")

</div>

The **default** return limit for Sharepoint’s API is **100** records.

In order to set a higher return limit, you need to add “ **?$top=1000** ” in your API URL as highlighted in the below image. It will return the records in batches of 1000.

![image](https://canada1.discourse-cdn.com/flex032/uploads/synatic/original/1X/a451866490f8fd40c0b75bed722c18b1bb0e8569.png)

[How to add a return limit variable in an API URL](https://community.synatic.com/t/how-to-add-a-return-limit-variable-in-an-api-url/188)