Skip to main content

Community
Discussion Forums
Develop Integrations with Web Services | APIs

Develop Integrations with Web Services | APIs

Technical discussions focused on Web Services and APIs for developers

671 Topics
2,715 Replies

When you subscribe we will email you when there is a new topic in this category

671 Topics

Recently active

Most replies Most views Newest first

jlongidmFreshman I

asked in Develop Integrations with Web Services | APIs

Outbound API Calls

Hello Community!I’m researching a way to send an API call FROM Acumatica TO a third-party endpoint. I’ve read through the I310 course document and I’m not seeing what I’m looking for.Example flow: User clicks a button on a screen, API call goes out, data is returned to the screen.Could anyone please point me in the direction of the right documentation or any resource that could assist?Few quick notes:We are on 2024 R1 Build 24.108.0034Our tenant is hosted in the cloud (I do not have back-end access)I’m familiar with API and Postman, just not how to send from Acumatica Thank you,Justin Long

asked in Develop Integrations with Web Services | APIs

How do I mark a project task as COMPLETE?

I have a project with two tasks on it. Both tasks are active. I am using REST API to mark the task as complete. I keep getting an error that says “The Complete Button is disabled”This message is misleading as the button is very much enabled on the UI.Please see screenshots. Call from PostmanComplete button on task.

AndrewMuzalovJr Varsity III

asked in Develop Integrations with Web Services | APIs

AP Bill Payment REST API

I’m trying to create AP Bill Payment by REST APII found that I can do it with “Check”, but it doesn’t work for me - may somebody have experiance with AP Payments and can say what I’m doing wrong.One of my API requests: PUT http://***/entity/Default/20.200.001/Check HTTP/1.1Accept: application/jsonUser-Agent: OpenAPI-Generator/1.0.0/csharpContent-Type: application/json{"ApplicationDate":{"value":"2024-09-08T00:00:00"},"CashAccount":{"value":"10011"},"Description":{"value":"Test"},"Details":[{"AmountPaid":{"value":15.0},"DocType":{"value":"Bill"},"ReferenceNbr":{"value":"TEST002"}}],"PaymentAmount":{"value":15.0},"PaymentMethod":{"value":"CHECK"},"PaymentRef":{"value":"Test001"},"Type":{"value":"Payment"},"Vendor":{"value":"V100"}}All my attemts finish with an error like: “exceptionMessage=The system failed to commit the Adjustments row.”

ryanmiterFreshman I

asked in Develop Integrations with Web Services | APIs

Error when trying to create a time activity via API

As part of our integration, we push time activities for the customer from our system into Acumatica. We currently are hitting this error for one specific customer, and are unclear as to how to fix it. Other customers do not run into this, so I’m wondering if it is something to do with the customer’s specific setup? Inserting 'Time Activity' record raised at least one error. Please review the errors. Employee: Employee 'E00001' cannot be found in the system. ProjectID: Project '5360' cannot be found in the system. Please verify whether you have proper access rights to this object. ProjectTaskID: Project Task 'T160LB' cannot be found in the system. I’ll note that we cannot view the “Employee Time Activities” screen on Acumatica with the user we have used to connect Acumatica to our application. Also, I’ve confirmed that the Employee ID, Project ID and Project Task ID all exist in Acumatica.

EvervilleFreshman I

asked in Develop Integrations with Web Services | APIs

The system failed to commit the Adjustments row.

