Develop Integrations with Web Services | APIs

I’m trying to build a script that will create a new customer via REST API. I’m running into issues with linked entities not shown in the Web Service Endpoints form yet I need to pass a value for them. For example, I receive the following error message. 'error': "Inserting 'Location' record raised at least one error. Please review the errors.; CSalesAcctID: 'Sales Account' cannot be empty." However, I’m not sure how to resolve this issue when I’m sending a PUT method to Acumatica with the following parameters.    },    'Location':{        'CSalesAcctID': {'value': 60030},    }, I noticed that Location was not listed as a linked entity in the Web Service Endpoints list. How am I able to make the connection to Location if it’s not a part of the endpoints list?

I’m struggling getting the Employee ChangeEmployeeID Action to work.  In Postman I’ve setup the following:Verb: PUTURL: <host>/entity/Default/20.200.001/employee/ChangeEmployeeIDBODY:{"entity": {"EmployeeID": {"value": "{OldEmployeeID}"}},"parameters": {"EmployeeID": {"value": "{NewEmployeeID}"}}}I’m receiving the following error: "Specified argument was out of the range of valid values. Parameter name: Invalid uri structure"Does anyone have a working payload for this action?Thanks in advance

i am trying to perform a lookup based on employee email to get the details.is there anyway to query an employee based on his email via restApi in acumatica

I am calling entity/auth/login as restful PI and usually get 202 response.  But every third or fourth time or so get 500 - API Login Limit If I walk away for 10 minutes and come back exact same code works for a whileI have made sure I am logging out after each login.  I am doing them farily slow by hand so maybe a second each attempt.  Any suggestions where I might trty and look to inderstand what I am doijng wrong?Thanks,Keith 

What REST API endpoint would I use to transfer a stock item from one Warehouse location to another Warehouse location?

We use https://[tenant].acumatica.com/identity/connect/authorize to get an authorization code which works fine then we callhttps://[tenant].acumatica.com/identity/connect/tokenendpoint with below params:grant_type: authorization_codeclient_id: [client id]client_secret: [client secret]code: (the value from "code" query parameter from the first request respomse)redirect_uri: https://[local].ngrok.io/accumatica/access-tokenWe get a bad request with error message:{ "error": "invalid_client"}What could be the reason?

Hi there,can anyone please help me out on how to setup things in acumatica for establishing connection from an integration tool and fire some restAPIS. thank you 

Hi,I’m trying to create a shipment via the rest api. The api call succeeds and the shipment is created but I’m getting errors in the Request Profiler. How do I debug these? The errors are vague and the stack traces don’t help either.Data:Type = “Shipment”, ShipmentDate = “9/12/2022”, CustomerID = 2943, Operation = “Issue”, WarehouseID = “MAIN”.Detail lines:OrderNbr = “SO123”, LineNbr = 1, InventoryID = “50500”, UOM = “CASE”, OrderedQty = 2, OpenQty = 0, OrderType = “SO”, ShippedQty = 2, WarehouseID = “MAIN”. How do I figure whether I’m filling in all the appropriate fields for the call?The request profiles is giving these errors:Sequence contains no matching element Exception has been thrown by the target of an invocation Operation Failed Object reference not set to an instance of an object

We Want To Create A  Batch Payment for multiple bills & Credit Adjustmentin batch payment create custom batch number . 

