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/ |
The connector supports the following authentication types:
Default | Parameters for creating connection. | All regions | Not shareable |
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 |
Name | Calls | Renewal Period |
---|---|---|
API calls per connection | 100 | 60 seconds |
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
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
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
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
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
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
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
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
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
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
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
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
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 |
This is the basic data type 'string'.