Develop Integrations with Web Services | APIs

Hi Community,I’m trying to add an appointment though PUT from Postman and I’m getting this error where it is saying that the “CustomerID: 'Customer' cannot be empty.; BillingBy: 'Billing By' cannot be empty.” but I have added these fields in the insert record. I’m not sure what this means am Imissing any fields or the query is wrong.This is an example with dummy data.Please let me know if i’m missing any steps Thanks in advance.

For some reason, I am required to pass the AttributeID when updating the value for a StockItem attribute. I’m using this URL:https://site.com/entity/Default/22.200.001/StockItem For example, when I want to update “Color”, I have to pass this in the JSON body    "Attributes": [        {            "AttributeID": {                "value": "A372"            },            "Value": {                "value": "Black"            }        }    ],Instead of finding all the IDs, I want to be able to just pass this:    "Attributes": [        {            "Attribute": {                "value": "Color"            },            "Value": {                "value": "Black"            }        }    ],Does anyone know how to do this?

HiI understand Acumatica.RESTClient package (CSharp) is not owned by Acumatica’s As we start to develop an integration projectit will be great if anyone has experience with it.Is it recommended ? Did you have issues while trying to implement some business ?maybe versions support and so ? Thanks a lot 

Hello Everyone,I'm having a recurring issue I've been facing while using the Acumatica REST API. I am attempting to delete a payment detail from a sales order, and intermittently, I receive the following error message: "'CustomerID' cannot be empty."The sales order already exists in the system so I shouldn’t need to provide the CustomerID but even if I do I still get the error.On top of this the error response from Acumatica contains the CustomerID populated as it should be.Here's a general structure of my API request for reference :{  "OrderNbr": {    "value": "000082"  },  "OrderType": {    "value": "SO"  },  "Payments": [    {      "id": "544535ce-2f8f-ee11-991e-90ccdfb7d7ce",      "delete": true    }  ]} As well as a portion of the response{  "id": "e6f8ec91-2b8f-ee11-991e-90ccdfb7d7ce",  "rowNumber": 1,  "note": {    "value": ""  },  "error": "'CustomerID' cannot be empty.; CustomerID: 'CustomerID' cannot be empty.",  ...  "CustomerID": {    "value": "2842011255"  },...

I am new to Acumatica so please forgive the simplicity of my question. I am trying to create a API request using a GI, but I cannot for the life of me find the GI inside the WS Endpoints. I have followed the process laid out in the training video for REST API’s, and unless I misunderstood using this GI is the proper way to do so. Accordingly I have verified that the ‘make visible on the UI’ and the ‘expose via Odata’ checkboxes are checked in the GI. The GI also seems to be working properly as when I view the inquiry I am getting the expected response. From my understanding when the expose via Odata is checked this creates a WS endpoint that is then used in the endpoint API. However when navigate the endpoints I cannot find this generic inquiry anywhere. I am testing all of this inside our sandbox instance, that wouldn’t be the issue would it? I assume not because I have made successful API calls of other endpoints to test inside of the sandbox instance. Am I missing something? Any dir

In our application we use the Authorization Code Flow.Our connected application runs multiples times a day and automatically uses the Refresh Token to receive new Access Tokens, but after 30 days, the Refresh Token is no longer accepted by Acumatica. The message returned by the server when sending the Refresh Token to get a new Access token is:"error":"invalid_grant"This logic would have been working for the previous 30 days. I see that in 2023 R2, on the SM303010 form, there is “Refresh Tokens” section and an option to configure the Refresh Token lifetime (Absolute, Infinite, Sliding). My question is, in 2023 R1 (and older), where SM303010 does not have the “Refresh Tokens” section, is there a lifetime “policy” implicitly in place for Refresh Tokens?If there was an implicit Refresh Token absolute lifetime of 30 days (could not be configured) then this would explain to me why our logic to exchange the Refresh Token for a new Access Token would stop  working after 30 days. But if the im

Previously, I was using SOAP to modify my user defined fields in a StockItem using the StockItemSummary object.  After switching to REST, I can’t even see these fields when I view the results of a GET operation using the following URL:https://url.com/entity/Default/22.200.001/StockItem?$filter=InventoryID eq 'XYZ-123456'&$expand=Attributes,ReplenishmentParametersIs there a different object that I need to add to my $expand list?

Hello,How are user credentials passed through an Odata connection in Visual Studio?  

Why is the datetime format, send in API responses, depending on system locale of sending server?Our polish developer gets a different format from his local instance.For example LastModifiedDate in Salesorder entity:‘11/27/2023 13:58:55’ instead of ‘2023-11-27T13:58:55+00:00’Is there a way to fix this to a fixed format?