Hi, I am trying to customize or filter the Inventory ID Lookup on the Sales Order Screen (SO30100) by using SOLine_InventoryID_CacheAttached. Whenever I select the item, the grid line is filled up with the internal inventory ID value instead of the inventory CD.After selecting the item Here is my code public class SOOrderEntry_Extension : PXGraphExtension<PX.Objects.SO.SOOrderEntry> { [PXMergeAttributes(Method = MergeMethod.Append)] [InventorySelectorCustom(typeof(InventoryItem.inventoryCD))] protected virtual void SOLine_InventoryID_CacheAttached(PXCache cache) { } [Serializable] public class InventorySelectorCustom : PXCustomSelectorAttribute { public InventorySelectorCustom(Type type) : base(type, typeof(InventoryItem.inventoryCD),typeof(InventoryItem.descr) , typeof(InventoryItem.itemClassID), typeof(InventoryItem.itemStatus), typeof(InventoryItem.itemType)

How to access acumatica from an integration applications using auth 2.0 authorization

Hello all I have made a custom Inquiry screen, that filters and provides a record based on passing 3 input parameter.Item Sales Price ScreenNow I want the same value to be returned when via WebService . I did extend  my webservice Endpoint and added new screen. However, I am not able to see the right value on mapped object Item Sales Price InquiryWhen I call via my POSTMAN, I get empty result. Below is my code.public class ItemSalesPrice : PXGraph<ItemSalesPrice>    {        public PXFilter<SalesPriceFilter> Filter;        [PXFilterable]        public PXSelect<SalesPriceResult> DetailsView;        public PXCancel<SalesPriceFilter> Cancel;        protected virtual IEnumerable<SalesPriceResult> detailsView()        {                 ----                yield return ar;            }        }}  public class SalesPriceFilter : IBqlTable { #region CustomerID [PXDefault(PersistingCheck = PXPersistingCheck.Nothing)] [CustomerActive(Displ

why this payload is giving me an Error:422 "error": "Inserting 'Address' record raised at least one error. Please review the errors.; CountryID: 'Country' cannot be empty.",{"Status": {"value": "Active"},"EmployeeID": {"value": "CRIC123789"},"EmployeeName": {"value": "Doe, Jane"},"FinancialSettings":{"APAccount": {"value": "ACCOUNT123"},"APSubaccount": {"value": "000000"},"ExpenseAccount": {"value": "ACCOUNT456"},"PaymentMethod": {"value": "CHECK"},"PrepaymentSubaccount": {"value": "000000"},"SalesAccount": {"value": "ACCOUNT789"},"TaxZone": {}},"EmployeeSettings":{"BranchID": {"value": "CRIC012345"},"Calendar": {"value": "NEWCAL1234"},"CurrencyID": {"value": "USD"},"CurrencyRateTypeID": {"value": "SPOT"},"DepartmentID": {"value": "1"},"EmployeeClass": {"value": "EMPCLASSNE"}},"ContactInfo":{"LastName": {"value": "Doe"}},"Address":{"CountryID":{"value":"India"}}}

Hello. Im trying to run SalesOrderCreateShipment method right after the sales order is created.Im sending this (json encoded) array http://joxi.ru/LmGpkVnuwQvRR2 to /entity/Default/20.200.001/SalesOrder/SalesOrderCreateShipmentaddress (just like here) https://help.acumatica.com/(W(8))/Help?ScreenId=ShowWiki&pageid=9a0b1037-c931-4eff-a974-15403d3227a7but getting the following error"Error in action invocation: Value cannot be null. Parameter name: key"here is stack trace https://justpaste.it/52nn1wats im doing wrong? thanks!

Hi All, .i am basically from integration background.. i've just installed the local instance of acumatica ERP.. i wanted to create an employee in acumatica via postman by using the rest apis..… i have read the documentation but didnt understand how can i get those Endpoint URLs.. please help me out.. Thank you  

Hello Team,I found the following error with payments.1. I have created a payment via API. The payment is being created successfully.2. Then I use a payment to allocate with invoice or credit memo via API to pay it.3. Send the payment with allocation to the invoice or credit memo to Acumatica via API.Acumatica returns the following error message:Payment update request returns the error message - "exceptionMessage": "An error occurred during processing of the field Reference Nbr.: Reference Nbr. 'AR.......' cannot be found in the system.\nPX.Data.PXOuterException: An error occurred during processing of the field Reference Nbr.: Reference Nbr. 'AR......' cannot be found in the system."When I repeat the same Payment update request after a period of time (in 1,5,10,20 minutes), Acumatica creates a payment successfully.Could you clarify what is the reason of this behavior?

I’ve been working on debugging this one for a couple weeks now. Due to the fact that this project is not open source, and there is encryption being employed to verify requests, it took a while indeed to finally figure out where this bug was exactly. I have been circling it for a couple weeks, but I didn’t have the time to go all the way down the rabbit hole until now.The Workwave API functions by having the client set a callback url where Workwave can send requests when deliveries and other things occur in Workwave. This callback url must conform to best practices for urls, and therefore cannot violate the RFC’s for urls by, for example, having a non-url-encoded space in the url.The Acumatica Webhook feature, on the other hand, does not url encode spaces in webhook urls, and hardcodes the url for a webhook to the name of the site and the company, which can have a non-url encoded space in it...see red arrow.  This is where we get into the catch 22 part of this particular bug. If you add

Hello, I am new to Acumatica, I have been working for a while on a project trying to cross information between Acumatica and other information sources and I am using Node js with an endpoint service to do that, let me show you what my problem is.I got the items from my request, as shown in the image (number 1), in my request I used the parameter "$expand=Detail" for that reason, I got all the items (number 2) but it takes a lot of time (number 3 ) around 30 seconds, I need to reduce the query time.Different parameters that I can use are mentioned in the Acumatica notes, one of them is "$filter". I have tried using different ways to filter the query, but to no avail.The parameters has been send like:"<Acumatica ERP instance URL>/entity/Integration/18.200.001/Integration?$expand=Detail&$filter=Date gt DateTimeOffset'2022-08-03T00:00:00+00:00'" I tried to test with Postman and it's response was:{"message": "An error has occurred.", "exceptionMessage": "More than one entity sa

Hi,Previously I sent documents to Acumatica files for bills with the help of such requesthttps://myacumatica.com/entity/ARTSEndpoint/20.200.001/Bill/INV/002272/files/image (3).pdfFor Checks and Payments it worked via such requesthttps://myacumatica.com/entity/ARTSEndpoint/20.200.001/Payment/payment/002272/files/file.pdfHow to do same for Purchase Receipt tab ? I tried several variations but did not succeed in it 

  Quick question.  We renamed our endpoint that we use for our customization, but we need to delete the old endpoint for some of our customers that still have the old one.  The old endpoint was named Altec2017R2, and is now called DLAltec2017R2.  I can't see any way to delete the old endpoint from the customers list of endpoints. 

Hi,I am doing Unit testing by using Acumatica Test SDK.https://www.acumatica.com/blog/creating-acumatica-test-sdk-tests-from-scratch-for-isvs/By taking the reference of above link Compiling the Code for my custom screen.Getting the Below error'Tests.exe' (CLR v4.0.30319: DefaultDomain): Loaded 'C:\WINDOWS\Microsoft.Net\assembly\GAC_32\mscorlib\v4.0_4.0.0.0__b77a5c561934e089\mscorlib.dll'. Symbols loaded.'Tests.exe' (CLR v4.0.30319: DefaultDomain): Loaded 'C:\Users\TH-003_PC\source\repos\Tests\Tests\bin\Debug\net4.8\Tests.exe'. Symbols loaded.'Tests.exe' (CLR v4.0.30319: Tests.exe): Loaded 'C:\Users\TH-003_PC\source\repos\Tests\Tests\bin\Debug\net4.8\Execution.dll'. 'Tests.exe' (CLR v4.0.30319: Tests.exe): Loaded 'C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\netstandard\v4.0_2.0.0.0__cc7b13ffcd2ddd51\netstandard.dll'. Cannot find or open the PDB file.'Tests.exe' (CLR v4.0.30319: Tests.exe): Loaded 'C:\Users\TH-003_PC\source\repos\Tests\Tests\bin\Debug\net4.8\PX.QA.Tools.dll'. 'Tests.exe'

Scenario:We want to create returns via REST APIs. We have published a customization package for this. Technically, this is how the customization package works:Creates a blank RC order Trigger SalesOrderAddInvoice action to add products from the invoices Update RC with relevant quantitiesThe above process works for the first RC.Any further RC creation from the same invoice throws the below error:"The return quantity exceeds the quantity available for return for the related invoice line <INVOICE_NBR>. Decrease the quantity in the current line, or in the corresponding line of another return document or documents <RETURN_NBR> that exist for the invoice line." This is the similar error we usually see on Acumatica UI when adding the same inventory from an invoice.  However, we can create the RC from the UI by modifying the quantity. Question:Is there anyway to fix this issue? We are on Acumatica 2022 R1. Regards

 i create extendedEndpoint for update Hold = false and result like in picture.how to update hold = false with API?

When I publish my Api to other multiple sites. project name Dharmandar publish but execute all database my script not execute show my create endpoint not show in web service endpoint. How i this Check execute through Api.

I want to publish that API to other multiple sites using some code, I will be having access token of every customer but not UI access. So can you please share the way of publishing this kind of extension to any customer