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.
We can try the below approach with push notification.
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.
Create Push notification with this GI.
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.
Create a new Processing Screen in Acumatica and read the records from the message Queue and send the request to the external system.
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.
Hi @TharidhiP This would be the approach that I can recommend.
Create a new Setup screen to have the API url, user name,password etc., to connect to the external System.
Create a new Flag “Sent” in Sales Order Screen
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.
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
The “Process” button click should loop through each Sales Order and send the details to the external system via API connection.
@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.
We can try the below approach with push notification.
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.
Create Push notification with this GI.
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.
Create a new Processing Screen in Acumatica and read the records from the message Queue and send the request to the external system.
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.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.