Develop Integrations with Web Services | APIs

I’ve tried using RecordID as a parameter in the following DELETE method in Postman:https://sandbox.com/AcumaticaERP/entity/Default/20.200.001/SalesPricesInquiry/SalesPricesInquiry/5143487However, I just get the following error:{    "message": "An error has occurred.",    "exceptionMessage": "Operation is not valid due to the current state of the object.",    "exceptionType": "System.InvalidOperationException",    "stackTrace": "   at PX.Api.ContractBased.EntityService.FillEntityImplWithKeys(String version, String name, EntityImpl entity, String[] keys)\r\n   at PX.Api.ContractBased.SystemContracts.V2.SoapFacade.PX.Api.ContractBased.IRestGate.FillEntityImplWithKeys(EntityImpl entity, String[] keys)\r\n   at PX.Api.ContractBased.SystemContracts.V2.RestController.CreateEntityFromKeys(String objectName, String idsString)\r\n   at lambda_method(Closure , Object , Object[] )\r\n   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass6_1.<GetEx

Hey all.I’m looking for advice about entity restriction and cost allocation for multi entity customers. Let’s say we have Company A who has subsidiaries with Company B and Company C. An employee for company B might work on Projects setup on Company C, however they want to be paid out from Company B’s payroll, but keep Job Costing on Company C. Acumatica has different Companies and branches nested under those companies. I’m assuming what we need to do is filter the Projects for Company C based on some predetermined Branch configuration they have set up on our end when we establish the integration. However I’m not sure if there are any gotchas to this approach. Has anyone come across this before and have advice on how to handle it?

Hi,I want to trigger Sales Order remove hold action via REST API.End point : Posthttps://globalrubberindustrieslimited.acumatica.com/entity/SFEndPoint/22.200.001/SalesOrder/ReleaseFromHold{ "entity": { "OrderNbr": { "value": "SO000896" } }}But when request is triggered it shows an error.But , This So is already created.Can anyone help for this

Hello everyone!Following this material: Accessing Data in Generic Inquiries using Contract Based API’s (acumatica.com)I performed an exercise as detailed in the document and it works: However, when I create my own GI postman it does not return any results and I get this:The GI si basically two tables (POOrder and POLine) where you can see the detail that each PO contains. Do you have any idea what I am missing?Thank you very much for your support!Best regards.