Hi,Our users is asking us to Add “Uber Freight” as new Carrier plug-in. Do you have example/Documentation on how to implement that?

Hi, I added GeneratePaymentLink Action in Web Endpoint Services, so the problem is, in API it is always proceeding but in GUI there’s error: “Amount Due is Required”. How can I catch that error in Web Endpoint Services?

Hi Community.  I am writing an Excel VBA macro to chug through invoices and price books to update vendor costs and retail prices for stock items in Acumatica via the REST API.  If it finds an item on an invoice that is not currently in Acumatica, it can create it.  It sets the vendor costs and retail prices by calling VendorPricesInquiry and SalesPricesInquiry respectively (a sample of the former is given below).  All is working fine.  If the item already exists and I want to update the vendor cost, say, from an existing vendor, I kind of run into a problem, since that item already has a vendor cost for that vendor.  I have found a workaround by deleting the old cost and inserting a new cost.  Not pretty, but it works.  How exactly would I just do an update?  Also, I’m pretty new to REST API, so I haven’t been able to get a date to work (every time I try to include a date, my query fails).  I want to set the EffectiveDate to a specific date, when I update an item.  How do I do that?  I

I’m changing from using SOAP-based API to REST API.  Is there an equivalent to the IN209000Export and IN209000Submit?  I can’t find the web service endpoint that can either retrieve or add new Item Price Classes (ScreenId=IN209000)

I’m using this nuget in visual studio: https://github.com/Acumatica/AcumaticaRESTAPIClientForCSharp/Trying to set up a very basic bambooHR - Acumatica integration to create leave requests from bamboo as timeEntries in Acumatica.When I log in with just a username and password, everything works and it logs me into our live tenant. When I use my local offline demo vm I have no tenants to test with also.I want to log into our test tenant, but when I specify the test tenant and branch I get a Server error 500 - internal server error. Has anyone else run into this before? In my main program I have: myAcumaticaStuff.Login(AcumaticaBaseUrl, "ApiLogin", "******", "Staging", "Edmonton", "en-CA")The sub in the module:(myauthApi is from: Imports Acumatica.Auth.Api)Public Shared Sub Login(siteURL As String, username As String, password As String, Optional tenant As String = Nothing, Optional branch As String = Nothing, Optional locale As String = Nothing)            myauthApi = New AuthApi(siteURL)

Hey Guys, I wanted to check if its possible to create a custom plug-in type. I need to add UberFreight as another option but I can’t seem to find something on acumatica docs.Any insights would really be helpful. Thanks!

