Skip to main content
Solved

Using External APIs in Acumatica


Forum|alt.badge.img+2

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.

 

Best answer by jinin

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.
View original
Did this topic help you find an answer to your question?

7 replies

Forum|alt.badge.img+1
  • Semi-Pro II
  • 88 replies
  • August 2, 2021

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


Forum|alt.badge.img+8
  • Semi-Pro I
  • 715 replies
  • August 2, 2021

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


Forum|alt.badge.img+2
  • Author
  • Pro I
  • 104 replies
  • August 4, 2021

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


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3406 replies
  • August 4, 2021

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

 


Forum|alt.badge.img+2
  • Author
  • Pro I
  • 104 replies
  • August 4, 2021

@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?


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3406 replies
  • August 11, 2021

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


jinin
Pro I
Forum|alt.badge.img+11
  • Pro I
  • 701 replies
  • Answer
  • August 17, 2021

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings