Develop Integrations with Web Services | APIs

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

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)

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? 

I'm trying to download JournalTransaction data. I'm following the documentation to Retrieve the List of Records in Batches, using the $top and $skip parameters. I've tried different values for those.But I can see that as the $skip parameter grows each request take increasingly longer to finish.Finally, after ~1 hour of processing, it fails with a ReadTimeout. Even if I retry, after 60 secs or more, it keeps failing with ReadTimeout. It is not a session expiration issue: I tried with logout/login.Besides it is not consistent. For example with a $size of 500 it typically fails on $skip=115500. But sometimes I get up to the next page ($skip=116000) until it fails.And I can't get over that.Any ideas?

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 " +

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="Collectio

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.

I’m trying to delete a value from an attribute.  I’m trying by sending the attribute with the value needing to be deleted with the “delete” flag set to true.  I’m getting back no error message at all, with a status of OK, but the value is not being deleted.I can manually delete the value via the GUI, but the REST API will not delete it.The JSON object being sent to the AttributeDefinition endpoint:{"AttributeID":{"value":"DKWHLWIDTH"},"Values":[{"ValueID":{"value":"3-3/4"},"delete":true}]}Any suggestions?

I work in a furniture business and looking at ways to reduce manual entry of Sales Orders. We have many small sized customers who do not have advance tech ability and often send their order either as a PDF attachment or in the body of an Email.  They are not too interested in EDI.  I’m looking for a system can read these PDF/emails as they are the same format each time and automatically import and create a SO.  Currently only found Artsyl but I’d like to review a few.Does anyone use a system like this already?  I am very interested in you experiences and suggestions.Thanks

Hello,I'm working with the Acumatica API to create time entries for the **Employee Time Activities** screen (EP307000) using the **TimeEntry** endpoint. The UI displays a **WorkGroup** field for each activity, but I cannot find this field in the API contract, even after attempting to extend the endpoint.There is only Items objact in the list, and there is no WorkGroupID in the list. I checked fields with selector - the same situation - field unavailableHere are the details:- Acumatica Version: 2025-1 - API Endpoint: `TimeEntry`- Issue: The `WorkGroupID` field is visible on the **Employee Time Activities** screen but is not available in the `TimeEntry` API pa

I’m getting the following error when I try to create a Sales Order:Document cannot be saved. Document number (<NEW>) equals to the New Number Symbol of a Numbering Sequence. Please change document number.This doesn’t make sense since I want the system to set the Sales Order Nbr so I need to use <NEW> for the Order Nbr.  Is this a configuration issue?

Hi everyone, I’m just getting started with the Acumatica REST API and have successfully set up a GET request to the Employee endpoint, which returns a list of employees. However, I noticed that the BAccountID field, which is linked via DefContactID, is not included in the response. I’d like to know if it’s possible to add this BAccountID field to the Employee endpoint, and if so, what’s the correct way to do it—should I use the Customization Project Editor, or is it something that needs to be handled in code? Thanks in advance for your help!

HiI want to add a segment value using apiI added the screen, and I am able to pull exiting data. I now want to add a value on the segment value  

Hi all,My objective is to connect my java client with the SignalR Hub.I added a push-notification with Destination Type SignalR Hub as it is described here: Push Notifications: To Connect to the SignalR Hub.I use the following code snippet to connect my client with the SignalR Hub:String login = "<my_user>"; String tenant = "<my_tenant>"; String password = "<my_password>"; String basicAuthPlain = login + "@" + tenant + ":" + password; String encodedBasicAuth = Base64.getEncoder().encodeToString(basicAuthPlain.getBytes()); HubConnection hubConnection = HubConnectionBuilder.create("https://<my_x360_domain>/PushNotificationsHub") .withHeader("Authorization", "Basic " +

For some reason our RefreshToken is always expiring after 24 hours. Regardless of what we set in Connected Applications settings. We are using Resource Owner Password Credentials and RefreshToken is set to Absolute expiration 30 days. Our Acumatica version is: 2024R1 and installed locally. Any help is much appreciated

hi!we have a prospect who’s current POS system is lightspeed POS and they are looking to make the switch to acumatica.  I was wondering if anyone else has any clients who use lightspeed pos and was able to successfully integrate with acumatica. I would love to hear your experience and what challenges you faced.  

We are trying to create an integration with Acumatica API and we are encountering issues or weird behavior when updating multiple items in a parent record.For example when we try to update multiple contacts for a customer, it won't update the all contacts but only update the first one, but the weird thing is it picks up the values from the second item to update the first item, like the contact note field of second item will replace the contact note field of the first item, we are not sure if its bug or something.Anyone experience the same issues?Here is my sample Json payload for a Customer PutEntity endpoint, the note for ContactID: 100745 will replace the note for ContactID: 100743, but will not touch the second item.Seems like only first Contact gets updated.{ "id": "01a0c017-df7f-ea11-8175-b9d61cb73193", "Contacts": [ { "note": { "value": "Note for 100743" }, "C

Hi All,I am trying to set up a push notification to a Google Space webhook. I get an error that the format is incorrect - the error is generated from Google. Google does not like the format of the JSON that is sent.Does anyone know how to customize the JSON?