Acumatica ERP Connector
  • 21 Feb 2024
  • 2 Minutes to read
  • Contributors

Acumatica ERP Connector


Article summary

To download the app, visit: Library

Introduction

Acumatica is a cloud-based enterprise resource planning (ERP) system for small and midsized to large businesses, especially those growing quickly. It provides flexible cloud hosting options of both public and private cloud to keep data secure and accessible. The cloud-based solution offers flexibility, mobility, security and ease of use while reducing IT costs and improving collaboration across the organization.

Purpose

Acumatica ERP offers web services that allow integration with Tulip. These services enable Tulip to retrieve data from Acumatica ERP, process this data, and store new or edited records back into Acumatica ERP.

API Doc

The following Connector Function highlighted in this document have leveraged Acumatica API Docs.

Pre-Requisites

Subscribe to an account on Acumatica's platform, Then import the Acumatica ERP connector from the library.

Tulip Connection Details

The following information would need to be configured on Tulip's HTTP connector.

Running On: Cloud Connector Host
Host: http://"Acumatica ERP instance URL"/
Port:443
TLS: Yes
Authentication: No Auth
Headers: No Header
## Prebuilt Connector Functions

Log in

Before you start using the other functions, you need to Log in with the listed authentications with this function. If it is succesfull, you get back the cookies in the response header that's required to use the other functions.
To see the proper authentication parameters check out the above mentioned API doc.

Create record

When you need to create a record by using the API, you access the needed URL address with the PUT HTTP method and pass the record representation in JSON format in the request body.

Request a report

To request a report by using the contract-based REST API, you access the needed URL with the POST HTTP method. You pass the parameters of the report in JSON format in the request body.

Retrieve list of BOMs

If you are using the contract-based REST API to integrate Acumatica ERP with an external system, this external system can retrieve the list of existing bills of material (BOMs).

Retrieve list of endpoints

Retrieve list of records in a batch

To retrieve a large number of records of the same type by using the contract-based REST API, you can use several approaches. There are two extremes in performing this task:
You make a single request that retrieves the whole information you need. In this case there is a risk of an operation timeout.
You make many requests, each of which retrieves a single record you need. In this case the whole task takes a lot of time.
A balanced approach combines these two extremes: you make multiple requests with the $top and $skip parameters, each of which retrieves a part of the records you need. The number of records to retrieve in a single request you select empirically to optimize the performance of the whole task or to paginate records.


Was this article helpful?