I am trying to create a payment and apply it to a select Invoice. When I attempt it, I get the error message “The system failed to commit the Adjustments row.” Would love it if someone could help point out what I’m missing here. Below is a slightly edited version of the JSON request body...{ "ApplicationDate": { "value": "2021-01-16T00:00:00.000+05:00" }, "ApplicationHistory": [], "AppliedToDocuments": { "value": "73.07" }, "CardAccountNbr": { "value": "8888" }, "CashAccount": { "value": "" }, "CreditCardProcessingInfo": [], "CurrencyID": { "value": "USD" }, "CustomerID": { "value": "7656TSGDB" }, "Description": { "value": "" }, "DocumentsToApply": [ { "AmountPaid": { "value": "73.07" }, "BalanceWriteOff": { "value": null }, "CustomerOrder": { "value": "" }, "Description": { "value": "" }, "DocType

bpgravesVarsity I

asked in Develop Integrations with Web Services | APIs

REST API: how do create the General, Billing, and Shipping tab data for a Customer?

For General: SOAP has GeneralPrimaryContact, GeneralAccountInfo, GeneralAccountAddress, GeneralAccountInfoPhoneType1, GeneralAdditionalAccountInfoPhone1Type, GeneralAdditionalAccountInfoExtRefNbrFor Billing: SOAP has BillingBillToInfo, BillingBillToAddressFor Shipping: SOAP has ShippingShipToInfo, ShippingShipToAddressWhere are these in REST? Do I need to $expand something to have access? What are the names?Also, what the difference between a MainContact and PrimaryContact?

dominicfedcoFreshman I

asked in Develop Integrations with Web Services | APIs

Blanket Sales Order: how to create child orders via API?

How is it possible to invoke the “Create Child Orders” action using the REST API?

WillHJr Varsity I

asked in Develop Integrations with Web Services | APIs

When did the Perfromance guidance in I320 for list Sales orders with details & shipments change from make 2 requests to make 1 request?

Hi Acumatica community,This is more for my personal interest/because I like to understand things. I figured a long time developer might know. In-between when I initially sat I320 and when I’m redoing it now, the guidance in the course changed.The new guidance is to send 1 request, with a double expand if you’re retrieving records from. So I have 2 questions:When did the guidance change? Why did the guidance change? (Technical perspective) I spend a fair amount of time explaining reasons for choices to implementers/developers, and while I’ll certainly follow I320 it helps to understand why the guidance changed. Screenshot of i320 Question: Suppose you need to retrieve detail lines & shipment lines of multiple sales orders.

bpgravesVarsity I

asked in Develop Integrations with Web Services | APIs

REST API: how do I find a customer by email address?

I've tried this GET method but I just get an invalid type cast error:https://sandbox.com/entity/Default/22.200.001/Customer?$expand=PrimaryContact&$filter=PrimaryContact.Email eq 'kylelauridsen86@gmail.com'

jhenderson41Freshman I

asked in Develop Integrations with Web Services | APIs

SAP Ariba Interface

Has anyone integrated ACU billing to SAP Ariba?

sclassingFreshman I

asked in Develop Integrations with Web Services | APIs

Using OData v4 to return INItemLotSerialKvExt for a given SOShipment

I have an SOShipment object and we store a value in INItemLotSerialKvExt. We need to access the data via OData v4 and would like to get the value in a single call when accessing the SOShipment. Essentially, for every SOShipLineSplit on the shipment, we want to get the INItemLotSerial → INItemLotSerialKvExt Logically, it seems I could get this data like this: SOShipment → SOShipLineSplit → INItemLotSerial → INItemLotSerialKvExt. But those navigation properties do not seem to exist in the OData schema. Instead, the best I’ve been able to find is the following: SOShipment → SOShipLineSplit → INLotSerialStatusByCostCenter → INItemLotSerial → INItemLotSerialKvExt. This seems a round about way of getting the value. Here are the pertinent schema nodes for the links above: <EntityType Name="SOShipLineSplit"> <NavigationProperty Name="INLotSerialStatusByCostCenterByLocationID" Type="PX.Objects.IN.INLotSerialStatusByCostCenter"> <Re

ebenrouxFreshman II

asked in Develop Integrations with Web Services | APIs

Creating TimeEntry via API

I have this call:###PUT {{url}}/entity/Default/22.200.001/TimeEntryAuthorization: Bearer {{authToken}}Content-Type: application/json { "Summary" : {"value" : "Time entry summary"}, "Date" : {"value" : "2024-08-29T09:00:00" }, "Employee" : {"value" : "EMP001" }, "ProjectID" : {"value" : "CA.1001" }, "ProjectTaskID" : {"value" : "ANNUAL PAID" }, "EarningType" : {"value" : "VL" }, "TimeSpent" : {"value" : "08:00" }} The response comes back with an error (shortened):{ "id": "5fd70d80-0b66-ef11-96a7-00155dc9a206", "rowNumber": 1, "note": { "value": "" }, "error": "Inserting 'Time Activity' record raised at least one error. Please review the errors.",…"Employee": { "value": "EMP001", "error": "Employee 'EMP001' cannot be found in the system." }, Now, ‘EMP001’ definitely exists and is ‘Active”. I have even tried add the user to the “Administrator” role, but I still get the error. Any ideas would be appreciated.

ebenrouxFreshman II

asked in Develop Integrations with Web Services | APIs

Managing users via the REST API

I have successfully created an employee using the REST API, but I need to link that to a user. However, I do not seem to find any documentation, or API, related to managing users. Is what I’m trying to do possible using the API, or would an Admin need to use the portal to configure the relationship (Linked Entity)?

pjamesFreshman II

asked in Develop Integrations with Web Services | APIs

Need to create UOM Conversions on Non-Stock Items via API / can't find object.

Hello again! I have a question relating to the automatic creation of item codes through the API. Along with the item codes themselves, I have a need to populate the unit of measure conversions (for example Cartons to LBS or Pallets with the conversion factors. The problem I am facing is, the UOMConversions class is not available in the Non-Stock Items object. It IS available on Stock Items, but we are not using those. We had a consulting group build out the initial system and they created a customization project to get us to where we can apparently have the UOM conversions on Non-Stock Items (as shown in this screenshot), however I am unable to contact them and need to figure out how to create those entries on the non-stock items via the API myself (along with help from here if possible).Here’s a shot of the Non-Stock Items in the customization project showing the fields I need access to: I just don’t know how to gain access to those fields via the class objects. I found a class objec

DavidModFreshman II

asked in Develop Integrations with Web Services | APIs

REST API Requests Timing Out On Sandbox

We set up a REST API integration with our Acumatica account using Zapier and it works fine. We then tried connecting it to our sandbox account as well and it stopped working after a day. The error is that the connection timed out. We cannot connect from Zapier or web based Postman. Interestingly, we can connect from Postman desktop. The version on our sandbox account is 2022 R1.Is there some sort of setting on the sandbox that is blocking the requests?

bpgravesVarsity I

asked in Develop Integrations with Web Services | APIs

REST API: how do I attach a payment to an order and return the unpaid balance?

Currently, I doing this PUT method but it doesn’t do anything but return the sales order object:https://sandbox.com/AcumaticaERP/entity/Default/22.200.001/SalesOrder?$expand=Payments&$select=Payments/AppliedToOrder:{ "OrderType": {"value": "WB"}, "OrderNbr": {"value": "WB00159383"}, "Payments": [ { "ReferenceNbr": { "value": "598095" } } ] }I’m expecting it to return the unpaid balance on the order so I can use this amount to call the same method with the following body:{ "OrderType": {"value": "WB"}, "OrderNbr": {"value": "WB00159383"}, "Payments": [ { "ReferenceNbr": { "value": "787266" }, "AppliedToOrder": { "value": 55.5900 } } ] }

IvanVarsity I

asked in Develop Integrations with Web Services | APIs

"More than one entity satisfies the condition" Error during uploading attachment

Hi, I used such request for uploading attachments to Acumatica for Billshttps://mycloud.acumatica.com/entity/ARTSDocEndpoint/23.200.001/bill/inv/096178/files/105908469_2024-07-29.pdfIt worked for all environments, but suddenly I started received such error {"message":"An error has occurred.","exceptionMessage":"More than one entity satisfies the condition.","exceptionType":"PX.Api.ContractBased.MoreThanOneEntitySatisfiesTheConditionException","stackTrace":" at PX.Api.ContractBased.EntityService.GetImpl(ISystemContract systemContract, String version, String name, EntityImpl entity, PXGraph screenGraph, EntityDescriptor entityDescriptor, CbOperationContext operationContext)\r\n at PX.Api.ContractBased.EntityService.DetermineEntityDescriptor(ISystemContract systemContract, String version, String name, EntityImpl entity, EntityExportContextBuilder entityExportContextBuilder, EntityDescriptor& entityDescriptor, PXGraph graph, CbOperationContext operationContext, Boolean& isArchi

dsenevirathne54Jr Varsity II

asked in Develop Integrations with Web Services | APIs

Expiration of Authentiocation Token

Hi ,I have set up Google Workspace for email in Acumatica. I’m required to log in several times a day, otherwise emails sharing getting failed. I noticed that there is an expiry set on the Authentication token under the external applications. How can I extend this expiration or set this not to expire?Thank You,Dulanjana

bpgravesVarsity I

asked in Develop Integrations with Web Services | APIs

REST API: how do I Record CC payment previously done in SOAP

Here’s what I’m doing now in SOAP to Record a CC payment: var pymtSchema = _context.AR302000GetSchema(); _context.AR302000Clear(); var commands = new List<Command>(); try { _context.AR302000Clear(); commands.Clear(); commands.Add(new Value { Value = "Payment", LinkedCommand = pymtSchema.PaymentSummary.Type }); commands.Add(new Value { Value = paymentRefNbr, LinkedCommand = pymtSchema.PaymentSummary.ReferenceNbr }); commands.Add(new Value { Value = bt_transactiontoken, LinkedCommand = pymtSchema.PaymentSummary.PaymentRef }); commands.Add(new Value { Value = bt_transactiontoken, LinkedCommand = pymtSchema.RecordCCPaymentCCPaymentData.PCTranNumber }); commands.Add(new Value { Value = "OK", LinkedCommand = pymtSchema.PaymentSummary.ServiceCommands.DialogAnswer, Commit = true }); commands.Add(pymtSchema.Actions.R

bpgravesVarsity I

asked in Develop Integrations with Web Services | APIs

REST API: why does retrieving a Sales Price row (AR202000 screen) take so long using HttpClient?

Since converting from SOAP, I’ve run into C# issues related specifically to the Sales Price (AR202000) page. For instance, when using a PUT method to create a brand new Sales Price row, I need to use a CancellationToken to timeout after 5 seconds. Otherwise, I need to wait 5+ minutes to get a response back (InnerException: Error while copying content to a stream). This is very strange since there is no wait time at all using Postman. This isn’t my biggest concern since I’ve worked around it with the timeout/cancellation.My biggest problem occurs when using a PUT method just to retrieve a Sales Price row (using InventoryID/PriceType/PriceCode). This can take anywhere between 1 second to 5 minutes just to retrieve a response. I need to do this to retrieve the RecordID, which is a new REST requirement for deleting specific SalePrice rows. I don’t receive any response errors like I do trying to create the Sales Price row. This is drastically increasing the processing time compared

bpgravesVarsity I

asked in Develop Integrations with Web Services | APIs

REST API: using a popup window after a Payment Action is invoked

Here’s the URL I tried with a POST method in Postman:https://sandbox.com/AcumaticaERP/entity/Default/22.200.001/Payment/ActionName Question: is there a way to pass a value to the popup window that is display when the Action is invoked? maybe I also need to pass something so it can submit this value?I tried to add the popup box field name but it’s not working...{ "entity": { "Type": { "value": "Payment" }, "ReferenceNbr": { "value": "598035" }, "PopupFieldName": {"value": "abc12345xyz"} }, "parameters": {}}

kkrausFreshman I

asked in Develop Integrations with Web Services | APIs

Guide to setting up PX.FedExRestCarrier.FedExRestCarrier Integrated Shipping?

I’m trying to setup integrating FedEx, and I’ve been trying to setup the RestCarrier setting. All of the guides I’ve seen are just for PX.FedExCarrier.FedExCarrier, and don’t work for PX.FedExRestCarrier.FedExRestCarrier.

orlandonegron43Varsity I

asked in Develop Integrations with Web Services | APIs

Acumatica API inserting country in customer

Good day,I want to create a customer through Acumatica Web service endpoint, and I get this error:"error": "Inserting 'Address' record raised at least one error. Please review the errors.; CountryID: 'Country' cannot be empty.",Country is required to create the customer, so I have the field added in the web service endpoint and I have tried using CountryID or Country, but it gives the error.Any suggestions?{ "CustomerID":{"value":"TESTCUSTOMER"}, "CustomerName":{"value":"Test Customer"}, "SendDunningLettersbyEmail":{"value":false}, "SendInvoicesbyEmail":{"value":false}, "SendStatementsbyEmail":{"value":false}, "Address":{ "AddressLine1": {"value": "123 Main St"}, "City": {"value": "Random city"}, "Country": {"value": "US"}, "State": {"value": "CA"}, "PostalCode": {"value": "00000"} }, "Attributes": [ { "AttributeID": { "value": "ARCONTACT" }, "Required": { "value": true }, "Value": { "value": "Cash" } } ]}

ebenrouxFreshman II

asked in Develop Integrations with Web Services | APIs

You have insufficient rights to access the TimeEntry (PM209100) form.

I’m trying to invoke the following: GET {{url}}/entity/Default/22.200.001/TimeEntry?$filter=cf.DateTime(f='Items.Date')%20ge%20datetimeoffset'2024-08-01'%20and%20cf.DateTime(f='Items.Date')%20le%20datetimeoffset'2024-08-16'&$select=Date,ProjectID,TimeSpent,BillableTime,EmployeeAuthorization: Bearer {{token}}Accept: application/json However, I receive the following error:{ "message": "You have insufficient rights to access the TimeEntry (PM209100) form." } When I add my user to the “Administrator” role it works fine, but I prefer using a custom role.Which permissions do I need to add to the role to make this work?I’ve tried adding all “Time and Expenses”, “Projects”, as well as “Project Management” permissions to no avail.

pmblakeFreshman II

asked in Develop Integrations with Web Services | APIs

Trigger Action Using REST API

Hi all, I have a custom action on my Sales Order screen which sends an email to the customer of a selected order. Currently we are manually clicking this button for each order. Is there a way to access these actions via REST API given the Order Nbr? Or alternatively is there a way to “Add Email” to an order via REST API? Thanks!

1
2
3
4
...
27

Page 1 / 27

Badge winners

vineela95has earned the badge Easy talker
hyadav08has earned the badge Easy talker
dcomerfordhas earned the badge Manufacturing expert
courtneybhas earned the badge Easy talker
nhatnghetinhhas earned the badge Low Code | No Code Customizations or Integrations

Show all badges

Powered by Gainsight

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

Social Login

Login with your Acumatica account

Login to the community

Social Login

Login with your Acumatica account

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK