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

Operation ID:

CreatesOrUpdatesAnExistingCase

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

Operation ID:

CreatesOrUpdatesAnExistingCustomer

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

Operation ID:

CreatesOrUpdatesAnExistingOpportunity

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

Operation ID:

DeletesCaseUsingCaseid

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

Operation ID:

DeletesCustomerUsingCustomerid

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

Operation ID:

DeletesOpportunityUsingOpportunityid

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

Operation ID:

RetrievesCaseUsingCaseid

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

Operation ID:

RetrievesCustomerUsingCustomerid

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

Operation ID:

RetrievesListOfCasesThatSatisfyTheSpecifiedConditions

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

Operation ID:

RetrievesListOfCustomersThatSatisfyTheSpecifiedConditions

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

Operation ID:

RetrievesListOfOpportunitiesThatSatisfyTheSpecifiedConditions

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

Operation ID:

RetrievesOpportunityUsingOpportunityid

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