Develop Integrations with Web Services | APIs

Hello everyone,Would like to check if anyone tried the custom Endpoints for the following screens to update data on the screen. We created custom endpoints as shown in the below screenshots, however when trying to update the Restriction groups through Postman using custom endpoints, it gives an error as shown in the following screenshots.Appreciate any input to resolve the errors specified below.Custom endpoints created for the screens  - Restriction Group by GL, Restriction Group by BranchScreenshots for Custom endpoints:Request used:Restriction Group by GL{    "AccountCD": {        "value": "10100"    },    "Type": {        "value": "Asset"    },    "Description": {        "value": "Petty Cash"    },    "AccountClass": {        "value": "CASHASSET - CASH AND CASH EQUIVALENTS"    },    "GroupName": {        "value": "International Customers"    },    "GroupType": {        "value": "A"    },    "Included": {        "value": "true"    }}RestrictionGroupsbyBranchRequest used:{        "Br

I tried uploading the file, and I am receiving an error message:  

Is there a place I can go to see all the field names for a given entity (ie: StockItems).My reason is that I have some sync processes that download StockItems via the rest API. However, the properties/field names that the rest API returns are different than what I see in a Generic Inquiry. For instance, in the rest API, the field name for Description is “Description”. In the GI, its called DESC. I was hoping there was some sort of way I can see how those mappings work. I am porting some of these REST Api calls over to oData and am unsure what the fields are called in the Generic Inquiry UI screen. Thanks! Eric

Has anyone had experience with the DocuSign CLM product?  I’m looking to see if there is an integration to that specific product.

Our customer service team gets calls from customers who wants to place an order . We use acumatica to create purchase order and sales order .My question is ‘can an API be setup so that when receving a call from a customer , based on the customer contact number , Acumatica should automatically pull up the customer information and show it as a pop up in the acumatica screen. This will save some time since the customer service representative need not manually look/search for the customer in acumatica every time they get a call.  is it possible in acumatica ?

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?