Acumatica (Preview)
Acumatica Cloud ERP Connector
This connector is available in the following products and regions:
| Service | Class | Regions |
|---|---|---|
| Logic Apps | Standard | All Logic Apps regions except the following: - Azure Government regions - Azure China regions - US Department of Defense (DoD) |
| Power Automate | Premium | All Power Automate regions except the following: - US Government (GCC) - US Government (GCC High) - China Cloud operated by 21Vianet - US Department of Defense (DoD) |
| Power Apps | Premium | All Power Apps regions except the following: - US Government (GCC) - US Government (GCC High) - China Cloud operated by 21Vianet - US Department of Defense (DoD) |
| Contact | |
|---|---|
| URL | https://www.acumatica.com/support/ |
| Connector Metadata | |
|---|---|
| Publisher | Acumatica |
| Website | http://www.acumatica.com |
| Privacy policy | https://www.acumatica.com/privacy-policy/ |
Creating a connection
The connector supports the following authentication types:
| Default | Parameters for creating connection. | All regions | Not shareable |
Default
Applicable: All regions
Parameters for creating connection.
This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.
| Name | Type | Description | Required |
|---|---|---|---|
| Domain URL | string | Your Acumatica Domain URL | True |
| username | securestring | The username for this api | True |
| password | securestring | The password for this api | True |
| Client ID | securestring | The client ID for this api | True |
| secret | securestring | The secret for this api | True |
Throttling Limits
| Name | Calls | Renewal Period |
|---|---|---|
| API calls per connection | 100 | 60 seconds |
Actions
| I want to create or update an existing Case |
I want to create or update an existing Case |
| I want to create or update an existing Customer |
I want to create or update an existing Customer |
| I want to create or update an existing Opportunity |
I want to create or update an existing Opportunity |
| I want to delete Case using CaseID |
I want to delete Case using CaseID |
| I want to delete Customer using CustomerID |
I want to delete Customer using CustomerID |
| I want to delete Opportunity using OpportunityID |
I want to delete Opportunity using OpportunityID |
| I want to retrieve Case information using CaseID |
I want to retrieve Case information using CaseID |
| I want to retrieve Customer information using CustomerID |
I want to retrieve Customer information using CustomerID |
| I want to retrieve list of Cases that satisfy specified conditions |
I want to retrieve list of Cases that satisfy specified conditions |
| I want to retrieve list of Customers that satisfy specified conditions |
I want to retrieve list of Customers that satisfy specified conditions |
| I want to retrieve list of Opportunities that satisfy specified conditions |
I want to retrieve list of Opportunities that satisfy specified conditions |
| I want to retrieve Opportunity information using OpportunityID |
I want to retrieve Opportunity information using OpportunityID |
I want to create or update an existing Case
I want to create or update an existing Case
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Accept
|
Accept | True | string |
Accept |
|
Content-Type
|
Content-Type | True | string |
Content-Type |
|
value
|
value | string |
value |
|
|
value
|
value | string |
value |
|
|
value
|
value | string |
value |
|
|
value
|
value | string |
value |
|
|
value
|
value | string |
value |
|
|
value
|
value | string |
value |
|
|
value
|
value | string |
value |
|
|
value
|
value | string |
value |
|
|
value
|
value | string |
value |
|
|
value
|
value | string |
value |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
value
|
CaseID.value | string |
value |
|
value
|
Subject.value | string |
value |
|
value
|
DateReported.value | string |
value |
|
value
|
ClassID.value | string |
value |
|
value
|
BusinessAccount.value | string |
value |
|
value
|
Description.value | string |
value |
|
value
|
ContactDisplayName.value | string |
value |
|
value
|
Status.value | string |
value |
|
value
|
Reason.value | string |
value |
|
value
|
Severity.value | string |
value |
|
value
|
Priority.value | string |
value |
|
value
|
LastActivityDate.value | string |
value |
I want to create or update an existing Customer
I want to create or update an existing Customer
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Accept
|
Accept | True | string |
Accept |
|
Content-Type
|
Content-Type | True | string |
Content-Type |
|
value
|
value | string |
value |
|
|
value
|
value | string |
value |
|
|
value
|
value | string |
value |
|
|
value
|
value | string |
value |
|
|
value
|
value | string |
value |
|
|
value
|
value | string |
value |
|
|
value
|
value | string |
value |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
value
|
CustomerID.value | string |
value |
|
value
|
CustomerName.value | string |
value |
|
value
|
Status.value | string |
value |
|
value
|
AccountRef.value | string |
value |
|
value
|
CurrencyID.value | string |
value |
|
value
|
CustomerClass.value | string |
value |
|
value
|
Terms.value | string |
value |
I want to create or update an existing Opportunity
I want to create or update an existing Opportunity
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Accept
|
Accept | True | string |
Accept |
|
Content-Type
|
Content-Type | True | string |
Content-Type |
|
value
|
value | string |
value |
|
|
value
|
value | string |
value |
|
|
value
|
value | string |
value |
|
|
value
|
value | string |
value |
|
|
value
|
value | string |
value |
|
|
value
|
value | string |
value |
|
|
value
|
value | string |
value |
|
|
value
|
value | number |
value |
|
|
value
|
value | number |
value |
|
|
value
|
value | number |
value |
|
|
value
|
value | string |
value |
|
|
value
|
value | string |
value |
|
|
value
|
value | string |
value |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
value
|
OpportunityID.value | string |
value |
|
value
|
Subject.value | string |
value |
|
value
|
Status.value | string |
value |
|
value
|
Stage.value | string |
value |
|
value
|
CurrencyID.value | string |
value |
|
value
|
BusinessAccount.value | string |
value |
|
value
|
ContactDisplayName.value | string |
value |
|
value
|
Amount.value | number |
value |
|
value
|
Discount.value | number |
value |
|
value
|
Total.value | number |
value |
|
value
|
Source.value | string |
value |
|
value
|
Reason.value | string |
value |
|
value
|
Project.value | string |
value |
I want to delete Case using CaseID
I want to delete Case using CaseID
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Case CD {e.g. 090021)
|
ids | True | string |
Case CD {e.g. 090021) |
Returns
- response
- string
I want to delete Customer using CustomerID
I want to delete Customer using CustomerID
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Customer ID (e.g. ABARTENDE)
|
ids | True | string |
Customer ID (e.g. ABARTENDE) |
Returns
- response
- string
I want to delete Opportunity using OpportunityID
I want to delete Opportunity using OpportunityID
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Opportunity ID (e.g. SmallOpptNbr)
|
ids | True | string |
Opportunity ID (e.g. BigOpptNbr) |
Returns
- response
- string
I want to retrieve Case information using CaseID
I want to retrieve Case information using CaseID
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Case CD {e.g. 090021)
|
ids | True | string |
Case CD {e.g. 090021) |
|
Accept
|
Accept | True | string |
Accept |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
value
|
CaseID.value | string |
value |
|
value
|
Subject.value | string |
value |
|
value
|
DateReported.value | string |
value |
|
value
|
ClassID.value | string |
value |
|
value
|
BusinessAccount.value | string |
value |
|
value
|
Description.value | string |
value |
|
value
|
ContactDisplayName.value | string |
value |
|
value
|
Status.value | string |
value |
|
value
|
Reason.value | string |
value |
|
value
|
Severity.value | string |
value |
|
value
|
Priority.value | string |
value |
|
value
|
LastActivityDate.value | string |
value |
I want to retrieve Customer information using CustomerID
I want to retrieve Customer information using CustomerID
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Customer ID (e.g. ABARTENDE)
|
ids | True | string |
Customer ID (e.g. ABARTENDE) |
|
Accept
|
Accept | True | string |
Accept |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
value
|
CustomerID.value | string |
value |
|
value
|
CustomerName.value | string |
value |
|
value
|
Status.value | string |
value |
|
value
|
AccountRef.value | string |
value |
|
value
|
CurrencyID.value | string |
value |
|
value
|
CustomerClass.value | string |
value |
|
value
|
Terms.value | string |
value |
I want to retrieve list of Cases that satisfy specified conditions
I want to retrieve list of Cases that satisfy specified conditions
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Filter (e.g. field1 eq 'value')
|
filter | string |
Filter (e.g. field1 eq 'value') |
|
|
Skip numbers of records
|
skip | string |
Skip numbers of records |
|
|
Get number of records
|
top | string |
Get number of records |
|
|
Accept
|
Accept | True | string |
Accept |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
|
array of object | ||
|
value
|
CaseID.value | string |
value |
|
value
|
Subject.value | string |
value |
|
value
|
DateReported.value | string |
value |
|
value
|
ClassID.value | string |
value |
|
value
|
BusinessAccount.value | string |
value |
|
value
|
Description.value | string |
value |
|
value
|
ContactDisplayName.value | string |
value |
|
value
|
Status.value | string |
value |
|
value
|
Reason.value | string |
value |
|
value
|
Severity.value | string |
value |
|
value
|
Priority.value | string |
value |
|
value
|
LastActivityDate.value | string |
value |
I want to retrieve list of Customers that satisfy specified conditions
I want to retrieve list of Customers that satisfy specified conditions
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Filter (e.g. field1 eq 'value')
|
filter | True | string |
Filter (e.g. field1 eq 'value') |
|
Skip number of records
|
skip | True | string |
Skip number of records |
|
Return number of records
|
top | True | string |
Return number of records |
|
Accept
|
Accept | True | string |
Accept |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
|
array of object | ||
|
value
|
CustomerID.value | string |
value |
|
value
|
CustomerName.value | string |
value |
|
value
|
Status.value | string |
value |
|
value
|
AccountRef.value | string |
value |
|
value
|
CurrencyID.value | string |
value |
|
value
|
CustomerClass.value | string |
value |
|
value
|
Terms.value | string |
value |
I want to retrieve list of Opportunities that satisfy specified conditions
I want to retrieve list of Opportunities that satisfy specified conditions
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Filter (e.g. field1 eq 'value')
|
filter | string |
Filter (e.g. field1 eq 'value') |
|
|
Skip numbers of records
|
skip | string |
Skip numbers of records |
|
|
Get number of records
|
top | string |
Get number of records |
|
|
Accept
|
Accept | True | string |
Accept |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
|
array of object | ||
|
value
|
OpportunityID.value | string |
value |
|
value
|
Subject.value | string |
value |
|
value
|
Status.value | string |
value |
|
value
|
Stage.value | string |
value |
|
value
|
CurrencyID.value | string |
value |
|
value
|
BusinessAccount.value | string |
value |
|
value
|
ContactDisplayName.value | string |
value |
|
value
|
Amount.value | number |
value |
|
value
|
Discount.value | number |
value |
|
value
|
Total.value | number |
value |
|
value
|
Source.value | string |
value |
|
value
|
Reason.value | string |
value |
|
value
|
Project.value | string |
value |
I want to retrieve Opportunity information using OpportunityID
I want to retrieve Opportunity information using OpportunityID
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Opportunity ID (e.g. BigOpptNbr)
|
ids | True | string |
Opportunity ID (e.g. BigOpptNbr) |
|
Accept
|
Accept | True | string |
Accept |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
value
|
OpportunityID.value | string |
value |
|
value
|
Subject.value | string |
value |
|
value
|
Status.value | string |
value |
|
value
|
Stage.value | string |
value |
|
value
|
CurrencyID.value | string |
value |
|
value
|
BusinessAccount.value | string |
value |
|
value
|
ContactDisplayName.value | string |
value |
|
value
|
Amount.value | number |
value |
|
value
|
Discount.value | number |
value |
|
value
|
Total.value | number |
value |
|
value
|
Source.value | string |
value |
|
value
|
Reason.value | string |
value |
|
value
|
Project.value | string |
value |
Definitions
string
This is the basic data type 'string'.