How to use CozyRoc Acumatica Connector Actions Read, Create, Update and Delete Http (Methods)

How to use COZYROC Acumatica Connector Actions Read, Create, Update and Delete ( Http Methods )


                                                                CozyRoc Acumatica Connector Guide

Acumatica is the complete Cloud ERP solution for all your business management needs today and in the future. With CozyRoc Acumatica Connector external systems can get data records from Acumatica ERP, process these records, save new or updated records to Acumatica ERP and execute actions that are available in Acumatica contract-based REST API. CozyRoc Acumatica Connector is inherited from two Templates, Base and Inquiry. 

Base Template: Resources that are not using HTTP (PUT) method for READ (Action) element but using HTTP (GET) method are inherit from Base Template. No need to manually pass $expand and $select parameter.  You can simply select fields from column tab that will generate a select query automatically and add it to the query URL. Below we will walk through a simple example using  where we will use resource Account.

Example: Resource Account
Let say I am only interested in data for the columns AccountCD and AccountClass, I can deselect the rest of the columns and select only AccountCD and AccountClass as mention in below below screen shot 1.0 highlighted red

Screen Shot 1.0


I will only get the data for AccountCD and AccountClass after I hit the preview tab, since the configuration will generate the select query automatically based on the fields you select and add it to the invoking endpoint URL as a query parameters. You can see the in the below screen shot 1.1, how the call to the endpoint will look like. 

Screen Shot 1.1
In the above examples as mention in screen shot 1.0 and 1.1 we learn about how $select parameter works. Now lets talk about the $expand parameter. You use this parameter to specify the linked and details entities that should be expanded and are present in the contract-based REST API endpoints. By default no linked and details entities are expanded; that is, only fields from the top level entity are returned. Below we will walk through a simple example using  where we will use resource Carrier.

Example: Resource Carrier
By default there are two linked entities present in the carrier endpoint with the name CustomerAccounts and PlugInParameters as you can see in the below screen shot 1.2 circled red
Screen Shot 1.2
 As you can see in the above screen shot 1.2, the linked entities are initially deselect. If you want to retrieve the linked and details entities, all you have to do is to check the box, hit preview tab and CozyrRoc Acumatica Connector will automatically generate the $expand query and add it to the invoking endpoint call as a query parameters mention in the below screen shot 1.3 underlined red

Screen Shot 1.3
Execution of Action






    Book a Presales Call


    Are you new to COZYROC and evaluating our solutions? 
    Book a Presales Call with us now and get 5% off SSIS+.