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'.