Develop Integrations with Web Services | APIs

Hello,I’m trying to create SalesOrder through API request, but it keep raising this error: "exceptionMessage": "A data corruption state has been detected. You cannot save the changes. Copy the data you have entered and reload the page. Date and Time: 2024-05-31T20:20:12; IncidentID: 8eee461c-214a-4bd2-803c-894bba76aa0e; Name: Aggregate Validation: PX.Objects.SO.SOOrder+openLineCntr. You can view detailed information about the issue on the System Events tab of the System Monitor (SM201530) form.",here is my endpoint endpoint structureand this is the data that i’m trying to submiturl {{baseUrl}}/entity/GTPDefault3/20.200.001.001/SalesOrder/Approve{    "entity":{        "OrderNbr": {            "value": "CODE-000396318"        },        "OrderType": {            "value": "SO"        },        "CustomerID": {            "value": "C00004735"        },        "Deatils": [                    {                "InventoryID": {                    "value": "N76386S-3P"                },         

Hello everyone. I am currently working on customizing an API to add customer data one by one into a new screen. I have created the necessary table in the database and the screen to display the data. Everything seems to be functioning correctly. However, I have encountered an issue where adding a new record results using PUT API  in the deletion of the old record from both the database and the screen. What steps should I take to address this issue? I have attached a screenshot below for reference.This is screen.  

Hi All, I need to create new DAC and dump data into new DAC using Rest API. I know how to code and put data but I am stuck in few questions like If I started new creating new DAC do i need to define new fields in that and save data accordingly and  Also how can i access that DAC using API? is there any blog that can give similar idea. 

I am currently running the Acumatica Instance on my localhost but it is not secure as it is in HTTP form now in order to do the integration i need to make the http to https now i have seen many documentations and forms to get the SSL certificate but one of my seniors suggested me to use the Ngrok or other alternatives like ngrok. So can i host the Acumatica on the Ngrok or i need to do this SSL certificate thing in order to make the Http to Https ? 

I am trying to get a delta of modified customers to synchronize to an external system. The LastModifiedDateTime filter seems to be ignored, and all records are returned.. My query is{{baseUrl}}/entity/DefaultExt/22.200.001/Customer?$fitler=LastModifiedDateTime ge datetimeoffset'2024-06-03'I have also tried the date format like 2024-06-03T00:00:00.000-04:00, but that too returns all records. Any idea why this won’t filter? It has to be something ridiculously simple...

Hi Team,After I upgrade my instance from 2022 R2 to 2024 R1, my existing webservice endpoint throw the below error. I tried to publish the customization package for this webservice, but still no luck.Please help me to check on this. Regards,Ramya Krishna

I am trying use the Login to Acumatica Rest API with Postman. ​​According to the documentation I have found in the web, I should be using http://MyCompany.acumatica.com/entity/auth/login as URL The body as detailed below:{"name":"johnd","password":"johndpassword","tenant":"mytenant"} I get an error in Postman as detailed below:{"message":"An error has occurred.","exceptionMessage":"Error: Invalid credentials. Please try again.","exceptionType":"PX.Data.PXException","stackTrace":" at PX.Data.PXLogin.LoginUserImpl(HttpContext httpContext, String userName, String password)\r\nWhat am I doing wrong?

How do I REMOVE HOLD on a Purchase Receipt with the REST API (just like the ReleaseFromHold Action in SOAP)?  I’m trying perform this same action as this button on the PO302000 screen… 

Hi, I am able to successfully create a Sales Order and all of the customer data, line item data etc. is correct except for RequestedOn date. It seems to be auto-assigning to the day before delivery based on the delivery Route assigned to the customer. Even if I put the RequestedOn date weeks in the future, it still assigns to the day before the next delivery route is scheduled. This is what my JSON Request Body looks like:  { "OrderNbr": { "value": "<NEW>" }, "OrderType": { "value": "SO" }, "CustomerID": { "value": "XXXXX" }, "note": "", "CustomerOrder": { "value": "XXXXXX" }, "Details": [ { "InventoryID": { "value": "XXXX" }, "OrderQty": { "value": 1 } }, { "InventoryID": { "value": "XXXX" }, "OrderQty": { "value": 1 } }, { "InventoryID": { "value": "XXXXX" }, "OrderQty": { "

Hello Everyone,I have requirement to pick the file from local path and attach a file using REST API from code level to the Sales Order. Can you please share the sample example for the same?

I’m attempting to use OData v4 to filter the PO collection based on the lines’ PromisedDate field: “$filter=POLineCollection/all(l: l/PromisedDate ne null)” However, I get an exception with this message:“Instance property 'POLineCollection' is not defined for type 'PX.Objects.PO.POOrder'”.What’s strange to me is that Acumatica definitely knows that POLineCollection exists; I can include it in a $select, and if I misuse the filter, such as “POLineCollection/all(l: l/PromisedDate eq 3)”, I get an “incompatible types” error.Am I missing something here?

I’m doing a PUT method in Postman but it keeps creating a brand new purchase receipt instead of adding Details to the existing PurchaseReceipt that I’ve specified.  How do I prevent a new PurchaseReceipt from getting created. URL:  /entity/Default/22.200.001/PurchaseReceiptBody:{        "ReceiptNbr": {"value": "PR00153497"},           "Details" :[            {              "POOrderNbr": {"value": "PO53472"},              "POOrderType": {"value": "Drop-Ship"},                            "TrackingNumber": {"value": "9999"},              "ReceiptQty": {"value": "1"},                            "InventoryID":{"value": "190-34563221"},               "POLineNbr": {"value": "1"}                          }            ],        "VendorID": { "value": "PU3" },        "VendorRef": { "value": "FROM_API" },                "Location": {"value": "MAIN"},        "Branch": {"value": "CM"}            } 

I’m trying to use Postman to retrieve a PurchaseReceipt but the only way I’ve been able to do this is by filtering by the ReceiptNbr.  Is there a way to filter by POOrderNbr?Here's what works successfully:/entity/Default/22.200.001/PurchaseReceipt?$filter=ReceiptNbr eq 'PR00153430'&$expand=DetailsThis returns an error ("The parent value for a property access of a property 'POOrderNbr' is not a single value. Property access can only be applied to a single value"):/entity/Default/22.200.001/PurchaseReceipt?$expand=Details&$filter=Details/POOrderNbr eq 'PO53414'  

I looked through the web service endpoints and I can’t find any to get the Campaign ID when given a campaign name.  Is there a way to get that through and endpoint? 

We have some PO’s generating from a 3rd party system. With Autonumbering off I can create a PO with API and use the 3rd party PO num. We also need to create some PO’s manually, but want to use different prefixes. Is there any way to have autonumbering on for 1 prefix but not the other?  Is there a better way to solve for this? Thank you

I have a customer who made a payment using a credit and wants to change to a different card (different payment method already associated with his account).  How can I modify the payment to reflect this?  I tried the following PUT method URL in Postman:https://sandbox.com/AcumaticaERP/entity/Default/22.200.001/PaymentHere’s the body I passed:{        "Type":{"value":"Payment"},        "ReferenceNbr": { "value": "183610" },        "PaymentMethod": {"value": "CC MASTCRD"},        "NewCard": { "value": false },        "CardAccountNbr": {"value": "Mastcrd:****-****-****-4203"}}I don’t get an error but, unfortunately, Postman just returns the existing Payment with no card change applied.

Hello everyone,First time poster here.  I have used the GitHub “endpoint model generator” solution to generate the DLL’s I need to allow my C# application to connect to our Acumatica instance with our extended endpoint and the RESTAPI dll’s (Acumatica.RESTClient.dll and Acumatica.RESTClient.ContractBasedApi.dll that get compiled along with my endpoint dll.I am using Visual Studio 2022 and C#.I have been unable as of yet to figure out why the authApi.Login() function just locks up the app.This is the content of the request (that was put together by the Acumatica code) as it looks immediately before being passed to the Client.SendAsync(request) call that hangs up.  {Method: POST, RequestUri: 'https://<ouracumaticadomain>/AcumaticaERP1//entity/auth/login', Version: 1.1, Content: System.Net.Http.StringContent, Headers:{  Content-Type: application/json; charset=utf-8}}    Content: {System.Net.Http.StringContent}    HasHeaders: false    Headers: {}    Method: {POST}    Options: {System

Does anyone know how to retrieve data in a CustomerPaymentMethod using a CustomerID, PaymentMethod name, Card Account Number, and Value using the REST API in Postman? Here’s what I have so far in my GET method:https://sandbox.com/entity/Default/22.200.001/CustomerPaymentMethod/Customer/C10010473712 I’m not sure what all the parameters are supposed to be so I just get an error using that:{    "message": "An error has occurred.",    "exceptionMessage": "No entity satisfies the condition.",    "exceptionType": "PX.Api.ContractBased.NoEntitySatisfiesTheConditionException",

Hi Team,We have a requirement as we create a receipt via API calls and insert line details with the insertion of attributes ..(using PUT request) Receipt is created with line details and released but attributes are not inserted. can you please review and suggest the best way possible to achieve it.Thank you!

Example: I need to update all the Sales Order data inputted in one instance to another instance of the same screen (screen SO301000) through an API call when I hit save. Any suggestions on how to do this? 

I am trying to get the access token using attach code but it shows error of “Invalid Client”. Error:  Connected Application:  

I have an open payment for a Sales Order in Acumatica.  Currently, Applied To Order is set to 0.00 for the payment attached to the order.  I would like to change this value to the unpaid balance.  I can easily do this in SOAP.  For REST, I am using the following URL in Postman:https://sandbox.com/AcumaticaERP/entity/Default/22.200.001/Payment However, I am constantly getting the following error:"Inserting  'AR Payment' record raised at least one error. Please review the errors.; ARAccountID: 'AR Account' cannot be empty.; ARSubID: 'AR Subaccount' cannot be empty." Here’s is the body I’m passing:{        "ReferenceNbr": { "value": "598089" },        "PaymentRef": {"value": "5006956/4/23/2024 8:18:10 AM" },        "AppliedToOrder": {"value": 200.00},        "CashAccount": {"value": "01010"},        "PaymentAmount": {"value": 200.00},        "PaymentMethod": {"value": "CASH"}}

I am trying to update Sales Price pricing via the REST API. There is no endpoint that I could see that will do this (there is the SalesPriceInquiry) – which seems to create the price if it does not exist, but it does not update. Is there a way to get it to update the price?I’m sending: SalesPriceDetails": [ { "EffectiveDate": { "value": "05/02/2024"}, "PriceType": { "value": "Customer" }, "PriceCode": { "value": "1000346" }, "Price": { "value": "12.99" }, "InventoryID": { "value": "OURSKU" }, "Warehouse": { "value": "CA" } }]But, I am getting the error:"error": "Duplicate Sales Price. This line overlaps with another Sales Price (Price: 10.990000, Effective Date: 5/2/2024, Expiration Date: )",Is there a way to tell it to update if the price exists?

I am doing purchase order integration from my platform to acumatica so i need to pass my Product items from my platform to the purchase order creation in acumatica. For example i choose the 1st , 2nd and 3rd checkbox of select products , i choose a vendor now i hit the api so i am asking how will i send these products in my Purchase order create api and where will i see these Products name in my purchase order ?  these products that are in the product name by selecting a vendor so where will be these product will be added or from where i can see these products in my Purchase Order in acumatica.

Hi just wanted to figure out on how to do filters on the StockItem endpoint? I wanted to filter to get Inactive items. What I’ve tried so far is adding this paramsItemStatus=Inactiveconditions = “ItemStatus eq Inactive”