Develop Integrations with Web Services | APIs

We are using C# with Swagger definition to access a Web Service EndpointWe are attempting to perform a filter on the SalesOrderClient GetListAsync and would like to perform a substringof filter on the OrderNbr field to find any orders that contain the value that has been specified. SalesOrderClient soClient = new SalesOrderClient(httpClient);soClient.BaseUrl = "http://localhost/Acumatica_DEV/entity/Test/20.200.001";select = "OrderNbr, OrderType, Status, CustomerID, Details/LineNbr, Details/InventoryID, Details/OpenQty";if (!string.IsNullOrWhiteSpace(e.RequestData.OrderNumber))    filter = "substringof(OrderNbr.Value, '" + e.RequestData.OrderNumber + "')";else    filter = "OrderType eq 'SO' and Status eq 'Open'";IEnumerable<SalesOrder> salesOrders = await soClient.GetListAsync(select, filter, "details", "", null, null);foreach (SalesOrder salesOrder in salesOrders){    // Process Results} When we execute the search the error returned isUnable to cast object of type 'System.String'

Hi I need to create Open Invoices for adding them Payments and Application. I just need to create 20 invoices in order to add 20 rows for payment in order to test data generation As I understood only Open Invoices could be added to “Document to Apply” tab and only with same Customer So, how to make Invoice status “Open”  ?If you know more fast way to generate 20 rows for “Document To Apply” tab for payment than creating 20 Invoices individually, I will be very grateful 

