Develop Integrations with Web Services | APIs

Currently using 2023 R2 and will soon be updating to 2025 and I’d like to know if I can continue using endpoint version 22.200.001 or if an update will be needed. Where can I find the list of supported web service endpoint versions? Thank you!

Hi everyone,I’ve been trying to retrieve data via OData using a Generic Inquiry (GI) with a parameter, but I’m running into some issues.In my GI, I’ve defined a parameter named PPeriod and when I use it in the Acumatica web UI (for example, entering "092025" for 09-2025), everything works fine — I get the expected result with EndDate as 2025-02-02, along with the correct data for document FCV002141.  GI parameter GI result enddate with 09-2025 and FCV002141However, when I call the same GI via OData in Postman using the same parameter, I receive a 200 OK response but it completely ignores the parameter and returns bad data :  Postman Odata result , dont take in account the parameter If I try with REST API, it work, but i need the odata .. Here’s what I’ve confirmed so far: The parameter is correctly defined in the metadata as: <Function Name="AR_Documents_PeriodSensitive"> <Parameter Name="PPeriod" Type="Edm.String" /> <ReturnType Type="Collection(GenericInquiry.AR_Docume

Have made one Custom Endpoint under GI which is having User, Roles Entities added and we are able to fetch custom endpoint data using Odata in VMware Postman but want to publish this endpoint for all end-users with valid Acumatica credentials and same endpoint if can be configured in Java CodePOC DescriptionWe are working on a Hyper Scaler project POC and need to build an Acumatica Connector which should extract data from Cdata (serving as the data source) and synchronize it into some Data store. Additionally, it should retrieve detailed Access Control Lists (ACLs) from Cdata and perform ACL synchronization alongside the data sync to ensure least-privilege access for logged in use

I am creating a PO receipt through the REST API, and for lines that are sent to a different warehouse or location than the default, the quantities are doubled.  The client has separate virtual warehouses set up for damaged goods, if if received products are received to the damaged warehouse, the resulting quantity shown in the UI is always double the quantity that I sent in the HTTP body.  Anyone have any ideas what is causing this, and how to avoid it?Jim 

Hi allPerhaps a case of running before I’m walking here and quite probably missed some step in the docs/examples. So what I’ve done is develop a customization which I intend to build an extension library from. In this customization I created a report (This report is kind of like a Purchase Order).  Now what I want to do is to via a rest service call where I pass in a record id, download this report as a pdf.In the customization I think I’ve got the method sorted to generate the pdf document, but I can’t figure out how to wire up a service endpoint to trigger this method and return the pdf.  Are there any examples around I should be looking at?  Or advise on how to do this? 

