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.
Connection
| Parameter | 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; used for API calls. |
Refresh Token |
Masked | Populated after OAuth authorization; 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_accessscope 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 (for example: 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.
| Parameter | Type | Notes |
|---|---|---|
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). |
Parameters |
Object | Optional key-value collection applied to path/query/header parameters for the selected operation. |
Items |
Array | Optional streamed payload for operations that accept a request body (rare for queries). |
| Return | Type | Notes |
|---|---|---|
Result |
Array | Flattened results from the Intacct response. Each item includes a status field (ok or error) and echoes the request. |
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 | Notes |
|---|---|---|
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). |
Items |
Array | Stream of request objects to send. Bodies exceeding 500 items are chunked; each response aligns to its item. |
| Return | Type | Notes |
|---|---|---|
Result |
Array | Item-wise responses from the executed Intacct operation. Successful items include key/id/href fields. Failures surface error details. |
Usage Notes
- Use the template picker in the designer to select the correct
OperationIdfor both Query and Mutate calls. Templates are filtered by operation category. - Responses echo the original request item under
requestand appendstatus,error, anderrorCodefields to simplify per-item success/failure handling. - Authentication failures are automatically detected. Refresh Tokens are used when available to refresh an expired/invalid Access Token, otherwise re-connect your account to renew credentials.
Known Issues
- Delete method still work in progress.