Question

How to use Acumatica API for data uploading

  • 1 July 2021
  • 3 replies
  • 42 views

Hi,

Interested in knowing how I can use Acumatica API to upload data from C#. I’m looking for any step-by-step document which can explain me from the scratch like how to configure API, how to check it is ready to use or not and then how to use it. I tried to add API’s wsdl in VS project as a service reference but it gave me an error:

 

There was an error downloading 'https://mycompany.acumatica.com/entity/Default/18.200.001/_vti_bin/ListData.svc/$metadata'.

The underlying connection was closed: An unexpected error occurred on a send.

Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.

An existing connection was forcibly closed by the remote host

Metadata contains a reference that cannot be resolved: 'https://mycompanyt.acumatica.com/entity/Default/18.200.001'.

An error occurred while making the HTTP request to https://mycompany.acumatica.com/entity/Default/18.200.001. This could be due to the fact that the server certificate is not configured properly with HTTP.SYS in the HTTPS case. This could also be caused by a mismatch of the security binding between the client and the server.

The underlying connection was closed: An unexpected error occurred on a send.

Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.

An existing connection was forcibly closed by the remote host

If the service is defined in the current solution, try building the solution and adding the service reference again.


3 replies

hi @adilaleem 

Please go through the document on the below link which has detailed explanation on how to use the Acumatica API’s.
https://www.acumatica.com/media/2020/02/AcumaticaERP_IntegrationDevelopmentGuide.pdf

Hi Praveen,
I was already watching training videos about webservices integration and found that all the demos showing localhost in the URLs.. is that necessary to install Acumatica locally to use webservices? can't we just call the public URLs or WSDL of the webservices directly?

NM.. I found the solution.. actually I was using older .net framework < 5 which doesn't support TLS 1.2.. that's why unable to add the Acumatica webservice WSDL.. Thanks though.

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