Introducing Acumatica Cloud ERP: 2026R2
Technical discussions focused on Web Services and APIs for developers
Recently active
Hi all,My objective is to connect my java client with the SignalR Hub.I added a push-notification with Destination Type SignalR Hub as it is described here: Push Notifications: To Connect to the SignalR Hub.I use the following code snippet to connect my client with the SignalR Hub:String login = "<my_user>"; String tenant = "<my_tenant>"; String password = "<my_password>"; String basicAuthPlain = login + "@" + tenant + ":" + password; String encodedBasicAuth = Base64.getEncoder().encodeToString(basicAuthPlain.getBytes()); HubConnection hubConnection = HubConnectionBuilder.create("https://<my_x360_domain>/PushNotificationsHub") .withHeader("Authorization", "Basic " + encodedBasicAuth) .build(); hubConnection.start().blockingAwait(30, TimeUnit.SECONDS);... However, after executing start().blockingAwait() I receive the http status 401. Do I miss something? Can anyone tell me how I can sucessfully connect/authenticate the client? Thanks in advance
For some reason our RefreshToken is always expiring after 24 hours. Regardless of what we set in Connected Applications settings. We are using Resource Owner Password Credentials and RefreshToken is set to Absolute expiration 30 days. Our Acumatica version is: 2024R1 and installed locally. Any help is much appreciated
hi!we have a prospect who’s current POS system is lightspeed POS and they are looking to make the switch to acumatica. I was wondering if anyone else has any clients who use lightspeed pos and was able to successfully integrate with acumatica. I would love to hear your experience and what challenges you faced.
We are trying to create an integration with Acumatica API and we are encountering issues or weird behavior when updating multiple items in a parent record.For example when we try to update multiple contacts for a customer, it won't update the all contacts but only update the first one, but the weird thing is it picks up the values from the second item to update the first item, like the contact note field of second item will replace the contact note field of the first item, we are not sure if its bug or something.Anyone experience the same issues?Here is my sample Json payload for a Customer PutEntity endpoint, the note for ContactID: 100745 will replace the note for ContactID: 100743, but will not touch the second item.Seems like only first Contact gets updated.{ "id": "01a0c017-df7f-ea11-8175-b9d61cb73193", "Contacts": [ { "note": { "value": "Note for 100743" }, "ContactID": { "value": 100743 }, }, { "note": { "value": "Note f
Hi All,I am trying to set up a push notification to a Google Space webhook. I get an error that the format is incorrect - the error is generated from Google. Google does not like the format of the JSON that is sent.Does anyone know how to customize the JSON?
I am having issues setting the PrimaryContact on a BusinessAccount entity.We are building a customer application form where potentical customers can apply for an account. This data is going to flow into the Business Account entity as a “prospect. The application will contain their business information as well as a list of owners/authorized buyers. These owners will be added as associated contacts to the business account entity. I have all of that working via the RestAPI without much issue. The trouble I am having is setting the first owner (in the list of owners) as the PrimaryContact. I can’t get anything to work. Here are my order of operations: Create the BusinessAccount Iterate over the incoming contacts and create each new contact and associate them to the BusinessAccount ID Call and PUT against the newly created BusinessAccount and pass in the PrimaryContactID of the first Contact in the list from step 2. (this isn’t working) I am doing a PUT to {{MY-BASE-URL}}/entity/PHDCus
Good day,I have a client who would like to use Watsaap to send customer notifications, I have not been able to find something on the market, anyone have some suggestions?Thank you!
Hi all, we have a pretty large ACU implementation that ends up crawling to a halt. I am NOT the Acumatica owner in that, I do not support this system, another vendor does. We have written a robust integration that uses GI’s and OData to sync data to an external DB which is for the public facing eCommerce website. I use a combination of hot path and cold path data syncs. Hot paths are push notifications...so I get the data updates for some entities that way. The Cold path are syncs that run every 3 hours. This uses oData over the GI’s. These will reconcile any thing that might have been missed on the push notifications and other entities that don’t need to be as timely. All the syncs are delta/incremental updates. All of those queries are quite fast on a normal day. When there are system issues, these really slow down as well. These syncs have been in play for many many months. Almost untouched for the last 6-9 months. My issue is that we (for lack of better terms) are being blam
Some tables throw ‘The multi-part identifier could not be bound.’ when filtering by specific fields. Below is an example for Invoice filtering by BillToContactOverride. Attached is the SQL query executed by the API as retrieved from the request profiler. It looks like the generated SQL is incorrect. This is happening across multiple versions (tested v23 and v24). No customizations have been applied to the instance. DECLARE @P1 AS INT = -2147483648, @P2 AS INT = -2147483648, @P4 AS BIT = 1;SELECT TOP (1000) [Document_ARInvoice_ARRegister].[DocType] AS [DocType], [Document_ARInvoice_ARRegister].[RefNbr] AS [RefNbr], [Document_ARInvoice_ARRegister].[NoteID] AS [NoteID], NULL AS [NoteText], NULL AS [NoteFiles], (SELECT TOP (1) [DocumentNoteExt].[NoteText] FROM [Note] AS [DocumentNoteExt] WHERE ([DocumentNoteExt].[CompanyID] IN (1, 2)
Today all our PUT requests regarding Appointments seem to have stopped working via the REST API. We’re using a custom endpoint. Has anybody seen an error like this before? We are a bit stuck, as all the endpoints were previously working."message": "An error has occurred.","exceptionMessage": "Sequence contains more than one matching element","exceptionType": "System.InvalidOperationException","stackTrace": at System.Linq.Enumerable.SingleOrDefault[TSource](IEnumerable`1 source, Func`2 predicate)at PX.Api.ContractBased.EntityExportContextBuilder.GetDescriptorKeys(EntityImpl entity, String baseMappingKey, Boolean includeNulls) in C:\\build\\code_repo\\NetTools\\PX.Api.ContractBased\\EntityExportContextBuilder.cs:line 2064at PX.Api.ContractBased.EntityExportContextBuilder.TryDetermineDescriptorFromValues(EntityImpl entity, String baseMappingKey, EntityDescriptor& entityDescriptor, Boolean includeNulls) in C:\\build\\code_repo\\NetTools\\PX.Api.ContractBased\\EntityExportContextBuil
I am writing an iterface to pull open operations from Acumatica but I am finding that the planned setup time and planned run time doesn’t appear to be in the operation records. Where would I find these?
Hello, I'm new to API development and I need help with a specific query. In my current project, I can successfully retrieve all employees from the top list using $expand=Employees.My goal is to get the results from the bottom section (Overrides) which are linked to specific employees. In the UI form, when I click on Employee #1, the bottom window changes to show their specific overrides, and similarly for Employee #0.I've tried using $expand=Employees/EmployeesOverrides, but this returns Employee #0's overrides for Employee #1, which doesn't make sense.How can I properly query the API to get the correct overrides for each specific employee? I need to establish the proper parent-child relationship between each employee and their corresponding overrides.I've attached screenshots showing the UI interface and the API endpoint configuration for reference. Any guidance would be greatly appreciated!employee 0 overridesemployee 1 overrides
I got this error when i validate a Default endpoint without any extension, same with Admin user.Why?Thanks
Hello,In the Web Service Endpoint screen in 2020/R1, when I click on Validate Endpoint for endpoint Default/18.200.001, it executes for about a minute, then fails with this exception:Exception of type 'System.Web.HttpUnhandledException' was thrown. PX.Data.PXNotEnoughRightsException: You don't have enough rights on 'Select'. …Can anyone please shed some light on what is happening?
Hi, I am trying to save CustomerLocation including LocationContact.Address, the CustomerLocation gets saved but not the child object LocationAddress. I am using PUT.how to save CustomerLocation with Child object LocationContact.Address? var customerLocation = new CustomerLocation { AddressOverride = new BooleanValue { Value = false }, ContactOverride = new BooleanValue { Value = true }, Customer = new StringValue { Value = accountingData[0].EntityId.ToString() }, LocationID = new StringValue { Value = accountingData[0].Addressid.ToString() }, LocationName = new StringValue { Value = accountingData[0].Addressline1.ToString() }, LocationContact = new Contact(), Active = new BooleanValue() { Value = true }, }; customerLocation.LocationContact.Address = new Address() { AddressLine1 = new StringValue { Value = accountingData[0].Addressline1.ToString() }, AddressLine2 = new StringValue { Value = string.IsNullOrEmpty(accountingData[0].Addressline2) ? str
I would like to know if it is possible to send payment links to customers so they can pay their invoices through Stripe, integrated with Acumatica. Unfortunately, Acumatica Payments is not available in my region, so I am exploring alternative options to collect payments efficiently.thanks.
I want to use rest API to upload item prices against a vendor, can I directly upload to the “Supplier Price” without going through the worksheet hold and release route?
Hi Everyone,We are making an API calls to Acumatica like below but creating lot of API sessions and not logging out from Acumatica. Can you please review and help us on this? Log into Acumatica - Working Creating Sales Orders - Working Logout from Acumatica - Not workingPlease find the screenshot for reference.
Hi...we are in the middle of converting to Acumatica and I am just beginning to get into the API for integrating with our other internal systems.I have figured out how to use ODatav4 to read stock items. I even figured out how to use a “Navigation Property” (by trial & error) to pull in the item class description. Below is the current request broken down for readability.But now I also want to pull all of the Cross-References (customer item numbers) for a given inventory item. The Cross-References show as another DAC - INItemXRef - but there doesn’t seem to be any navigation property from the InventoryItem DAC to it. Can I pull in this related information with an $expand clause? Or do I just need to query the INItemXRef separately and combine them manually?Thanks!https://<company>.acumatica.com/ODatav4/<tenant>/PX_Objects_IN_InventoryItem?$select=InventoryCD,Descr,ItemStatus,BaseUnit&$filter=ItemStatus eq 'AC'&$expand=INItemClassByItemClassID($select=ItemClas
When I uploading an image using the API, the following error message occurs: Error 500: Internal Server Error.
Hello,I’m currently trying to set up a webhook or similar functionality in Acumatica, where I can receive data to my custom page URL whenever specific events occur, such as an inventory update or sales order creation.I’ve looked into Business Events and adding Subscribers, but I couldn’t find an option to directly specify my page URL to receive a webhook response. Am I approaching this the right way, or is there another recommended method for achieving this?Looking forward to your guidance.
Hello all, I am trying to Reverse an invoice and apply credit memo via the API. I have extended the endpoint and added the action ReverseInvoiceAndApplyToMemo. I am not sure where to find the correct payload to pass to it. If I pass the below I get “ "The Reverse and Apply to Memo button is disabled."Does anyone know or where do I find the correct payload to send? Thank you { "Entity": { "RefNbr":{"value":"AR000003"} }}
Hi Team hope you are doing well, POST /Release i’m trying to release refund type in the payment object using rest api { "entity": { "Type": { "value": "Refund" }, "ReferenceNbr": { "value": "000077" } }}the response is { "statusCode": 202} but when i check the page in Acumatica the refund the release button is still there Thanks
I am trying to create a Sales Invoice with a Payment but i get the following error: "An error occurred during processing of the field CuryAdjdAmt: Nullable object must have a value.."I am using the /Default/23.200.001/SalesInvoice endpoint and this is my request:What am I missing or do i need to create first the Sales Invoice, then the Payment and then apply it? { "ReferenceNbr": { "value": "<NEW>" }, "CustomerID": { "value": "ABAKERY" }, "ExternalRef": { "value": "801PM00000DhqGnYAJ" }, "Type": { "value": "Invoice" }, "IsSpecialOrder": { "value": false }, "Date": { "value": "2024-04-22" }, "ShipToAddressLine1": { "value": "Test" }, "ShipToOverrideAddress": { "value": true }, "ShipToOverrideContact": { "value": true }, "ShipToCity": { "value": "Test" }, "ShipToCountry": { "value": "US" }, "ShipToPostalCode": { "value":
How to Create SalesOrder with Shipping and Payment details using REST API in node js
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.