Develop Integrations with Web Services | APIs

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

Is it possible to send a total premium freight price value when creating a sales order?Below is the request we are sending but it does not work {"CustomerID":{"value":"855215____"},"FinancialSettings":{"Branch":{"value":"LOCAL"}},"CustomerOrder":{"value":"10"},"Details":[{"InventoryID":{"value":"CC-W0930"},"OrderQty":{"value":1},"UnitPrice":{"value":166},"custom":{"Transactions":{"UsrAssembled":{"value":true},"UsrHingePlacement":{"value":"Right"},"ManualPrice":{"value":true}}}},{"InventoryID":{"value":"ASSEMBLE"},"OrderQty":{"value":1},"UnitPrice":{"value":16.6},"custom":{"Transactions":{"ManualPrice":{"value":true}}}},{"InventoryID":{"value":"CUSTOM-CABINET"},"OrderQty":{"value":1},"UnitPrice":{"value":67.33},"custom":{"Transactions":{"ManualPrice":{"value":true}}}}],"Totals":{"PremiumFreight":{"value":175},"OverrideFreightAmount":{"value":true}}}  

Hey everyone hope everything is good  I’m trying to get all results from GI using “PUT” Method but i get only 1 result instated of all results that i have    But here is my GI that i have in Acumatica  

I’m new to this forum so if this is the wrong board for this please point me in the right direction. We’re a pretty large company running Acumatica. We sell both wholesale and retail, both on our own websites as well as external marketplaces like Amazon, eBay, Walmart, Etc. We’re currently using Celigo to facilitate an API connection between Acumatica and these platforms to import orders, but we’re looking to export inventory from Acumatica to these platforms as well. Being that we currently have over 60,000 SKUs it’s impractical for us to export our entire inventory to these platforms, so we’re looking to set up a feed that only pulls inventory from items whose inventories have changed since the last update. We’ve hit a wall with Celigo because we can’t seem to access the LastModified field on StockItems>WarehouseDetails and Celigo can’t track changes without that timestamp. Has anyone set up such an inventory field for their businesses? We’re looking to set up inventory updates fo

Working on creating a Custom cc plug-in . However i cannot get the ICCHostedPaymentFormResponseParser to work . Does anyone have any ideas of how i can go about this?

this is the data going into the json body{"CuryOrigDocAmt":{"value":842.32},"CashAccount":{"value":"23110"},"Type":{"value":"Check"},"Vendor":{"value":"V01652"},"CurrencyID":{"value":"USD"},"Hold":{"value":false},"PaymentAmount":{"value":842.32},"PaymentMethod":{"value":"AM EX"},"Details":[{"CashAccount":{"value":null},"PostPeriod":{"value":"092023"},"BranchID":{"value":null},"InventoryID":{"value":null},"OrderQty":{"value":0},"WarehouseID":{"value":null},"AmountPaid":{"value":842.32},"Balance":{"value":842.32},"CashDiscountBalance":{"value":null},"DocType":{"value":"Bill"},"ReferenceNbr":{"value":"126781"}}],"PostPeriod":{"value":"092023"}} https://localhost//entity/Acumatica/1.0.0/CheckThis is the error return from Acumatica call on {"message":"An error has occurred.","exceptionMessage":"Operation failed","exceptionType":"PX.Data.PXInvalidOperationException","stackTrace":" at PX.Api.ContractBased.EntityService.Put(ISystemContract systemContract, String version, String name, EntityImp

Can anyone confirm if the INItemCostHist data is accessible via API? And if so, can you provide any resources regarding how to access it via API?

When I create an issue through the UI, it works. I try to do the same thing through the API, and I get the error noted in the subject. Here’s the full payload i PUT to /entity/Default/22.200.001/InventoryIssue this is only problematic when the stock item requires a lot number. I want to pass that & not able to through the API payload = { "Note": { "value": "test" }, "Details": [ { "InventoryID": { "value": "GEN-10127" }, "Note": { "value": "VO 109044, VOI 123872" }, "LotSerialNbr": { "value": "64980051405" }, "WarehouseID": { "value": "TP-NY" }, "Location": { "value": "TP-NY" }, "Qty": { "value": "1", }, "TranType": { "value": "Issue" }, "UnitPrice": { "value": 3.52 },

Dear all has anyone integrated whatsapp with acumatica. I am on version 2022r2.

I am working on building out a solution which utilizes the paymentconnector.html in Frames folder. I was wondering how I can access this frame and how I can create a new frame?

Hello everyone i am do integrating Invoice Rest Api in my system and i want to send addresses as well but unable to find any filter or keyword to expand addresses please help me in it