Skip to main content

Develop Integrations with Web Services | APIs

Technical discussions focused on Web Services and APIs for developers

  • 799 Topics
  • 3,169 Replies
799 Topics
asommer
Jr Varsity III
asommerJr Varsity III
asked in Develop Integrations with Web Services | APIs
Create ARInvoice from Webhook

Good day, I’m working on a webhook for integration with a third party. The webhook runs find until I try to create an ARInvoice and add an ARTran to the InvoiceEntry. The error I’m getting is in the SM_ARInvoiceEntry.cs file IsLineCreatedFromAppSO method. The base.Base.Accessinfo.ScreenID is null. We have a separate integration using a custom screen with a custom Action, but using webhooks will be much better for our purposes. Is there a way I can set the ScreenID from a webhook in order to create the ARInvoice with ARTran items? Here is the webhook code: namespace EcrsWebhook{ public class EcrsWebhookHandler : PXGraph<ARInvoiceEntry>, IWebhookHandler { private static readonly Newtonsoft.Json.JsonSerializer Serializer = new JsonSerializer(); decimal INFRA_DISCOUNT = (decimal)0.15; public async Task HandleAsync(WebhookContext context, CancellationToken cancellation) { ECRSConfigs MAXIO_KEY; using (JsonTextReader reader = new JsonTextReader(context.Request.CreateTextReader())) { // Creat

6013
Marco Villasenor
Jr Varsity II
N
Freshman I
nikhils20Freshman I
asked in Develop Integrations with Web Services | APIs
REST API for: To put instance in Maintenance Mode

I am trying to put my instance in Maintenance mode via REST API, as we are publishing Customization Projects VIA REST APIs, but cannot find anything on how to put instance in Lockout or Maintenance Mode ..

663
harutyungevorgyan
Jr Varsity I
I
Varsity I
IvanVarsity I
asked in Develop Integrations with Web Services | APIs
Last supported Acumatica version ?

Hi, What is last Acumatica supported version? Second moment, which I need to clarify, how to find out which endpoint version corresponds to Acumatica version ? Does any endpoint version can be imported for any Acumatica version or there are some rules and logic, which must be followed for correct work ?

9296
T
Freshman I
jessicapruitt
Freshman I
jessicapruittFreshman I
asked in Develop Integrations with Web Services | APIs
How do we resolve Price List sync error?

Last Read Message: The NONMEMBER price list could not be exported because at least one item in it does not exist in the BigCommerce store. Synchronize all the items in the price list, and then process the price list again. We have 4 Price Lists, and all are reading the same error. Price Lists: PREMIER, NONMEMBER, PRACTICON, WHOLESALE We have no sync errors on the finished products. The only thing I can think of, is new products not yet ready to be installed in BigCommerce are on the Price Lists, so that may be stopping it. Is anyone familiar with this?

224
jessicapruitt
Freshman I
T
Freshman I
travisk91Freshman I
asked in Develop Integrations with Web Services | APIs
Acumatica Webhooks Fail to make AP or AR invoices

I've built out an Acumatica Webhooks project. I've successfully got it reading the incoming POST, and figuring out what to what to do. So far I can successfully insert Customers, Customer Locations and Projects without an issue. Honestly, from someone who does a fair amount of integration work, this is basically magic. These integrations are as close to real-time as is practical, so amazing work Acumatica. That said, using nearly the same code, I'm trying to insert AP or AR Invoices and I get bizarre or meaningless errors. I’ve stripped that code down to the most basic version, and when running the code that lives in the webhooks dll from a button on a graph it works exactly as expected. When it runs within the webhooks environment itself I get weird errors. For what it’s worth I’m running in 22R2, but I moved the code over to 23r1 and I get the same issues. My case in “in engineering review” so I thought I’d field it here to see if anyone has thoughts on what it is about the AR/AP gra

1053
rimamanaseryan16
Freshman I
jessicapruitt
Freshman I
jessicapruittFreshman I
asked in Develop Integrations with Web Services | APIs
How to write an expression for Export Mapping of Stock and Template products?

I need to write a custom expression to map Brand from ERP to BigCommerce BrandID. it is custom since BigCommerce’s interval is a number and the ERP is a text format. We have a Substitution List designed to map the BrandID to the Brand Name too. The brand is located in Attributes, but I think it may need to be changed to Advanced for a customized expression. For the Substitution Lists, BCBrands is the name of the list. If anyone can point me in the direction for learning how to write the expressions too that would be great. I work in web development, so the expressions look familiar to JavaScript variable syntax.

80
jessicapruitt
Freshman I
M
Freshman I
Mikemedved21Freshman I
asked in Develop Integrations with Web Services | APIs
Customize Time Entry to Save Notes

Given the issue with the Time Entry Webservice and form, can a user implement in interim fix by customizing the form, or building a new web service endpoint. Our deployment won’t be able to upgrade to 2025R1 in the near future. Thank you Pushing Notes for time activities, and auto completing time activities when creating | Community

302
M
Freshman I
E
Jr Varsity II
eellistonJr Varsity II
asked in Develop Integrations with Web Services | APIs
Unable to set the PrimaryContact on the BusinessAccount entity via RestAPI

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/PHDCustome

100
E
Jr Varsity II
F
Freshman I
FatgalahTimothyFreshman I
asked in Develop Integrations with Web Services | APIs
Upgrading SalesOrder API from 18.200.100 to 20.200.100

I have an api that pushes salesorders and it works if I set the version to 18.200.001. When I move it to 20.200.001 it fails with the error [message] => An error has occurred. [exceptionMessage] => Sequence contains no matching element [exceptionType] => System.InvalidOperationException [stackTrace] => at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source, Func`2 predicate) at PX.Api.ContractBased.EntityExportContextBuilder.ExtractFieldMappingKeyForDetail(String mappingKey, EntityField field, EntityMappingProjection[] entityFields, IMetadataProvider metadataProvider, IEntityMappingKeyService entityMappingKeyService, String endpointName, String version) in C:\build\code_repo\NetTools\PX.Api.ContractBased\EntityExportContextBuilder.cs:line 1343 The only information I can find about changes is on page 55 of https://www.acumatica.com/media/2020/09/AcumaticaERP_IntegrationDevelopmentGuide.pd Where it says‘• The type of the Payments field is changed. • Mapping has changed‘ After I g

182
F
Freshman I
A
Freshman I
AxsysInvestFreshman I
asked in Develop Integrations with Web Services | APIs
Create PO linked to SO from PO505000 via API

Hi All, I’m trying to generate Demand PO’s linked to SO’s from the PO505000 screen but am finding it will only generate a PO for one line item at a time, rather than the multiple items available for Purchase from the one supplier or multiple suppliers. I’ve created a Custom Endpoint via Web Services linked to the screen, added the ProcessAll button as an Action with OrderNbr and OrderType as parameters: I call via HTTP using Postman and the below Body: I get a 202 back saying its successful. What seems straight forward and works in the GUI with the above filter options, will only ever generate one PO for the first line, no matter how many lines there may be meeting the criteria. Not sure what I’m missing and this seems like a process many people would want to use via API?? Is there something required in the Entity that I am missing?? Any help appreciated :-)

232
A
Freshman I
P
pemith30
asked in Develop Integrations with Web Services | APIs
SMS gateway integration with Acumatica

Has anyone done an SMS gateway integration with Acumatica ? Can you integrate any Bank’s SMS gateway as long as they have the right APIs ?

80
P
R
Freshman I
ryanmiterFreshman I
asked in Develop Integrations with Web Services | APIs
Pushing Notes for time activities, and auto completing time activities when creating

Hi everyone. I’m trying to pass a “notes” field in when creating or updating Employee Time Activities. Below is an example of my request: PUT "/entity/Default/22.200.001/TimeEntry" { "note": "Some notes", "BillableTime": { "value": "01:00" }, "Date": { "value": "2024-02-16T06:00:00-08:00" }, "Summary": { "value": "Hours from Timesheet" }, "EarningType": { "value": "RG" }, "Employee": { "value": "EP00000002" }, "LaborItem": { "value": "CONSULTSR" }, "ProjectID": { "value": "X" }, "TimeSpent": { "value": "01:30" } } The Time Activity gets created, but the notes do not get passed through. Also, I’m trying to run the CompleteTimeEntry action on the PUT "/entity/Default/22.200.001/TimeEntry", but I always get the “Invalid uri structure” error even though I have this as a mapped action: Any ideas what’s happening?

11410
M
Freshman I
G
Freshman I
geoffatsourceFreshman I
asked in Develop Integrations with Web Services | APIs
Purchase Order API: Bug when placing a PO on Hold

When I attempt to release a purchase order from hold via the API, sometimes I get the following error: Operation failed: At least one line is not present in the cost budget of the project. Either add the corresponding budget lines to the project or select the Allow Adding New Items on the Fly check box on the Summary tab of the Projects (PM301000) form I get the same error when try to do so from the user interface: Oddly, if I try a second time, either via a repeating the API request, or by pressing the button again, the error does not occur. What could be going on?

232
A
Jr Varsity I
M
Freshman II
mvinesFreshman II
asked in Develop Integrations with Web Services | APIs
Add Default Salesperson to Customer using API

I am adding customers with the ERP api. Part of this process is assigning the default salesperson to the customer. For things like the MainContact/Address, I can just $extend the customer entity being saved, but this does not seem to work for Salespersons, How do I attach a default salesperson to a customer with the api? PUT /20.200.001/Customer?$expand=Salespersons,MainContact/Address {..."Salespersons": [ { "SalespersonID": {"value": "SALEPERID"}, "Default": {"value": true} } ]...} This will result in 200 OK, but no Salespersons will be assigned to the customer. {..."Salespersons": []...} What do I need to do to get this salesperson assigned to the customer?

353
jinin
Pro I
S
Freshman II
shuangFreshman II
asked in Develop Integrations with Web Services | APIs
Acumatica OAuth: Per-Tenant Client Credentials Required for multi-tenant Integration?

Hello Acumatica Developer Community, I'm currently working on implementing an integration with Acumatica and have a question about the best approach for handling multi-tenant authentication. Authentication Challenge For OAuth authentication, we need to store and manage client ID and client secret credentials. Since Acumatica supports multiple tenants, I'm wondering about the best practice for handling authentication in this context. For multi-tenant support, we need to determine if Acumatica requires separate client credentials per tenant: Does each tenant instance require unique client ID/secret pairs in Acumatica, or can a single set of credentials work across multiple tenant instances with the same base domain? Thank you!

191
Samvel Petrosov
Jr Varsity II
G
Freshman I
geoffatsourceFreshman I
asked in Develop Integrations with Web Services | APIs
Purchase Order, adding a Detail changes an existing detail unit cost

I have a Purchase Order with three line-items (Details). I create the PO and there’s no problem, but when I do to add a Detail, it randomly updates a different Detail. The new detail has no id (because it is new) and has a LineNbr of -1. Here is the PO details when I first create it: Here is the payload which I PUT to the PurchaseOrder endpoint { "id": "bdb7e18e-5300-f011-8368-065d7e32b4d5", "Details": [ { "AlternateID": { "value": "8b974d0f-5f8a-b586-5e1a-a3d3900830ed" }, "Account": { "value": "Accounts Payable (A/P)" }, "BranchID": { "value": "SOURCE" }, "OrderNbr": { "value": "24-TST2-024" }, "InventoryID": { "value": "OTHER" }, "LineType": { "value": "Service" }, "LineNbr": { "value": -1 }, "LineDescription": { "value": "Measure & Install Trip" }, "UOM": { "value": "EACH" }, "OrderQty": { "value": 1 }, "UnitCost": { "value": 3500 }, "ExtendedCost": { "value": 3500 }, "Description": { "value": "COGS Contra - Fees" }, "Project": { "value": "24-TST2" }, "ProjectTask": { "value": "PURC

795
RohitRattan88
Acumatica Moderator
M
mjjoachim
asked in Develop Integrations with Web Services | APIs
REST API Not Returning Error for an Invalid Account on Bill Detail

I am using the Acumatica REST API to create vendor bills. I am using the "Default" endpoint, version 24.200.001. I see the same behavior in older versions of the API too. When I submit a bill with an invalid account number on a bill detail line, the vendor's default expense account is used and no error is returned unless there is also an error with another field. The bill is successfully created and the response code is 200. Other bill detail line fields do not behave this way. For example, if I pass an invalid value for the Branch or Subaccount fields the bill is not created and the response code is 422. If I submit invalid values for both Account and Subaccount, the call fails but only the error for the invalid Subaccount value is returned. If I submit invalid values for both the Vendor field at the header level and Account the bill is not created. The response code is 422 and the body indicates both that the vendor could not be found and that the account could not be found: { "id":

170
M
K
Freshman I
kkrausFreshman I
asked in Develop Integrations with Web Services | APIs
How to Extend Endpoints to an older version?

We’re trying to connect Acumatica to Power Automate, however, the program requires version 17.200.001. I’ve been trying to extend the default endpoint to 17.200.001, however, whenever I do, I get the error: “Versions of the contract for a system endpoint cannot be created. Create a custom endpoint and give its contract another name.” However, if I try to name the extension something else, it just doesn’t create anything. Is there a way to access Power Automate this way?

303
Yuriy Zaletskyy
Jr Varsity I
N
Freshman II
nickacfieldFreshman II
asked in Develop Integrations with Web Services | APIs
Get Unbilled Quantity per line in a POReceipt via API

Hi, I am needing to get the Unbilled Quantity left on a Receipt.I can only get the total of all lines, but not the breakdown. Is there a way to do this? /entity/Default/22.200.001/PurchaseReceipt/?$expand=Details&$filter=VendorID eq 'V000000001' and ReceiptNbr eq '000092' here is my API Call URL. I have expanded details. there is nothing in custom etc

323
N
Freshman II
N
Freshman II
nickacfieldFreshman II
asked in Develop Integrations with Web Services | APIs
GET PurchaseReceipt Can i filter api response by any containing Details/POOrderNbr = ' certain value'

Hi, How can i GET PurchaseReceipt - List of Lines that are for a certain PO number?I cannot seem to filter by expanded objects. Otherwise to get all Receipt Lines against a certain PO I will need to dig out all receip[ts for a supplier and loop through all returned lines to get my filtered list. here is my API call returning a 500 - "The parent value for a property access of a property 'POOrderNbr' is not a single value. Property access can only be applied to a single value.", /entity/Default/22.200.001/PurchaseReceipt/?$expand=Details&$filter=VendorID eq 'V000000001' and Details/POOrderNbr eq '000018' or is there a way to query ReceiptLines seperately?

767
N
Freshman II
G
Freshman I
geoffatsourceFreshman I
asked in Develop Integrations with Web Services | APIs
Reopen a Purchase Order via the default API?

Is there a way to reopen a purchase order that was set to “completed” via the API? I have some tests that are cancelling line items and some of the POs are being closed automatically and I can’t delete them when I run my cleanup script.

4910
G
Freshman I
G
Jr Varsity III
grillevanJr Varsity III
asked in Develop Integrations with Web Services | APIs
Acumatica - Avalara Integration; Is it set up to pass Latitude/Longitude to calculate Sales Tax

Good day, Avalara has the ability to calculate sales tax by entering the Latitude/Longitude manually. My question is does the Acumatica - Avalara integration set up to pass this information from the Project Address tab. Some of our projects have a state/city/ postal code but not actually address just a location on a pipeline. I have seen any documents or announcements. Thank you

272
G
Jr Varsity III
jinin
Pro I
jininPro I
asked in Develop Integrations with Web Services | APIs
Unable to make Customer Contact as primary except for the First record through API call

Hello Everyone, I am trying to make a customer contact as primary through API call. But it is working for the first entered contact. Unable to set another contact. Could you please review and share your feedback?

3008
abrunner78
Jr Varsity III
B
Freshman I
BEXJensFreshman I
asked in Develop Integrations with Web Services | APIs
Get ID of ERP system from push notification

Hi folks, i’m looking for an possibility to identify the system that sent a push-notification. The notification body looks like that: { "Inserted": [ { .... } ], "Deleted": [], "Query": "<my_query>", "CompanyId": "<my_company>", "Id": "8d6d670d-86e0-477f-a8cc-343b578ba3dd", "TimeStamp": 638775642732888022, "AdditionalInfo": { "PXPerformanceInfoStartTime": "03/14/2025 15:51:12" }} However, if i receive push notifications from different systems (different domains) i can’t figure out which system sent the notification. I only have the company id but I don’t think that the companyid is unique. Does anyone know how to solve this problem? Thanks in advance.

152
B
Freshman I
H
Semi-Pro II
HarrySemi-Pro II
asked in Develop Integrations with Web Services | APIs
Login Syntax for OData

Hello community, I have been trying to use a GET method to login to my Acumatica instance using Postman, but it displays 404 error or sometimes 401 unauthorized error. i have created a user account and have given the account as Admin & Access to OData roles. I have been using the following syntax in the postman: https://site URL/AcumaticaERP/OData Is this the correct syntax that I have been using? If yes then why I am facing the issue? Thanks in advance.

70515
R
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