I  am trying to update the Shipment line detail with Screen Based SOAP API service.The code is  executed but respective record not updated.Following is the code snippet var commandList = new List<Command>();                                             commandList.Add(new Key                {                    ObjectName = SO302000.Result.DocumentDetails.LineNbr.ObjectName,                    FieldName = SO302000.Result.DocumentDetails.LineNbr.FieldName,                    Value = LineNbr.Trim(),                    Commit = true                });                commandList.Add(new Key                {                    ObjectName = SO302000.Result.DocumentDetails.ShipmentNbr.ObjectName,                    FieldName = SO302000.Result.DocumentDetails.ShipmentNbr.FieldName,                    Value = acushipmentNbr.Trim(),                    Commit = true                });                commandList.Add(new Value { Value = shipmentLines.ShippedQty.ToString(), LinkedCommand = SO30

Can i get Inventory fetch API for EDI Integration

How to access all API for EDI Integration ?

The IN Operator is a very commonly used function in SQL to subselect items based on a list of values. it is extremely useful, for example, if you were trying to synchronize a data set from an external system with data inside Acumatica/SQL Server. The Acumatica development blog acknowledged this usefulness in its example code when it announced the availability of the IN Operator: SQL In Operator in BQL - Acumatica Developers BlogWhat it glosses over is that there is no way to use this operator with a Select2 query, which means there is no way to use it with a PXProjection for doing advanced data views in Acumatica. This requirement is not documented anywhere, except for the faint mention that it must be used with the Required<> property. The consequences of only being available with the Required property is that it must be used with a PXSelect type query, but cannot be used with a Select2 type of query. Select2 query style is required for any kind of PXProjection in the system. PX

 Hi,The aim of this case is to identify how to form REST request properly in order to create Bill with status "Balanced"Our client is using our application, which creates requests and put data to Acumatica. Client asked if we can  create invoices with status "Balanced". I checked such request with our Test Acumatica environment and it was easy to implement. My request successfully worked and created Bill in Acumatica with status "Balanced" However, when we do same request with client's Acumatica we get this error :  "exceptionMessage": "Bill.CashDiscountDate: 'Cash Discount Date' cannot be empty.\nBill.DueDate: 'Due Date' cannot be empty.\nBill.LocationID: 'Location' cannot be empty.\nBill.Terms: 'Terms' cannot be empty.\nBill.Vendor: 'Vendor' cannot be empty.\nBill.VendorRef: 'Vendor Ref.' cannot be empty.\nInserting I searched and found that this error is caused by this fieldWhen I removed it from the request it successfully worked.My question is : what is the possible difference bet

I am working on upgrading our Acumatica instance from 2019R1 to 2021R1.  A substantial part of my project involves updating a set of service layer applications that enable bidirectional communication between our ecommerce site and Acumatica.  Our web site runs on a platform that does not have an available integration for Acumatica.  The site interacts with Authorize.net for all credit card transactions.  I’ll spare everyone the long explanation for why I need to unmask the Payment Profile ID (CCPID) in the API.  The TLDR; is “our web site’s integration with Authorize.net could be better”.  Most of what I need to accomplish involves not creating duplicate payment methods in Acumatica because of web orders.With our customized v18 API endpoint in 2019 R1 my code could load a customer’s payment method list to access the temporary ID for that payment method.  A second request was sent to load a single payment method using the temporary ID with the payment method details expanded.  That woul

I’m attempting to configure Microsoft Azure for Integration with Acumatica ERP instance by following these instructions:https://help-2021r2.acumatica.com/(W(7))/Help?ScreenId=ShowWiki&pageid=6b852c66-01c4-40b5-af7d-c53d7e4bd672 In Step 4, I’m required to specify the application ID URI of our Acumatica instance. Supposedly I’m supposed to find the application ID URI in the Web.Config file. But I can’t find this Web.Config file - where would I find this or is there an alternative way to find the application ID URI? J

Hello Team,Could you clarify, is it possible to receive deleted customers from Acumatica via API?If yes, which endpoint (screen) it is necessary to use?I opened Web Services Endpoints and didn’t find here the necessary endpoint.Thank you!

  This may be a simple question, but I am not having any luck finding the information I need online or in the documentation.  I am trying to use OData V4 to get information from the Branch screen, and I am trying to locate the default address information.  When I try to follow the example from the training material (I300 Data Retrieval with OData 2021 R2), it tells me for the AR Customer to expand using "AddressByDefAddressID".  I tried this for the PX_Objects_GL_Branch entity and I get an error saying "The query specified in the URI is not valid. Could not find a property named 'AddressByDefAddressID' on type 'PX.Objects.GL.Branch'.".  My question is, where can I go in Acumatica, or in the documentation to find what is available for each entity?  ------------------------------(I300 Data Retrieval with OData 2021 R2)------------------------------------------The PX.Objects.AR.Customer entity contains common information about a customer. TheContactByDefBillContactID navigation property o

Background:I have an Acumatica instance installed that has two Tenants. Tenant ID 2 is the actual company data, and Tenant ID 3 is test company data. I have API Web Service started that has access to AR301000(created only in Tenant 2). I have an admin user, with system admin rights on both Tenants. I just change the login information to switch tenants. admin@actual or admin@test. Im doing this via a C# app, and using a SoapScreenClient. My goal is to create an Invoice, and add a couple lines items in the DocumentDetails section.Issue:Calling .AR301000GetSchema() in Tenant 3 will show DocumentDetails.ServiceCommands as NULL, and therefore I can’t access the .NewRow Command. By only changing my login info to Tenant 2, the .AR301000GetSchema() will allow me to access the ServiceCommands, and call .NewRow and add my line items. The two tenants are setup nearly identical, and manually logging into the web interface, I can complete this task as expected.Side Note.This issue of this .ServiceC

Is there any glossary of complete customer object fields? I’m using SOAP API and some of the fields aren’t coming with the getSchema object and I have to find them by searching through Acumatica question/answers but I don’t know where they are listed properly?? So far I found:LastModifiedDateTimeCreatedDateTimeNow looking for Branch and Company IDs but don’t know the exact field names.. any help?

Hello, Our push notifications are part of our customization project, and we publish our customization project to all three of our tenants to keep them in sync. When we do this, the push notification URL is set to the same value for all three tenants, whereas we need each tenant to use its own specific push notification URL. Is it possible for the push notification URL to be dynamic? We’d like each tenant to use different  push notification URL depending on the CompanyId of the tenant.Thank you, Dave

Hello, We are integrating with the Acumatica SAAS product via the REST API by means of lambda functions. This is working fine in general. However, we find that after a period of inactivity, the response to an API request takes much longer than usual. The lambda function is configured with an execution time of 15 seconds, and it often stops executing before the response is received. An Acumatica support rep once mentioned that this could be due to "cache expiration", but we can't find any documentation about this. Is it possible to configure the cache expiration time, or something similar that would help us solve this problem?Thank you,Dave

Hi Is it any possible way to logout the instance based on the branch using REST API?

Dear Experts,We are facing a peculiar issue that I wanted your input with.  We have a few non-stock items with a price-sheet in Acumatica. We also built an external integration via REST APIs to create an invoice in Acumatica from an external system. The pricing is different in Acumatica’s price sheet vs External System for one particular Invoice Item, say PRODUCT_X. Since we don’t want Acumatica to calculate it’s own list price when the price comes from External System, we tried to set the UnitPrice, ListPrice, ExtPrice and Amount fields through the API. Acumatica accepts all of them except for ListPrice. It always sets the ListPrice to be the price that Acumatica calculates through the Sales Price Sheet. Do you know if this a known behavior? I am still able to edit the List Price from the UI, but it’s just that I am not able to set it via API. Thanks again for your valuable input, as always!

Hello, In the Request Profiler, I can identify the requests made by our API user because the username is displayed. There are often other requests where the username field is blank, and I’m not sure what that means. What does a blank username field mean?Thanks, Dave

Hi, when we create our Sales Order using the API, we encountered this issue Response 422  Unprocessable EntityWe rarely encountered this issue, and we don’t know why it happens. In our request body, we are sure that we have the Status field.  For additional record, I have used the same request body a moment ago and the Sales Order is created but after trying now, the error shows up.Any help would be helpful. Thanks a lot  

Hi Everyone ,We have  below requirement , can anyone suggest best possible way to achieve it please?Added a new field in Payment and Application header level   Should display the above custom field value in Bank Deposit Document level grid Thanks in advance.

I have extended a Web service End Point to include the results using instructions from https://www.acumatica.com/blog/contract-based-apis-in-generic-inquiries/. and Am using a GI as a data source with Celigo (integrator.io).  The problem I’m running into is it breaks down the GI into pages and with my  $Skip formula to chunk the data into pages. I think its because all the data is in the Detail item “Result” and it sees everything as 1 big record.  I think this because to read the results correctly I had to point the resource path to “Result”   I’m at a loss here on how to fix the issue but I’m not an expert so maybe someone here has dealt with this and can help! Thanks in advance, Greg

I created a custom Import Scenario that uses the Employee screen. It essentially calls a custom Action I created. The action performs no redirection; it merely creates a new PREmployee record.The configuration is below: When I try to run this in an “Import by Scenario”, I receive an error: Error: x items have not been processed successfully. View name: Employee. No errors appear next to the individual items. Furthermore, the action performs as expected; the PREmployee record is created.Why might this error be appearing and how might I troubleshoot?

We have encountered an issue with the Project API in 2021R1.The validation is on the size of the "Account Email" field in the Project API Model (presumably the email address of the Customer related to the Project). There seems to be some new validation on the length of the field.Does anyone know the size limit for the field?

We are carrying out an integration to export sales records from Acumatica Sales Order Screen into external system via third-party API, what is the best way to carry out this integration?What is the best way to send Acumatica sales data to this external API and also sales data must be sent hourly. Currently thinking of using Contract-based REST API method in Acumatica. Please let me know the right solution to go ahead with this requirement or any documents present. 

Is there any documentation on how to connect these endpoints in API push?