Hello,I am attempting to create a PREmployeeSetting entity via the “Default/23.200.001/EmployeePayrollSetting” endpoint.My payload looks like this:{ "EmployeeID": { "value": "TEST1" }, "Active": { "value": "true" }, "TaxSettings": [ { "Name": { "value": "Social Security Number" }, "Required": { "value": true }, "Setting": { "value": "Employee_FED_SocialSecurityNumber" }, "State": { "value": "FED" }, "Value": { "value": "123123123" } } ], "CashAccount": { "value": "8000-1130" }, "ClassID": { "value": "HRLY" }, "PaymentMethod": { "value": "CHECK" }, "EmployeeTypeClassDefault": { "value": "true" }, "Compensation": [ { "Active": { "value": "true" }, "Earn

Hi, All I am trying to put notes on every customer. My login is successful but when I am trying to call put api through another script of python, its says you are not login in. I have attach my login code below. I have attach cookie in put request header but still it shows error. Any idea on this please. Thanks def login_to_acumatica():    # API endpoint    url = "http://my-company/AcumaticaSB/entity/Auth/login"    json_data = ({        "name": "ta",        "password": "Db}",        "tenat": "Store",        "branch": "",        "locale": ""        })    try:        # Send POST request with JSON body        response = requests.post(url,  json=json_data)        import re        # Check if the request was successful        if response.status_code == 204:            print("Login successful.")            print("Response:")            cookie = response.cookies              return cookie        else:            print("Login failed with status code:", response.status_code)    except Exception

Hi, I’m a retailer with a distributor using Acumatica for their ERP. They gave me a login so I can check inventory balances in real time, but as we carry thousands of their products I need an automated way to check stock level daily.I noticed that their implementation seems to have some web services enabled via a SOAP endpoint when visiting a “Web Services” link from the SP700000 screen ([clientname].acumatica.com/(W(1))/Soap/SP700000.asmx). I’m quite familiar with developing Python apps so I’ve been working on using this endpoint to pull their catalog down into a CSV file.So far I’m able to connect and authenticate to the endpoint and run GetSchema, but when I request the fields I want the endpoint just times out. Even if I specify just one Inventory ID the endpoint just times out eventually.Here’s my code for reference:import requestsfrom zeep import Clientfrom zeep.transports import Transportimport csvimport loggingimport sysfrom datetime import datetime# Set up logginglogging.basic

We have a project where the customer’s external system will be reading data from Acumatica via the REST Api regularly and often. Is there an alternative to using cookies, such as setting the connection up as a “known application” with a shared secret value?  So that their authentication comes with the request vs. having a login to get the cookie and then they have to store the cookie. I know that I can bump up the lifespan of a cookie, and maybe that’s my only option, but I’m curious if there is another way to grant access without the logon/logoff calls.

Is there a way to copy an endpoint that was created in a Test instance to a Prod instance? It does not appear these came over from a snapshot and I would have assumed they would.  Am I missing something or do these have to be manually recreated between instances?

hi, I am trying to get login using python code. My code is working fine in localhost. But when I am trying to do it with my company testing env . The login is raising Max retries error. I think This is because of logout. I tried same api in post man and it works fine over there.    HTTPConnectionPool(host='acusb.mycompany.local', port=80): Max retries exceeded with url: /entity/Auth/login (Caused by NameResolutionError("<urllib3.connection.HTTPConnection object at 0x000001FB3A068BD0>: Failed to resolve 'acusb.mycompany.local' ([Errno 11001] getaddrinfo failed)"))

My company uses a custom routing module that enforces cutoff times for sales order entry. We are experiencing issues because an API user is accessing our tenant from multiple time zones, but the cutoff time comparisons apparently weren’t built to handle these situations. To work around the issue, we’ve tried setting the user time zone preference (found under Users → Personal Setting). When accessing the site through the GUI, that time zone is used, regardless of login location. But for API access, it seems that the time zone of the login location overrides the user preference. Is there a way to control the time zone associated with an API login? Either by setting a user preference, or by specifying somewhere in the API request? Thanks!

This article lists field changes in the endpoints for 24R1: https://help.acumatica.com/(W(2))/Wiki/ShowWiki.aspx?pageid=b49d1af2-80a7-4271-b421-ab64173eead8 For the field highlighted below, I cannot find it in the 24R1 DAC schema browser. I am not knowledgeable of endpoints. Would appreciate advise! 

How can I input data into the warehouse column in the MaterialDetail section of the BillofMaterial API through the API? I have successfully input data into BillofMaterial through the API, and the warehouse column in MaterialDetail API has been filled with "Warehouse": { "value": "PMS23" }, but the result does not appear. 

Hello, We just implemented Shopify for both ecommerce and POS and I’ve noticed an issue with the order type import on a few orders. I’m not sure why or how this is happening. On the Shopify Stores screen, we have our Order Type for Import set as WB for web orders, and then FI and FO are the POS order types. However, a few orders have come through with a different order type, MO for mail order.   The one common thing I have been able to find between these sales orders is that there are items included that are automatically fulfilled (for shipping orders) or items that are not automatically fulfilled (for in store orders). Has anyone else noticed this issue or resolved something like this? Thanks in advance!

Hi There Hope you are doing well I’m trying to retrieve project tasks based on some parameters but it throwing the error Endpoint : /ProjectTask?$filter=startswith(ProjectTaskID, '0LED') and ProjectID eq '000407' but the error i’m receiving is :    "exceptionMessage": "Incorrect syntax near the keyword 'AND'.",  Thanks

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