Skip to main content
Answer

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

  • January 13, 2021
  • 4 replies
  • 221 views

dev16
Freshman II

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.

Best answer by dev16

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!!

4 replies

Forum|alt.badge.img+1
  • Semi-Pro II
  • January 14, 2021

@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


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • January 14, 2021

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


dev16
Freshman II
  • Author
  • Freshman II
  • Answer
  • April 27, 2021

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!!


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • April 27, 2021

@dev16  Great :) Thanks for sharing the update.