Question

REST API - Connecting CIS API to acumatica to be pulling Data

  • 13 January 2021
  • 4 replies
  • 85 views

Hi, I have 4 APIs, The first is POST method that posts the credentials to the CIS system and accessToken is generated(the token changes daily) which is used in the GET methods. The rest are GET methods that gets the data and imports into Acumatica. So far my code retrieves the data successful and they are in json format.

How can I import this data into Acumatica?

N/B The integration is permanent, not a one time thing. 

Data is Customer Data, Invoices and Payments.


4 replies

Userlevel 1
Badge

@dev16

You can use OpenAPI or SOAP to import date to Acumatica.

If your data is in JSON format. I think OpenAPI is a better choice. 

 

 

Integration Guide:

https://help-2020r2.acumatica.com/Help?ScreenId=ShowWiki&pageid=0322492a-de9b-4443-b256-923c48aff31d

Userlevel 5
Badge +3

Hi @dev16 ,

We need to frame the JSON format for each entity to create the customer/payments/invoices in Acumatica. Just FYI..Each entity will have different JSON formats and for more details you can check this link - https://help-2018r1.acumatica.com/(W(1))/Wiki/ShowWiki.aspx?pageid=1c767ad9-da6d-4047-bc93-6970ad469504

Created a DLL file that sent the credentials to the server and got the accesstoken that had been generated. On the same DLL used the token to get the JSON files. 

Used the DLL in my customization where I used SOAP API to import the data.

Thank you so much!!

Userlevel 5
Badge +3

@dev16  Great :) Thanks for sharing the update. 

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 — 2020  Acumatica, Inc. All rights reserved