Skip to main content
Solved

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

  • January 13, 2021
  • 4 replies
  • 195 views

dev16
Freshman II
  • Freshman II
  • 2 replies

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

View original
Did this topic help you find an answer to your question?

4 replies

Forum|alt.badge.img+1
  • Semi-Pro II
  • 88 replies
  • 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
  • 3393 replies
  • 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
  • 2 replies
  • 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
  • 3393 replies
  • April 27, 2021

@dev16  Great :) Thanks for sharing the update. 


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