Solved

Using External APIs in Acumatica

  • 2 August 2021
  • 7 replies
  • 784 views

Userlevel 3
Badge +1

We are carrying out an integration to export sales records from Acumatica Sales Order Screen into external system via third-party API, what is the best way to carry out this integration?

What is the best way to send Acumatica sales data to this external API and also sales data must be sent hourly. Currently thinking of using Contract-based REST API method in Acumatica. Please let me know the right solution to go ahead with this requirement or any documents present.

 

icon

Best answer by jinin 17 August 2021, 16:17

View original

7 replies

Userlevel 4
Badge +1

@TharidhiP 

If you know C#. Develop a screen and set automation schedules in the system.

If you use other language. 

  1. Use export scenario to export data to ftp/sftp server. Develop a file monitor to post files to the API.
  2. Develop a program to pull/post data via OpenApi. 

It’s really depends on what kind of API you need send data to. 

Userlevel 7
Badge +9

Hi @TharidhiP This would be the approach that I can recommend.

  1. Create a new Setup screen to have the API url, user name,password etc., to connect to the external System.
  2. Create a new Flag “Sent” in Sales Order Screen
  3. Create a new Processing Screen in Acumatica and provide required parameters like from date and to date to select the Orders with the date range.
  4. The “Load” option should pull  all Sales Orders for the Provided date range(if date range is selected) that is NOT sent or if the date range is not selected pull all the Order which are NOT Sent
  5.  The “Process” button click should loop through each Sales Order and send the details to the external system via API connection.

Thanks

Userlevel 3
Badge +1

@larryly, @ChandrasekharM thank you for your answers. Is there any possibility to achieve this using Push Notifications in Acumatica?

Userlevel 7
Badge +17

@TharidhiP  I don’t think that is possible using Push Notifications in Acumatica.

As per my knowledge, In Acumatica, Push Notifications will triggers only when configured GIs are modified/inserted/deleted.

 

Userlevel 3
Badge +1

@Naveen B , if we were to create separate GI then we can post those sales data to the external API according to your suggestion right?

Userlevel 7
Badge +17

@TharidhiP  If you use the MSMQ push notification, then you need to have consumer in place to read the queue messages and from there you need to make an API call to export the data from Acumatica system. 

Userlevel 7
Badge +11

Hi @TharidhiP 

We can try the below approach with push notification. 

  1. Create a GI for SO Order table and add the conditions based on your requirement. you can include the fields which you are interested in the result tab. 
  2. Create Push notification with this GI. 
  3. Create a new Setup screen or use any existing screen to have the API url, user name, password etc., to connect to the external System.
  4. Create a new Processing Screen in Acumatica and read the records from the message Queue and send the request to the external system.
  5. We can maintain a flag to identify the record is processed or not. Update the field once the record is synced to the external system.

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved