Develop Integrations with Web Services | APIs

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. 

The API I’m trying to use:Custom API, Entity representing the “Employee” screen (EP203000), an Action mapped to the “GenerateTimeCards” action.The Request I’m using:A “POST request using this JSON:{ "entity": { "EmployeeID": { "value": "A real employee ID" } }, "parameters": {}}The Error:HTTP 500, with the words “PX.Data.PXInvalidOperationException” in the stack trace.The Question:If I try to use this action from the UI, I am indeed presented with a dialog box.  I’d love to be able to figure out a way to tell the API to accept the dialog box with no changes, like I just clicked “OK” in the UI. I can’t seem to find any reference to this on the internet.  Does anybody know if this is even possible?  Thanks if you can help!

As described in the blog post below, I’m exposing a Generic Inquiry (GI) to be retrieved by an external system via the REST API. We are using OAuth2 authentication with grant_type=password and scope=api.As shown in the blog post, I’m sending a PUT request to Acumatica with a {} in the request body.https://www.acumatica.com/blog/contract-based-apis-in-generic-inquiries/ Could you please clarify whether it is necessary to call a logout after performing the PUT request?     

Hello - Does anyone have an idea why I cannot Void a bank rec. It is grayed out on all recs. I am an admin as well. We cleared a bank item that should have not been cleared vs another one. Therefore one remains open, but should have been cleared. I am assuming this is the solution to void the rec, then recreate them from the issue date. Thanks  

I can get a GI with a single parameter to work with OData 4 using the following URL structure: https://[instance]/t/[tenant]/api/OData/MyGI_WithParameters(Param1='value1')However, when I try a GI that takes multiple parameters, I either get 403 or 404 errors.  Here is the Metadata for each parameter as reported by OData <Function Name="AI-CustomerGI">                <Parameter Name="CustomerIDGT" Type="Edm.String" />                <Parameter Name="DateGT" Type="Edm.DateTimeOffset" />                <Parameter Name="Employee" Type="Edm.String" />                <Parameter Name="FilterByClass" Type="Edm.Boolean" />                <Parameter Name="FilterByState" Type="Edm.Boolean" />                <Parameter Name="FilterBySalesperson" Type="Edm.Boolean" />                <ReturnType Type="Collection(GenericInquiry.AICustomerGI)" Nullable="false" />            </Function>CustomerIDGT is a starting customer numberDateGT is a starting d

Hi everyone,Has anyone successfully completed an adobe sign integration to Acumatica? I’m having issues finding the API from the clients Admin Adobe account.  Thanks in advance.