Pagination in Sage Intacct

Integrator.io
1

Hi Team,

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

2

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 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)
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)1260×758 39 KB

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)
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)1159×761 44.6 KB

3

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
image804×184 12.7 KB

image
image829×187 10.6 KB

4

I am using the XML below from Celigo to Intacct

<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>
5

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