Does anyone have experience creating an API to insert records from SQL Server into Acumatica? I’m currently working on building an integration that transfers data from a SQL Server database into Acumatica using the SOAP API, specifically for the Receivables module (Invoices and Memos screen). Any guidance or examples would be appreciated!Im stuck 😞 What i started using System;using System.Collections.Generic;using System.Data.SqlClient;using System.Linq;using System.Web.Services;using AcumaticaClientLib.AcumaticaDefault24;using AcumaticaInvoiceClientLib.Models;namespace AcumaticaInvoiceClientLib.Services{    public class InvoiceUploader    {        private readonly Screen _client;        private readonly string _connectionString;        public InvoiceUploader(Screen client, string sqlConnectionString)        {            _client = client;            _connectionString = sqlConnectionString;        }        public void UploadFromSql()        {            Console.WriteLine("🔄 Cleansing

We’re having the following issue:Everything appears to be set up on the Microsoft Entra side of things (permissions carry over) We are able to get a successful login notification on Acumatica (my profile → teams settings) BUT when we navigate to ‘Teams Channels’ we can’t synchronize. (see attached screenshot_Has anyone run into similar issues with Microsoft Teams integration? We’ve followed all the guides to the T and keep running into this issue.   

Hi everyone,I’m currently trying to create an AP Bill from a Purchase Receipt using an API (Postman), but I’m running into an error.Here are the details:Endpoint: POST {{BaseURL}}/entity/Default/23.200.001/PurchaseReceipt/CreateAPBill Request Body:{ "entity": { "id": "a256ce42-5b3b-f011-837f-0eddcec71d29" }} Response from Postman:{ "message": "An error has occurred.", "exceptionMessage": "Operation failed", "exceptionType": "PX.Data.PXInvalidOperationException", "stackTrace": " at PX.Api.ContractBased.EntityService.Invoke(ISystemContract systemContract, String version, String name, EntityImpl entity, ActionImpl action, CbOperationContext operationContext, Boolean throwOnError)\r\n at PX.Api.ContractBased.AspNetCore.CbEndpointFeatureServiceExtensions.Invoke(IEntityService entityService, ICbEndpointFeature feature, EntityImpl entity, ActionImpl action, CbOperationContext operationContext)\r\n at PX.Api.ContractBased.WebApi.Controllers.ActionController.InvokeA

I ran into this collection of Postman REST API examples today for Acumatica that contains examples from the Help site's integration guide:  REST API Request Examples for PostmanEnjoy!

Hi everyone,We would like to automate the creation of Physical Count (IN504000) documents (Type ID: DAILY, Warehouse: K300) at 2AM every day in Acumatica.What’s the best approach to implement this? Should we use a custom processing graph with automation schedule, or is there a simpler method?Thank you in advance! 

We’re trying to create Project time activities via API endpoint   The endpoint is custom, mapped to the Employee Time Activities screen, EP307000.If you try and set the Earning Type to anything other than the default, the system clears the “Project Task” field, and the create/update operation fails.  This can be seen in the UI… if you change the Earning Type column in the grid, the Project Task column is unexpectedly cleared.  In the UI, you can fix it before saving.  With the API, you can’t. Does anybody know a workaround for this apparent bug?

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

I’ve extended the Stock Item entity and added Related Items to the entity.  I can successfully add new related items to the stock item as well as query the item and get the related items attached to it, but I can’t seem to remove a related item once it has been added other than using the web interface and manually removing it.The URL being accessed via PUT ishttps://MyTenant/entity/MyCustomEndpoint/1.100.001/StockItemJSON being sent is{ "InventoryID":{"value":"601-0669"}, "RelatedItems": [ { "LineID":null, "Delete":{"value":true}, "ID":{"value":"d6fdf2bf-565b-f011-8427-120e4ffdb993"} } ]}I’ve tried providing the ID as well as the LineID, but get the same error: "The request is invalid: An exception occurred during input parsing"I’m using the exact same method to add/remove vendor details, attributes, etc. on stock items, but just can’t seem to get it to work with related items.Anyone have any suggestions on how to accomplish this? 

Hello,I am using contract based rest api. I was looking for the endpoint which can help me to fetch updated inventory changes nearly on real time based scenario, where I can pass updated date filter. So, can you please suggest which entity or endpoint would work better for this?And also looking for the endpoint where I can update stock quantity.Please look into the issue.Thank you

A midsize company we use slack for easy communication and notification.  Has anyone tried to integrate slack with acumatica task for notification? We have not been able to get acumatica task notification working properly, maybe something we don’t have turned on via our settings but I think we would like to move to slack notification.   Thank you in advance for any suggestion, help. Jose 

For example if I were to create a shipment for UPS Express or Two Day Air, the return label would be UPS ground regardless? Is this something that is possible to do?

Is it possible to rename a web service endpoint without recreating it?I attempted to export the endpoint in a customization, modify the name in the XML, and upload the customization, but the customization screen errors on upload with “Error during file upload: Object reference not set to an instance of an object.” Any suggestions?

Hi everyone,I'm currently setting up Authorize.Net sandbox integration in Acumatica (on a local demo environment), and I’m encountering the following error when testing credentials:AR Error: Credit card processing error. Processing Center Error: Exception: E00007: User authentication failed due to invalid authentication values. I followed the setup steps for the Authorize.Net API Plug-in under Processing Centers:All the values were copied directly from the API Credentials & Keys section in my Authorize.Net sandbox account (see screenshots below for reference).I lack any procedural steps or errors in the configuration ? Any guidance would be greatly appreciated!Thanks in advance

Hello,we are trying to send our first oder via API and the salesOrder endpint to acumatica\haufe x360.We are using the following JSON fileWe receive the following error response: 422Unprocessable Entity[...] I have tried to send the CustomerID in the CustomerID field and also the customer's internal UUID. I always get this error message.Does anyone have any idea what I am doing wrong with my request?Thanks in advance!Steffi#team aurebus

Filtering Activity by TimeActivity/Status ‘Released’ does not work. Specifically the released status does not work. It does work if I use the short form RL instead of Released. Filtering with TimeActivity/Status OPEN works as expected.http://52.168.110.150/AcumaticaNew/entity/Default/23.200.001/Activity?$select=TimeActivity/Status&$filter=TimeActivity/Status+eq+'Open'&$expand=TimeActivityThis works for both $filter=TimeActivity/Status+eq+'Open’ and $filter=TimeActivity/Status+eq+'OP’.The same goes for status Completed (CD) Based on the request profiler, Completed and Open are both translated to the short form prior to query execution. However, ‘Released’ is shortened to ‘Re’ instead of ‘RL’. Is there a way to get this to work, or at least identify the columns that are of type ENUM specifically status type enums so that we can normalize this client side? The swagger response reports the field as string which is incorrect if we need to normalize the enum display/internal value.

Using the REST API I need to know which is the first record (chronologically) of JournalTransaction. That is, the one with the eldest CreatedDateTime.How can I get that? What's the default ordering of that collection? Can I do something like sort + top=1?

Hello,I am beginning to get into Power Automate and see there is a Connector available for the Acumatica API.  Are we able to update a UDF on a Sales Order using a Flow?  Our need is we have a spreadsheet with tracking information and we also have a UDF for the tracking number.  Hoping there is a way to automatically add the information from the spreadsheet instead of manual import scenarios.  Thanks-

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? 

Hello,I am using a restful api to get invoice as described by the documentation using Resource owner password flow. after generated a token I made a call to api to get invoiceUrl + "Invoice?filter=ReferenceNbr eq 'XXXXXX'&$filter=ReferenceNbr eq 'XXXXXX'"after 2 successful attempt to get invoice when I try to get invoice for the third time I get errorAPI Login LimitI tried to logout after each request, but the logout request getting 204 no matter what I passed in the authorization. so not sure if logout is working with me. using var client = new HttpClient();var request = new HttpRequestMessage(HttpMethod.Post, configuration["SignoutUrl"]);request.Headers.Add("Accept", "*/*");string authInfo = configuration["UserName"] + ":" + configuration["Password"];authInfo = Convert.ToBase64String(Encoding.Default.GetBytes(authInfo));request.Headers.Add("Authorization", "Basic " + authInfo);var response = await client.SendAsync(request);response.EnsureSuccessStatusCode();how to get unlimited c

Hello, We have a client that’s having issues with Subaccount in the AccountSummaryInquiry, no matter what we try the field is always blank.Is there a query string we need to send so Subaccount is populated? They’re using the Default schema so I don’t think they’ve done anything custom with it.