# Matillion and Coupa API issue with pagination

**URL:** <https://matillioncommunity.discourse.group/t/matillion-and-coupa-api-issue-with-pagination/2404>\
**Category:** Matillion ETL\
**Created:** [March 26, 2024, 4:35pm UTC](https://matillioncommunity.discourse.group/t/matillion-and-coupa-api-issue-with-pagination/2404 "2024-03-26T16:35:27Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![HelpEric](https://avatars.discourse-cdn.com/v4/letter/h/c68b51/32.png) [@HelpEric](https://matillioncommunity.discourse.group/u/HelpEric)\
**Post date:** [March 26, 2024, 4:35pm UTC](https://matillioncommunity.discourse.group/t/matillion-and-coupa-api-issue-with-pagination/2404/1 "2024-03-26T16:35:27Z")

</div>

I have set up an ENDPOINT in Matillion (query profile) but I have had terrible success in my orchestration getting more than the 50 rows from my process. Has anyone had success or able to assist with the proper setup?

---

<div class="post-metadata">

**Author:** ![ClaireSeniorCommunityManager](https://avatars.discourse-cdn.com/v4/letter/c/7ba0ec/32.png) [@ClaireSeniorCommunityManager](https://matillioncommunity.discourse.group/u/ClaireSeniorCommunityManager)\
**Post date:** [April 3, 2024, 9:51am UTC](https://matillioncommunity.discourse.group/t/matillion-and-coupa-api-issue-with-pagination/2404/2 "2024-04-03T09:51:57Z")

</div>

Hi [@HelpEric](https://matillioncommunity.discourse.group/u/HelpEric)​ and welcome to the forums!

There is a limit of 50 for pagination. If you want more you will need to utilise an offset plus an exported parameter. Please see this [documentation from Coupa for more information](https://compass.coupa.com/en-us/products/product-documentation/integration-technical-documentation/the-coupa-core-api/get-started-with-the-api/querying-options), I hope that helps!

Let us know how you get on! And if anyone has any further suggestions, feel free to post.

Many thanks

Claire