Skip to main content

Develop Integrations with Web Services | APIs

Technical discussions focused on Web Services and APIs for developers

  • 802 Topics
  • 3,181 Replies
802 Topics
S
Freshman I
sclassingFreshman I
asked in Develop Integrations with Web Services | APIs
Unable to delete from simple data object list

We’ve created a simple BLC object named SOShipmentMutex. We are editing it via a listview page with a custom DAC. When we delete a row from the Shipment Mutex grid via the UI, it deletes successfully. However, when we try to delete via the REST API, the delete is not performed. The RowDeleting event is hit when using the UI, but it is not hit via the API. We are able to successfully add a new row via the API, but delete is not fired. Can someone help us figure out why we can’t delete via the API? public class SOShipmentMutexMaint : PXGraph<SOShipmentMutexMaint> { public SelectFrom<SOShipmentMutex> .View ShipmentMutex; public PXSave<SOShipmentMutex> Save; public PXCancel<SOShipmentMutex> Cancel; protected virtual void _(Events.RowDeleting<SOShipmentMutex> e) { var row = e.Row; } } [Serializable] [PXCacheName("SOShipmentMutex")] public class SOShipmentMutex : PXBqlTable, IBqlTable { #region ShipmentNbr [PXDBString(15, IsUnicode = true, InputMask = "", IsKey = true)] [PXUIField(DisplayNam

273
Naveen Boga
Captain II
J
Freshman I
JayavenithaFreshman I
asked in Develop Integrations with Web Services | APIs
How to Create SalesOrder with payment details REST API

How to Create SalesOrder with Shipping and Payment details using REST API in node js

555
hdussa
Jr Varsity I
S
Freshman I
swassoufFreshman I
asked in Develop Integrations with Web Services | APIs
Import Schema Rest api

Hello I followed the documentation to import Rest Schema https://help.acumatica.com/(W(29))/Help?ScreenId=ShowWiki&pageid=41be41d9-05cb-4536-a7a8-b38610760065 when I opened the solution in visual studio I see the generated models have duplicate constructor parameter any help would be appreciated

191
hdussa
Jr Varsity I
A
Freshman I
alancodlessFreshman I
asked in Develop Integrations with Web Services | APIs
Acumatica API not updating multiple Contacts under Customer records

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 for 100745" }, "ContactID": { "value": 100745 } } ], }

272
A
Freshman I
rcreasy
Varsity I
rcreasyVarsity I
asked in Develop Integrations with Web Services | APIs
Push Notification to Google Space Webhook

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?

385
rcreasy
Varsity I
D
Freshman I
DharmandarKumarFreshman I
asked in Develop Integrations with Web Services | APIs
i am not able create check for bill through rest api after upgrade acumatica

i am not able create check after upgrade acumatica in october 2024got this error{"message":"The request is invalid.","modelState":{"":["An exception occurred during input parsing"]}}please suggest me but missing my endpoint https://local//entity/Acumatica/1.0.3/Check json body this {"CuryOrigDocAmt":{"value":0},"CashAccount":{"value":"10060"},"Type":{"value":"Check"},"Vendor":{"value":"V001097"},"CurrencyID":{"value":"USD"},"Hold":{"value":false},"PaymentAmount":{"value":10.19},"PaymentMethod":{"value":"CREDITCARD"},"Details":[{"CashAccount":{"value":"10060"},"PostPeriod":{"value":"102024"},"BranchID":{"value":null},"InventoryID":{"value":null},"OrderQty":{"value":0},"WarehouseID":{"value":null},"AmountPaid":{"value":10.19},"Balance":{"value":10.19},"CashDiscountBalance":{"value":null},"DocType":{"value":"Bill"},"ReferenceNbr":{"value":"001301"}}],"PostPeriod":{"value":"102024"}}

977
jinin
Pro I
B
Freshman I
BEXJensFreshman I
asked in Develop Integrations with Web Services | APIs
Connect to SignalR with Java Client

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

252
B
Freshman I
D
dianegrayson
asked in Develop Integrations with Web Services | APIs
Integration with Ceridian or Payworks (Canadian PR)

Is there an existing integration with either Ceridian or Payworks, both for Canadian PR processing.

221
chameera71
Varsity I
T
Freshman I
trishantpFreshman I
asked in Develop Integrations with Web Services | APIs
Help with Integrating Certificate of Analysis Data – No Custom Endpoints or Screens Found

Hi everyone, I'm new to Acumatica and currently working on integrating Certificate of Analysis (COA) data. However, I'm having trouble finding any custom endpoints or relevant screens that store or manage this data. I've searched through the default APIs and screens, but nothing related to COA has come up. I wanted to check if anyone here has worked with COA data in Acumatica before. Does Acumatica have a built-in module or screen where COA data is typically stored? Any guidance or best practices for handling COA data in Acumatica would be greatly appreciated. Thanks in advance for your help!

331
jamesh
Semi-Pro I
D
Freshman II
dominicfedcoFreshman II
asked in Develop Integrations with Web Services | APIs
REST API: can't set detail line Customer Order Nbr for lines with quantity greater than one?

We’re exploring using blanket orders with line splits based on Customer Order Nbr. values, and it appears to be working well! We ran into some odd behavior: when creating a sales order with the REST API (using the /SalesOrder endpoint), we’ve observed that the value specified in the a detail line’s CustomerOrderNbr field is apparently discarded in the generated order whenever that line’s OrderQty is greater than one. This does not seem to happen when creating orders using the web UI; only with API-created orders. Is this expected? Anyone have suggestions for how to troubleshoot? Thanks again!

231
Vignesh Ponnusamy
Acumatica Moderator
D
Freshman II
dominicfedcoFreshman II
asked in Develop Integrations with Web Services | APIs
REST API: adding payment to sales order succeeds, but the payload is missing payment data?

Hello, Occasionally, when adding a new payment to an existing sales order with a PUT to the /Payment endpoint, the request succeeds (HTTP 200) but the response body is nearly empty. Rather than containing a Payment structure with ReferneceNbr and other fields, the server gives us a response body like this: {"id":"912d9149-55a4-4b1c-8575-73ebbfc2027c","rowNumber":1,"note":null,"custom":[]} This is problematic for our use case, because we need to store the payment’s ReferenceNbr, which is missing. Is the expected behavior? It appears to happen rarely, but I haven’t been able to determine the cause. Any recommended way to work around it? Any help is appreciated, thanks!

464
D
Freshman II
A
Jr Varsity I
AleciaJr Varsity I
asked in Develop Integrations with Web Services | APIs
Bulk update customers

Hi All, We have seen discussions about how to do a bulk update by manually doing an import scenario on the Acumatica system. Is it possible to update a list of customers via a singular API call? Kind regards, Alecia

1432
A
Freshman I
P
Jr Varsity II
PBSAJr Varsity II
asked in Develop Integrations with Web Services | APIs
REST API: Order of Events

I am trying to change an Inventory ID on an existing SO Line via REST API. It seems the SOLine_InventoryID_FieldUpdated logic is interfering with this. Setup: Create an SO with an inventory item (mine is 011705) Have at least 2 warehouses available Have another inventory item (mine is 011706) In Postman, I PUT to /entity/Default/23.200.001/SalesOrder?$filter=OrderNbr eq '180214'&$expand=Details&$select=OrderNbr,Details/InventoryID,Details/WarehouseID { "OrderType": { "value": "SO" }, "OrderNbr": { "value": "180214" }, "Details": [ { "id":"fb135987-eeea-ef11-912e-00d86198c979", "WarehouseID":{ "value":"GREEN" }, "InventoryID": { "value": "011706" }, } ]} If the new part has a default warehouse, this request will go through, but the default warehouse will be used instead of the warehouse I sent: { "id": "68fc2b59-eeea-ef11-912e-00d86198c979", "rowNumber": 1, "note": { "value": "" }, "Details": [ { "id": "fb135987-eeea-ef11-912e-00d86198c979", "rowNumber": 1, "note": null, "InventoryID":

352
P
Jr Varsity II
M
Freshman I
muller61Freshman I
asked in Develop Integrations with Web Services | APIs
Bill amount stays at 0

I’m using version 2024 R2: In Postman I’m trying to create a simple bill that looks like: URL: https://***/entity/Default/24.200.001/bill with body: { "Type" : { "value" : "Bill" }, "Vendor" : { "value" : "MIC001" }, "VendorRef" : { "value" : "12FF" }, "Amount" : { "value" : 100.00 } }I do get a 200 OK response but the amount is zero, I’ve tried entering more fields but the results are the same. What am I doing wrong?

142
M
Freshman I
W
Freshman I
WilliamqhFreshman I
asked in Develop Integrations with Web Services | APIs
Filtering Data Retrieved Through API Call For Records Greater Than a Specified Date

I am trying to filter my API response to only make a get request of records from an endpoint of records that have to be greater than a specific date. I have tried to look at the documentation but unfortunately it does not contain any page on the documentation to give knowledge or show how this is done. When I add the filter parameters I get an error message as shown below : The error message is caused when I try to invoke the following endpoint also containing the filters required : {{endpoint_url}}ProjectBudget?$filter=LastModifiedDateTime_value gt datetimeoffset'11/10/2024 12:00:00 AM' ​​​​​​​The endpoint URL is the specific company URL required to access the endpoints of the specific company I require some assistance in being able to get past the error message so I can comfortably ingest data that is greater than a specified date. Will appreciate the assistance.

344
W
Freshman I
B
Freshman I
bala33Freshman I
asked in Develop Integrations with Web Services | APIs
Integration to Service Pro or Sales Force Field Service Solution and Acumatica Financials

Any one has used case of integration to either Service Pro or Sales Force Field Service and Acumatica Financials. Iam working on a prospect who is seeking this. If not these two solutions any Field Service Solution Integration will help. Please email me at bala@iccg.com Bala Anantharama ICCG, Inc.

100
B
Freshman I
J
Freshman II
jcard64Freshman II
asked in Develop Integrations with Web Services | APIs
InventoryID vs InventoryCD on custom DAC exposed to Web Service Endpoint.

I have a created a new SQL database table/DAC/Graph to collect some information that will be related to Stocked Items from an outside application. I have extended the Default web services endpoint to include this information. This all works well. My issue is that the custom DAC has a property for InventoryID but it expects an integer value which no one knows, they only know the item number. I have also added a property to the DAC for InventoryCD which is also exposed to the API, I can write to this just fine. Problem is that I can’t join this DAC to others in a GI since all the other DACs want to link on InventoryID. How do I merge these 2 into 1 so that the json payload can submit the InventoryCD and the DAC translate this and store the appropriate integer value. Here is the current DAC definition for these fields: #region InventoryID [PXDBInt()] [PXUIField(DisplayName = "Inventory ID")] public virtual int? InventoryID { get; set; } public abstract class inventoryID : PX.Data.BQL.BqlI

162
J
Freshman II
claudematherne24
Jr Varsity III
claudematherne24Jr Varsity III
asked in Develop Integrations with Web Services | APIs
API into Google Sheets

Hey there everyone, Is there a way to connect a Google sheet into an Acumatica screen to get real time data?

4816
S
Jr Varsity II
E
Jr Varsity II
eellistonJr Varsity II
asked in Develop Integrations with Web Services | APIs
Acumatica Performance Issues

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 blamed for

210
E
Jr Varsity II
K
Varsity I
keithschmVarsity I
asked in Develop Integrations with Web Services | APIs
ReverseInvoiceAndApplyToMemo via API

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"} }}

422
K
Varsity I
P
Jr Varsity II
PBSAJr Varsity II
asked in Develop Integrations with Web Services | APIs
Sales Quote Endpoint Action Error with Manual Numbering

Setup: Turn on manual numbering for Sales Quotes Make a web endpoint for Sales Quotes with OpportunityID and QuoteNbr mapped along with either of two mapped actions: PrimaryQuote or MarkAsConverted (QuoteEndpoint customization attached) Create an Opportunity Create two Quotes on that Opportunity When I attempt to mark the first quote as primary via POST request to /entity/Quote/0.1/SalesQuote/PrimaryQuote: { "entity": { "OpportunityID": { "value": "261044" }, "QuoteNbr": { "value": "261044R00" } }} I get this error response: { "message": "An error has occurred.", "exceptionMessage": "Object reference not set to an instance of an object.", "exceptionType": "System.NullReferenceException", "stackTrace": " at PX.Api.ContractBased.EntityService.Invoke(ISystemContract systemContract, String version, String name, EntityImpl entity, ActionImpl action, CbOperationContext operationContext, Boolean throwOnError)\r\n at PX.Api.ContractBased.AspNetCore.CbEndpointFeatureServiceExtensions.Invoke(IEn

532
P
Jr Varsity II
D
Freshman II
dominicfedcoFreshman II
asked in Develop Integrations with Web Services | APIs
Another process has added the 'ARRegister' record. Please try again.

I recently started encountering this error when using the /Payment API endpoint to create new payments or sometimes the /Payment/Release action: Another process has added the 'ARRegister' record. Please try again. My requests haven’t changed, so I assume it’s something server-side. Can anyone point me in the right direction for tracking down where the problem is coming from? Thank you!

391
jinin
Pro I
S
Jr Varsity I
stephenbologna39Jr Varsity I
asked in Develop Integrations with Web Services | APIs
Replacement for API Used by Report Designer

I am in the process of building an app to transfer reports between two Acumatica environments in batches using the Service Gate API. In reviewing the release notes for Acumatica 2024 R2, I see that the Service Gate API has been removed. Is there any documentation or resources that outline the new API that the 2024 R2 Report Designer tool uses to retrieve and save report data?

432
S
Jr Varsity I
J
Freshman I
jhenderson41Freshman I
asked in Develop Integrations with Web Services | APIs
SAP Ariba Interface

Has anyone integrated ACU billing to SAP Ariba?

471
S
Freshman I
T
Freshman I
trademarkFreshman I
asked in Develop Integrations with Web Services | APIs
API for 3PL

We are going live in 2025 with Acumatica. Any experience/advise how to use API to transmit our receving and shipping to our 3PL? Any suggestions who to contact at Acumatica? This is beyond me, but our 3PL is ready to go.

582
jo70
Freshman II

Go to

Discussion Forums
Financials
Distribution
Manufacturing
Construction
CRM
Field Service
Retail
Payroll
Professional Services
Low Code | No Code Customizations or Integrations
Develop Customizations
Develop Integrations with Web Services | APIs
Other Developer Topics
ISV Solutions
Configuration and Installation
Reports and Generic Inquires
Import and Export Scenarios
System Health and Performance
Community site discussions
Community Introductions
Everything Else
Technology Partners and Customers
News & Announcements

Tags

Most helpful members this week

Badge winners

Show all badges
Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved