Develop Integrations with Web Services | APIs

There seems to be a bug with the Set as Primary button on an Opportunity.Here are the steps to produce:Create an Opportunity Create a Project Quote. Ensure you set its Opportunity ID to be the Opportunity ID of the Opportunity we created in step 1 Create another Project Quote and also set its Opportunity ID to be the Opportunity ID of the Opportunity we created in step 1 Use some mechanism to fetch both project quotes, I just use Postman. Note their LastModifiedDateTime’s… Click the Set as Primary button on the Opportunity for the Project Quote that is not presently the Primary one (we specifically choose this Project Quote as this is a data change and should -- at least, in theory -- update the LastModifiedDateTime of the Project Quotes) Repeat step 4. Note both of their LastModifiedDateTimes remain unchanged.Is this a known bug or planned to be fixed? Our company uses the LastModifiedDateTimes for DB syncs and this is a major problem for us. I’m aware of workarounds and plan to addre

Hi, Executing the InventoryAdjustment in Postman I get the following known error:"error": "Inserting  'IN Transaction' record raised at least one error. Please review the errors."And in the details:"LotSerialNbr": {                "value": "--MFP73565",                "error": "Lot/Serial Nbr. '--MFP73565' cannot be found in the system."            },Creating the InventoryAdjustment using the RestClient also gives an error, but it only gives me this error “Inserting  'IN Transaction' record raised at least one error. Please review the errors." when catching an ApiException. If I check the ErrorContent it is null. How can I get the same result in the RestClient as in Postman where it returns the Lot/Serial Nbr error?I am using version 4.1.0 of the RestClient client nuget package in c#.

We set up a REST API integration with our Acumatica account using Zapier and it works fine. We then tried connecting it to our sandbox account as well and it stopped working after a day. The error is that the connection timed out. We cannot connect from Zapier or web based Postman. Interestingly, we can connect from Postman desktop. The version on our sandbox account is 2022 R1.Is there some sort of setting on the sandbox that is blocking the requests?

