How to Connect
Prerequisites
Before setting up the Acumatica integration in iPaaS.com, ensure you have the following:
API URL
Current Acumatica instance URL.
Example:https://ipaascom.acumatica.com
OAuth Authentication
Client ID and Client Secret from Acumatica's Connected Applications (Authorization Code flow).
Required scopes:
api offline_access.
Password Authentication (Optional)
Username and password for API access.
Configure Subscription Settings
Navigate to the Acumatica subscription settings in iPaaS.com and provide the following information:
Field | Description | Required | Example |
Name | A unique name to identify the Acumatica subscription. | Yes | Acumatica_Integration |
Version | API version to use for the integration. The API currently supported is 22.200.001. | Yes | 22.200.001 |
Redirect URL | The redirect URL for OAuth authentication. This must be changed depending on the iPaaS.com environment. | Yes |
|
Grant Type | Type of authorization flow. | Yes | authorization_code |
Scopes | Permissions required for the integration. The scope must be "api offline_access" | Yes | api offline_access |
Password | (Optional) Password for API access. | No | Your Password |
Client Secret | Secret key obtained from Acumatica's Connected Apps. | Yes | Your Client Secret |
Client ID | Client ID from Acumatica's Connected Apps. | Yes | Your ClientID |
Username | Acumatica instance username for API access. | No | admin |
API URL | The base URL of the Acumatica instance. | Yes |
Authentication Methods
Follow these steps to authenticate the Acumatica integration. You can use one of the following methods:
OAuth Authentication
Search for Connected Applications from the Acumatica portal.
Create a new Application using the Authorization Code flow type.
Ensure no absolute expiration is configured for the application.
Add a shared secret and copy its value.
The Client ID will be generated after saving the Connected Application.
Enter the following values into your Acumatica subscription in iPaaS.com:
Redirect URL: Depending on the environment:
Staging:
https://stagingportal.ipaas.com/customer/subscription-mgmt/subscriptions/authorization/appProduction:
https://portal.ipaas.com/customer/subscription-mgmt/subscriptions/authorization/app
Scope:
api offline_accessGrant Type:
authorization_code
Open the Acumatica subscription in iPaaS and click the Authentication icon.
A browser window will open; log in and click Allow.
Upon success, refresh the iPaaS subscription to validate the access token.
If an error is encountered, double check the settings provided meet the requirements described above.
Password Authentication (Optional)
Search for Connected Applications from the Acumatica portal.
Create a new Application using the Resource Owner Password Credentials (ROPC) flow type.
Ensure no absolute expiration is configured.
Add a shared secret and copy its value.
The Client ID will be generated after saving the record.
Enter the following values into your Acumatica subscription in iPaaS.com:
Base URL: Enter your current Acumatica instance URL.
https://adcirruserp.acumatica.comUsername: Provide the username for API access.
adminPassword: Provide the password for API access.
Demo1234Client ID: Copy from Acumatica's Connected Applications with the Resource Owner Password Credential flow (ROPC).
Your Client IDClient Secret: Copy from the Secret Key added to the Connected Application with the Resource Owner Password Credential flow (ROPC).
Your Client SecretScope:
api offline_accessGrant Type:
passwordVersion: API version currently supported.
22.200.001
Initialization Support
The following types of data support initialization and can be transferred in bulk:
Location TO iPaaS.com
Throttling
Throttling ensures that Acumatica's API isn’t overwhelmed by excessive API calls, preserving system performance during heavy data transfers.
While the throttling fields are required, the values are pre-populated by the integration settings. For more details, refer to Subscription Configuration – Edit.