# Rest API Page parameter affects sqlfilters

**URL:** <https://www.dolibarr.org/forum/t/rest-api-page-parameter-affects-sqlfilters/22547>\
**Category:** Developing for Dolibarr\
**Tags:** API\
**Created:** [July 23, 2022, 9:12am UTC](https://www.dolibarr.org/forum/t/rest-api-page-parameter-affects-sqlfilters/22547 "2022-07-23T09:12:19Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![tindoshox](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/t/7cd45c/32.png) [@tindoshox](https://www.dolibarr.org/forum/u/tindoshox)\
**Post date:** [July 23, 2022, 9:12am UTC](https://www.dolibarr.org/forum/t/rest-api-page-parameter-affects-sqlfilters/22547/1 "2022-07-23T09:12:19Z")

</div>

I have a situation where I want to to limit results to 20 per page and use the sqlfilters parameter to perform a search.

The error occurs on **Third Parties** and **Invoices**. If try to use _sqlfiters parameter_ together with _page parameter_ I get an error.

Example. These two sceanarios work just fine.  
 ![page](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/1/1257f02b97b4aebb85b10bdf784a1833ceffa26f.png)

![sqlfiters](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/e/eb714a7f12586d82afa0182be63e712af100ec71.png)

However, trying to combine like this:  
 ![PnS](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/1/1ac560464d449d281f28b14d41d89aa21691678a.png)

Will throw an error:  
 ![error](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/f/fc6ae1bc62927a1a98cd454948e301c178e55bb8.png)

Has anyone come across this and is there any solution?

---

<div class="post-metadata">

**Author:** ![tindoshox](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/t/7cd45c/32.png) [@tindoshox](https://www.dolibarr.org/forum/u/tindoshox)\
**Post date:** [July 24, 2022, 9:24am UTC](https://www.dolibarr.org/forum/t/rest-api-page-parameter-affects-sqlfilters/22547/2 "2022-07-24T09:24:10Z")

</div>

Hi. Guys, after some studying I realised that page numbering starts at 0 not 1.