I have created a move transaction using moveentry in the manufacturing endpoint. The transaction is still open, I need to update the amount produced and update some of the attributes with additional information. When I send json through postman, I receive the response below.  The error states that “Line 2 of Move Transaction  requires Attribute ADDLSCRP”, the attributes are being sent in the proper order. Request:{ "BatchNbr": { "value": "MI000623" }, "Details": [ { "TransactionAttributes" : [ { "rowNumber": 1, "AttributeID": { "value": "OPER2" }, "Value" : { "value" : "2" } }, { "AttributeID": { "value": "ADDLSCRP" }, "Value" : { "value" : "8" }

I am trying to follow the examples for the screen based soap api services, I am able to generate the wsdland insert it in the console app but I have no Screen Class, I cannot do apitest.Screen context = new apitest.Screen();I am using VS2022 and there are no errors, but I cannot find this Screen class,What am I missing?

Trying to ship with FedEx, however, when ever we refresh rates, we get the error “Object reference not set to an instance of an object". Any idea what could be causing it and how to fix it?

Which web service end point should I access in order to do a Move transaction?Move Entry seems to be incorrect? 

Hello, I’ve been trying to expose the Access RIghts of a Role by extending the Web Service Endpoint and adding the Access Rights by Role (SM201025) Screen ID to an endpoint named “AccessRightsByRole”. I’ve populated the fields n AccessRightsByRole with the Role Information mapped object. As you can see I’ve inserted a new field named AccessRights which should hold the detail of 0 to many Access RIghts, which is an object mapped from RoleEntities. Following the Acumatica Universities Advanced Data Retrieval with REST API 2024 R2 instructional video (19:39), I expected to see these Access Rights expanded for a role that was queried.Example: GET {baseUrl}/AccessRightsByRole/Administrator?$expand=AccessRightsNo matter which role I query, the AccessRights field is always an empty array. {    "id": "{some GUID}",    "rowNumber": 1,    "note": null,    "AccessRights": [],    "RoleDescription": {        "value": "{some role description}"    },    "RoleName": {        "value": "{some role name}

Hi Community team, Is there any API available to Validate Bill Entry “json data”?We would like to validate Bill entry data before call to create bill api entity/Default/xx.200.001/Bill.  

Hi All, I wanted to know how to retrieve as much information as possible for a stock item.  At the moment I am using the StockItem end point, but it only returns the QtyonHand which is only partially useful. When I go to Inventory Summary I see the following fields.   This is great because I can see the full picture of the item’s allocation. I can also see if the Item is already on a PO.  Unfortunately this screen does not tell me which PO’s the item is on.  The Inventory Allocation Details screen will tell me PO’s the order is on.  The goal here is that when orders come in a quick way to analyze if we have the part in stock.  If we dont what is the ETA.Are there other end points besides stockitem that will get me more of this information for an inventory item?  

We are using the nuget package Acumatica.RESTClient.ODataApi version 4.1.0.  We are trying to call a generic inquiry via OData v3 using ODataApi.GetOData().  However, the $orderby parameter is not listed as a parameter for this method.The method includes the following parameters:select, filter, expand, skip, and top - but not $orderby.Is there a way to make an OData v3 call using an $orderby parameter?

I have been trying to send a token via API Key Authorization method but I've been getting an unauthorized error: {StatusCode: 401, ReasonPhrase: 'Unauthorized', Version: 1.1, Content: System.Net.Http.NoWriteNoSeekStreamContent, Headers:{  Date: Wed, 23 Oct 2024 16:35:03 GMT  Transfer-Encoding: chunked  Server: Microsoft-IIS/10.0  Content-Type: application/json; charset=utf-8}}This is my code:using System;using System.Collections;using System.Collections.Generic;using System.Linq;using System.Text;using PX.Common;using PX.Data;using PX.Data.BQL;using PX.Data.BQL.Fluent;using PX.Objects.CM;using PX.Objects.CS;using PX.Objects.GL;using PX.Objects.Common.Extensions;using PX.Objects;using PX.Objects.IN;using RiverlandDesarrolloV231;using System.Net.Http;using System.Threading.Tasks;using Newtonsoft.Json;using PX.Concurrency;namespace PX.Objects.IN{    public class INReceiptEntry_Extension : PXGraphExtension<PX.Objects.IN.INReceiptEntry>    {        #region Event Handlers        public

We have a custom publicly available filter. public PXFilter<ShipperTankFilter> showShipperTanksFilter;The filter is defined as follows: [PXHidden] [Serializable] public class ShipperTankFilter : IBqlTable { #region TankSerialNbr [PXString(20)] [PXSelector(typeof(Search<SOShipLineSplit.lotSerialNbr>))] [PXUIField(DisplayName = "Tank Serial Nbr", Enabled = true)] public virtual string TankSerialNbr { get; set; } public abstract class tankSerialNbr : PX.Data.BQL.BqlString.Field<tankSerialNbr> { } #endregion }We have an action called createBoxes.  We’ve exposed this action as a REST API endpoint named CreateBoxes, mapping the TankSerialNbr parameter. When we call the CreateBoxes action via Postman, we receive a 422 Unprocessable Entity error. By way of troubleshooting, we create another field TankSerialNbr2 on the filter as shown: [PXHidden] [Serializable] public class ShipperTankFilter : IBql

Hello! Is there a way that we can get a status changed date into a report not viewing by the Audit History? Amanda

I made a custom endpoint:  I added the PrimaryQuote action:  I send a POST request to set a Sales Quote as primary:  I get a server error: {    "message": "An error has occurred.",    "exceptionMessage": "Object reference not set to an instance of an object.",    "exceptionType": "System.NullReferenceException",    "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.InvokeAction(String objectName, String actionName, ActionInvocation invocation)\r\n   at lambda_method(Closure , Object , Object[] )\r\n   at Microsoft.AspNetCore.Mvc.Internal.Acti

Hi guys I am trying to make a report based on today’date, payment method and status open. This is going to be on payment screen. Any one please guide me with any reference. When we select these fields in parameters It should return all the payments with customers in report. It will have customer relation with payemtns . Any one please guide me on how to start 

Hello,On Acumatica Cloud 2024 R1I’m using the end point Default/23.200.001/Payment (also tried with Default/22.200.001/Payment) After creating a SaleOrder, I’m trying to add a Payment for it using the web service, but I’m stuck in error returning from the API with this message:{ "message": "The request is invalid.", "modelState": { "": [ "An exception occurred during input parsing" ] }}I’m not sure what is invalid, I’m using the same JSON format I used to create the sales order, here is my payment POST request: { "Type": { "value": "Payment" }, "CustomerID": { "value": "1047204" }, "ApplicationDate": { "value": "2024-10-18T11:00:51" }, "PaymentAmount": { "value": "439.22" }, "PaymentMethod": { "value": "ONLINE" }, "PaymentRef": { "value": "86561" }, "CashAccount": { "value": "11140_____" }, "AppliedToDocuments": [ { "Type": { "value": "SO" }, "ReferenceNbr": { "value": "86561" },

hi, All. We have one screen name bank deposits. I am trying to put data in ths screen using API. I have extended the endpoint and add this screen in webservices. But when I am calling put method it returns an error.Can any one please guide me on this 

Here is the URL that has been working for well over a yearhttps://companyx.acumatica.com/ODatav4/companyx/PX_OBJECTS_AR_ARADDRESS?$format=jsonStarting on October 8th, 2024. the Azure Data Factory pipelines started failing with the error ”ErrorCode=RestCallFailedWithClientError,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Rest call failed with client error, status code 404 NotFound”I am hunting for a change notification or something regarding the URL needing to be updated or something, but I am not having any luck. Thoughts? 

Hi, I have created a new endpoint in acumatica and then entity of payment in it, Then i tried to create a record using the API but the payment Tab is null and the main summary is created.My query is :http://localhost/PR00000009/entity/Bank/22.200.001/BankDeposit?body: Entity : Below is the screen shot of the screen. The summary is created by PUT API but payment is null. What should i do in this case ?  Response:  

Hi everybody,Is there a native way to using the REST API to filter the list of ProjectTasks (for example) based on a single Attribute’s value? I tried a couple things for the $filter. I tried referencing attributes as if it they weren’t an array, like so.Attributes/AttributeID eq 'SCOPE' and Attributes/Value eq 'Test'But I got this error: “The parent value for a property access of a property 'AttributeID' is not a single value. Property access can only be applied to a single value” Then I tried using the `any` lambda, referenced here:Attributes/any(a: a/AttributeID eq 'SCOPE' and a/Value eq 'Test')But I got this error: “The method or operation is not implemented.” Is there any way to do this?

Hello all,I am currently implementing token retrieval using HttpClient in the .NET Framework and have encountered an issue. I am using the SendAsync method to send the username and password in the JSON body as part of the request, but I'm experiencing difficulties with the token acquisition.Below is a snippet of the code I am using for this operation:public PXAction<INRegister> PrenderAntena;[PXButton][PXUIField(DisplayName = "Prender Antena", MapEnableRights = PXCacheRights.Select, MapViewRights = PXCacheRights.Select, Enabled = true)]protected virtual IEnumerable prenderAntena(PXAdapter adapter){    Prueba();    return adapter.Get();}public async Task Prueba(){// Use specific classes to define the JSON structure    var credentials = new Credentials    {        usuario = new FieldValue { value = "MyUser" },        contraseña = new FieldValue { value = "MyPassword" }    };       string jsonPayload = JsonConvert.SerializeObject(credentials, Formatting.Indented);    string url = "M

Hello! I am trying to pull all historical Sale Orders via the REST API. Given that we have a lot of orders, the request takes over 10 minutes. However, I noticed that every time I run the request, I hit this error around the 10 minute mark:If I add a time filter, eg get all Sales Orders after some date, the api returns results as long as it finishes in under 10 minutes. Anyone know what’s going on? Is there a way to set the timeout to be > 10 minutes?[OperationCanceledException: Operation Cancelled] PX.Data.PXCancellationToken.CheckCancellation() +197 PX.Data.PXAccess.GetConnectionString() +15 PX.Data.PXDatabase.get_Provider() +143 PX.Data.PXViewQueryCollection.Unload() +87 PX.Data.PXGraphQueryCacheCollection.Unload() +105 PX.Data.PXGraph.Unload() +2267 PX.Api.ContractBased.EntityExportContextBuilder.Dispose() +49 PX.Api.ContractBased.<GetListAsyncFromEnumerable>d__8.MoveNext() +2117 System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() +32 Sys

Hi, All. I am trying to get the UDF on customer screen using the GET in rest API. But the problem is the get call is returning the value null. Even the value is present in the UDF in UI. Any suggestion what should i do? Secondly when I am trying PUT request with empty body there is a value in the custom dict. Any one please help or guide me on how to over come this and what will be the best approach to fetch all udf values with customer id.GET: http://localhost/entity/Default/22.200.001/Customer?$filter=CustomerID eq '000002'&$custom=Baccount.AttributeAGDCRAN PUT: with same query 

We have an external system that makes REST API calls to the SalesOrder endpoint. Every once in a while the resulting JSon has null for all Usr fields.  I can refresh the data and the result will have all field values.The other day we added code in the graph extension’s initialization routine to access some custom fields in a setup table.  Then we started to see the occasional error because those calls to GetExtension were failing. But only once in a while. But when they started to fail, they continued to fail, over and over, for a period of time. Sometimes we restarted Acumatica, sometimes the error just went away.I removed the code from the initialization routine and things were better.Doing some stress testing today, forcing ACM to send me the GET result from the order over and over, we’d get to a point where the JSon result was showing null values in all custom fields. The base fields still contained data. No change to the underlying transactional data - just sending multiple GET re