Sage Intacct

Provides integration with the Sage Intacct REST API using the embedded OpenAPI definition. The node supports querying and mutating common objects (for example: customers, vendors, general ledger entries) using template-driven operations.

Revision History

0.1.0.2 - Initial release.
0.1.0.9 - Fixed shared OAuthConnection lock handling.
0.1.0.10 - Fixed error message handling.
0.1.0.13 - Updated templates to latest API release of 13 February 2026.
0.1.0.21 - Improved error message handling.
0.1.0.23 - Node name correction.
0.1.0.36 - Fixed Get Object returns to include all fields. Correct errors for QueryService calls surfaced to user.

Connection

Property	Type	Description
Client Id	String	Sage Intacct OAuth Client ID from your developer application.
Client Secret	Masked	Sage Intacct OAuth Client Secret from your developer application.
Access Token	Masked	Populated after OAuth authorization and used for API calls.
Refresh Token	Masked	Populated after OAuth authorization and used to renew the Access Token.

Setup Notes

• Create a Sage Intacct developer application to obtain a Client Id and Client Secret, and enable the offline_access scope so refresh tokens are issued.
• Configure the application's redirect URI to match the Flowgear callback URL provided by the platform when initiating OAuth.
• Ensure the Intacct user completing the OAuth flow has permissions for the objects you intend to call, e.g. accounts receivable, general ledger, or dimensions.
• If your Intacct tenant restricts IP addresses, allow the Flowgear outbound IP ranges.

Methods

Perform Query and Mutate actions on Sage Intacct records.
Mutate internally performs either a Create or Update action.

Query

Executes queries against the REST API defined in the embedded OpenAPI specification.
More information can be found here.

For standard REST query templates, select the required OperationId and pass path, query, or header values in Options.

Query also supports Sage Intacct QueryService calls. In the template picker, select a template named Query Service - <Object>. The Node then uses the top-level Object, Fields, Filter, and Parameters inputs to build the request body for you, and it pages through the results automatically in batches of up to 500 records.

Use Filter for an OData-style expression such as NAME $eq '{customerName}' and TOTALDUE $gt {minimumAmount}. If you use variables inside braces, provide a matching value for each one in Parameters. Fields is a comma-separated list of the properties to return, and the template pre-populates it from the Sage Intacct model metadata for the selected Object.

Parameter	Type	Description
Connection	Connection	OAuth connection profile containing client credentials and tokens.
OperationId	String	Operation identifier from the Sage Intacct REST OpenAPI templates or the selected Query Service - <Object> template.
Options	Object	Optional key-value collection applied to path, query, and header parameters for the selected operation.
Items	Array	Optional streamed request body for operations that accept one. Leave this empty for QueryService templates because the Node builds the body from the query inputs.
Object	String	Object name to query when you use a QueryService template.
Fields	String	Comma-separated list of fields to return for QueryService templates.
Filter	String	Optional OData-style filter expression for QueryService templates. Flowgear converts this into the Sage Intacct filters and filterExpression format.
Parameters	Object	Values used to replace variables referenced in Filter. Every variable in Filter must be provided here.

Return	Type	Description
Result	Array	Results returned by the selected query. QueryService calls return the requested fields for each matching record plus status. Standard collection queries typically return key, id, href, and status, while single-record GET queries return the full object.

Mutate

Creates or updates Intacct records. Requests are automatically batched in groups of up to 500 items when a streamed body is supplied.

Parameter	Type	Description
Connection	Connection	OAuth connection profile containing client credentials and tokens.
OperationId	String	Operation identifier from the Sage Intacct REST OpenAPI templates available via the designer templates.
Options	Object	Optional key-value collection applied to path, query, and header parameters for the selected operation.
Items	Array	Stream of request objects to send. Bodies exceeding 500 items are chunked, and each response aligns to its item.

Return	Type	Description
Result	Array	Item-wise responses from the executed Intacct operation. Successful items include key, id, href, and status. Failures surface error details.

Usage Notes

• Use the template picker in the designer to select the correct OperationId for both Query and Mutate calls. Templates are filtered by operation category.
• When you supply Items, responses echo the original request item under request. Success and failure rows also include standard status fields such as status, statusMessage, and errorMessage.
• Authentication failures are automatically detected. Refresh Token values are used when available to renew an expired or invalid Access Token. Otherwise, reconnect your account to renew credentials.

Known Issues

• Delete method is still a work in progress.