# How to utilize Offset-based pagination with Extract Profile

**URL:** <https://matillioncommunity.discourse.group/t/how-to-utilize-offset-based-pagination-with-extract-profile/1534>\
**Category:** Matillion ETL\
**Created:** [October 28, 2021, 10:49pm UTC](https://matillioncommunity.discourse.group/t/how-to-utilize-offset-based-pagination-with-extract-profile/1534 "2021-10-28T22:49:09Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![james3](https://avatars.discourse-cdn.com/v4/letter/j/b5e925/32.png) [@james3](https://matillioncommunity.discourse.group/u/james3)\
**Post date:** [October 28, 2021, 10:49pm UTC](https://matillioncommunity.discourse.group/t/how-to-utilize-offset-based-pagination-with-extract-profile/1534/1 "2021-10-28T22:49:09Z")

</div>

There is only documentation on how to use Offset-based pagination using the API Query Profile but I'm not able to find any info on how to do this using the Extract Profile, even though there is a paging option in the Extract connector.

&nbsp;

Is there a way to use the Loop Iterator component with the API Extract component?

---

<div class="post-metadata">

**Author:** ![vinod.patil2](https://avatars.discourse-cdn.com/v4/letter/v/e480ec/32.png) [@vinod.patil2](https://matillioncommunity.discourse.group/u/vinod.patil2)\
**Post date:** [September 9, 2022, 12:43pm UTC](https://matillioncommunity.discourse.group/t/how-to-utilize-offset-based-pagination-with-extract-profile/1534/2 "2022-09-09T12:43:15Z")

</div>

You have to mention offset based value and limit and also whatever column just right click on that and set count

you can find in matillion document regarding offset based patination.

&nbsp;

https://documentation.matillion.com/docs/6753241

---

<div class="post-metadata">

**Author:** ![ShovivSoftware](https://sea2.discourse-cdn.com/flex002/user_avatar/matillioncommunity.discourse.group/shovivsoftware/32/25_2.png) [@ShovivSoftware](https://matillioncommunity.discourse.group/u/ShovivSoftware)\
**Post date:** [October 4, 2022, 11:19am UTC](https://matillioncommunity.discourse.group/t/how-to-utilize-offset-based-pagination-with-extract-profile/1534/3 "2022-10-04T11:19:35Z")

</div>

I am also curious about this query!