I am using REST Client to make API calls to default 20.200.001 endpoint. When I include Staff in my Select input I am getting an error. If I do not include “Staff/Description” in my Select, I get the results. using Acumatica.Default_20_200_001.Api;using Acumatica.RESTClient.Client;public async Task<List<Acumatica.Default_20_200_001.Model.Appointment>> GetAppointmentList(string token) { if (apiClient.Token == null) apiClient.Token = new Acumatica.Auth.Model.Token(); apiClient.Token.Access_token = token; apiClient.Token.Token_type = "Bearer"; AppointmentApi appointmentApi = new AppointmentApi(apiClient); string expand = "Staff"; string select = "ActualDuration,ActualEndDate,ActualEndTime,ActualHandleManually,ActualServiceDuration,ActualStartDate,ActualStartTime,AppointmentNbr,Description," + "Location,ScheduledDuration,ScheduledEndDate,ScheduledEndTime," + "Sc

I have a requirement to create a purchase receipt using Acumatica API.This is my code for that. RootObject obj = new RootObject(); obj.Type = "Receipt"; obj.VendorID = "GRI SL"; obj.VendorRef = "2131"; obj.Locatrion = "Main"; obj.ShipmentRef = "00028"; obj.Date = DateTime.ParseExact("10/10/2022", "dd/MM/yyyy",CultureInfo.InvariantCulture); obj.PostPeriod = DateTime.ParseExact("10/10/2022", "dd/MM/yyyy",CultureInfo.InvariantCulture); var jsonStrings = JsonConvert.SerializeObject(obj); PXTrace.WriteInformation(jsonStrings); var jsonString = JObject.Parse(jsonStrings); PXTrace.WriteInformation(jsonString.ToString()); var URL = "https://globalrubberindustrieslimited.acumatica.com/entity/CustomEndpoint/22.200.001/PurchaseReceipt"; var httpRequest = (HttpWebRequest)WebRequest.Create(URL); httpRequest.Method = "PUT"; httpRequest.ContentType = "application/json";

I have a customization project which includes a custom JSON object which i created.foreach (PXResult<POLine> result in polineview.Select()){ POLine line = result; if(order.OrderNbr == line.OrderNbr) { // Sample JSON object var sampleJsonObject = new { OrderNbr = order.OrderNbr, CustomerOrderNo = "CS0005", CusomterOrderLineField = new { PartNo = "P002", UnitCost = line.CuryUnitCost, InventoryID = line.InventoryID } }; string json = Newtonsoft.Json.JsonConvert.SerializeObject(sampleJsonObject); PXTrace.WriteInformation(json); } }JSON Data:{ "OrderNbr":"000453", "CustomerOrderNo":"CS0005", "CusomterOrderLineField":{ "PartNo":"P002", "UnitCost":367.640000, "InventoryID":18066 }}My API is http://testinstan

Hi Community!!I’m trying to fetch details of users for that I created a new Endpoint extension with name “AppUsers1”I have added 5 fieds for it but Username was showing a warning. as per the document I310 web services Tried ti fetch the data Using GET with Key Field Valuesbut I’m not sure which fields are Key Fields tried with Username but is not working. POSTMAN Get callHow can I find the Key fields is there a standard way or does that differ?Thank you in advance.

I was working on with the "Get" method in Acumatica API, I successfully pull the records from the api however there is no userID of the creator and modifier.Webservice Endpoints I tried to find the createdBy and ModifiedBy in the dropdown but there is none.how to add the UserID of creator and modifier on the web service endpoint so that these fields will be parts of the Get response.Thanks in Advance

Hi,I use the Resource Owner Password Credentials Flow to call the Acumatica API.as the 1st step I generate a token and using this token I call the API.My scope is api.I need to know after calling the api should I log out or close the session.

Hi Community.!!I've been successfully working on an app for Acumatica. I've managed to implement functionalities like logging in, logging out, and retrieving data using the API and endpoints.Now, I'm looking to implement the "forgot password" feature. In Acumatica, this involves sending a password reset link to the user via email, allowing them to reset their password.I'm wondering if it's possible to achieve this password reset functionality through API calls or webhooks and is there is any specific way we can trigger the emails? I've checked the available endpoints, but I haven't come across any related to this specific feature.Please let me know if there is any way to do that.Thanks in advance.

Hi Everyone  I’m having an issue updating a purchase Order in Acumatica by using Rest API, So my process is to create a purchase Order skeleton by enteringOrderNbrVendorOwnerDescriptionin the next step I add line items to that existing purchase Order  using OrderNbr (Not Auto-generated)  1 Step - Create Purchase Order PUT /purchaseOrder   2 Step - Add line items to the existing Purchase Order    "exceptionMessage": "Operation failed", "exceptionMessage": "Another process has added the 'POOrder' record. Your changes will be lost.",Request :{  "OrderNbr": {    "value": "PPO-00007"  },  "VendorID": {    "value": "VD000001"  },  "Description": {    "value": "DummyDescription"  },  "Date": {    "value": "2000-01-01"  },  "Location": {    "value": "DUMMYLOC"  },  "ShipToAddress": {    "AddressLine1": {      "value": "123 Dummy St"    },    "AddressLine2": {      "value": "Suite 100"    },    "City": {      "value": "Dummyville"    },    "Country": {      "value": "XX"    },    "PostalCode":

Hi Team,I have customized a screen to pull data from another System to Acumatica. I want to schedule the action button which is higlighted below. could you please let me know how I can do this.Nite: Need to schedule the action button to pull the data from another system to Acumatica.  Regards,Ramya

Hi Community,I have an issue with the Push Notifications it is not hitting in my local URL with Webhooks.I’m able to add a new Push notificaition and configure the URL with the https://webhook.site/ and it is working fine and getting the updated details as shown below when making changes in Manufacturer tab. Now I’m trying to do the same in my local in a ASP .NET Core Web API project I have written a small POST request and updated the URL in the Push notifications Tab, but every time I edit or add a new Manufacturer it is being listed in Process Push Notifications tab with an error message:“Send to target TestWebhook failed. Message: Send to web hook fails. Error: An error occurred while sending the request.” My local URL: https://localhost:7262/Manufacturer/PostManufacturerUpdate  Please let me know if I’m missing any steps or is there anyting wrong with my POST request or if there is any issue related to Webhooks so that I can resolve this issue.Thanks in advance.!!!