Skip to main content

Here is the URL that has been working for well over a year
https://companyx.acumatica.com/ODatav4/companyx/PX_OBJECTS_AR_ARADDRESS?$format=json

Starting on October 8th, 2024. the Azure Data Factory pipelines started failing with the error ”ErrorCode=RestCallFailedWithClientError,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Rest call failed with client error, status code 404 NotFound”

I am hunting for a change notification or something regarding the URL needing to be updated or something, but I am not having any luck. 
Thoughts? 

@PAPutzback has the site been upgraded or something?

I think the URL is case sensitive, so try {{sitename}}/odatav4/Company/PX_Objects_AR_ARAddress?$format=json


Thanks for the response, I finally figured that out by querying the root url and getting the list of tables back. I searched the doc AcumaticaERP_2024R1_ReleaseNotes_for_Developers.pdf, and did not find anything regarding a case sensitivity change. The document also did not specify that the column CustomerKind in the PX.Objects.AR.Customer table was renamed to CustomerCategory. 

All is good now, Thanks again.


@Dmitrii Naumov  Hi Is it safe to update existing project using rest api client? I see the project is updated on Github. Do you have more code sample regarding how to use rest api client? I am trying to move all my SOAP code, is there an easier way?


@woodyg84 here are some examples:

https://github.com/Acumatica/AcumaticaRESTAPIClientForCSharp/blob/master/Acumatica%20REST%20API%20Console%20Application/RESTExample.cs

 

Also, you can use the Acumatica.SOAPLikeWrapperForREST nuget package to upgrade your existing SOAP code to use REST API.

Example: https://github.com/Dmitrii-Naumov/AcumaticaSOAPWrapperForREST/blob/master/Acumatica%20REST%20API%20Console%20Application/SOAPLikeExample.cs

 


Reply