# Pagination in Sage Intacct

**URL:** <https://connective.celigo.com/t/pagination-in-sage-intacct/4193>\
**Category:** Integrator.io\
**Tags:** export\
**Created:** [April 9, 2025, 10:16am UTC](https://connective.celigo.com/t/pagination-in-sage-intacct/4193 "2025-04-09T10:16:25Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![G\_V\_KiranKumar\_Sunka](https://avatars.discourse-cdn.com/v4/letter/g/b4bc9f/32.png) [@G\_V\_KiranKumar\_Sunka](https://connective.celigo.com/u/G_V_KiranKumar_Sunka)\
**Post date:** [April 9, 2025, 10:16am UTC](https://connective.celigo.com/t/pagination-in-sage-intacct/4193/1 "2025-04-09T10:16:25Z")

</div>

Hi Team,

What is the pagination method for exporting data from Sage Intacct?

---

<div class="post-metadata">

**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\
**Post date:** [April 10, 2025, 12:48am UTC](https://connective.celigo.com/t/pagination-in-sage-intacct/4193/2 "2025-04-10T00:48:27Z")

</div>

I'm not sure which endpoint you're going to, and I'm not sure if it varies by endpoint, but I took [query and list users](https://developer.intacct.com/api/company-console/users/#query-and-list-users) as an example.

For this, it uses a simple `offset` body parameter in the XML.

 ![The image displays a table of parameters for querying and listing users, detailing their names, requirements, types, and descriptions with an arrow pointing to the "offset" parameter description. (Captioned by AI)](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/2/2a01e328cf478b5032fd53b31a41e8986a217a02.png)

In Celigo, it would look something like this:

 ![The image shows a configuration screen for creating an export with HTTP request body and paging method options highlighted by red arrows. (Captioned by AI)](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/f/f280454500c72df849548dbefaec2031affa0c01.png)

---

<div class="post-metadata">

**Author:** ![G\_V\_KiranKumar\_Sunka](https://avatars.discourse-cdn.com/v4/letter/g/b4bc9f/32.png) [@G\_V\_KiranKumar\_Sunka](https://connective.celigo.com/u/G_V_KiranKumar_Sunka)\
**Post date:** [November 5, 2025, 2:07pm UTC](https://connective.celigo.com/t/pagination-in-sage-intacct/4193/3 "2025-11-05T14:07:12Z")

</div>

Hi **Tyler Lamparter,**

If I add the two items below, will pagination work in Celigo when exporting data from Intacct with pagination? If not, could you please help with this? I tried multiple ways but it's not working.

 ![image](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/6/66328734dabfc3ec624af3d91595f11bc0dc196e.png)

 ![image](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/e/ec710d41456a8501110da06e16e55b6b9b5a466b.png)

---

<div class="post-metadata">

**Author:** ![G\_V\_KiranKumar\_Sunka](https://avatars.discourse-cdn.com/v4/letter/g/b4bc9f/32.png) [@G\_V\_KiranKumar\_Sunka](https://connective.celigo.com/u/G_V_KiranKumar_Sunka)\
**Post date:** [November 5, 2025, 2:09pm UTC](https://connective.celigo.com/t/pagination-in-sage-intacct/4193/4 "2025-11-05T14:09:26Z")

</div>

I am using the XML below from Celigo to Intacct

```xml
<content>
	<function controlid="2022-06-13T06:21:56+00:00">
		<query>
			<object>ARINVOICE</object>
			<filter>
				<greaterthan>
					<field>WHENMODIFIED</field>
					<value>{{lastExportDateTime}}</value>
				</greaterthan>
			</filter>
			<select>
				<field>TOTALENTERED</field>
				<field>SODOCUMENT.DOCNO</field>
				<field>WHENCREATED</field>
				<field>SODOCUMENT.CREATEDFROM</field>
				<field>STATE</field>
				<field>DOCNUMBER</field>
			</select>
			<options>
				<showprivate>true</showprivate>
				<returnformat>json</returnformat>
			</options>
		</query>
	</function>
</content>

```

---

<div class="post-metadata">

**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\
**Post date:** [November 5, 2025, 6:01pm UTC](https://connective.celigo.com/t/pagination-in-sage-intacct/4193/5 "2025-11-05T18:01:33Z")

</div>

Why are you trying to send in the relative uri and not the body?