Develop Integrations with Web Services | APIs

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

I'm trying to fetch the user-defined-field that I added in Customer Entity but it's not working. I'm getting this error: "message": "An error has occurred.", "exceptionMessage": "The column 'Document_AttributeCWCID' is not found in the data set.",It is working in Contact entity and SalesOrderMy sample parameter in Contact $custom = Contact.AttributeCWCIDIn SalesOrder: $custom = Document.AttributeSOID

Hi,I’m trying to integrate Cybersource Secure Acceptance as a new Processing Center in Acumatica,My problem is that after creating the processing center and after adidng payment method, when I go to pay a sales order , it’s not showing authorize or capture option and work as if it’s offlice payment method, see this screenshothere is what I did in creating my paymen pluginCreated a customization project in that project I created a class that implment ICCProcessingPlugin and I added all the settings and based on it I was able to create the payment processor and ad dpayment method attached to it. I created another class that implement ICCHostedPaymentFormProcessor , this is where I’m adidng the form that will be used to implement the payment form where the user enter his card details , I implemented the method “HostedFormData GetDataForPaymentForm” I created class to implmenet ICCTransactionProcessor but I’m not sure if it’s required or notWhat I expected when I go to create payment for S

Is it possible to notify a user with an on screen message when a business event’s condition is met? The use case is to display a message to the warehouse receiver when receiving an item that has a attribute set for special storage conditions such as Allergen, SDS, COA.

I have a custom button on a grid and want it to be enabled only for certain rows.Therefore I implment the RowSelected event and use SetDisabled(false).That seems to have no effect. Pressing the button after selecting a row where the action should be disabled is still possible but causes an error message saying the button is disabled.What do I have to do to get the button shown correctly as disabled? Some Code:ASPX:<asp:Content ID="cont1" ContentPlaceHolderID="phDS" Runat="Server">    <px:PXDataSource ID="ds" runat="server" … >        <CallbackCommands>                     <px:PXDSCallbackCommand Name="Discard" DependOnGrid="grid" ><asp:Content ID="cont2" ContentPlaceHolderID="phL" runat="Server" RepaintOnDemand="false">    <px:PXGrid ID="grid" runat="server" DataSourceID="ds" SkinID="Details" >…       <ActionBar >            <CustomItems>                <px:PXToolBarButton Text="Discard">                    <AutoCallBack Command=

Hi,I used the screen “Web Services Endpoints” then menu “… > Service Definition > Open API 2.0” to generate the swagger.json file.This is for the Acumatica: "/entity/Default/23.200.001" collectionI then processed that through the openapi-generator to generate a java client:java -jar openapi-generator-cli-7.8.0.jar generate -i [domain]entity/Default/23.200.001/swagger.json?company=[company] -g java --api-package [mypackage].finance.acumatica.openapi.client --model-package [mypackage].acumatica.openapi.client.model -o testoutput --skip-validate-specThat generates the java client .java files.  These all compile to .class files without any errors.So this all looks good so far.  This is industry standard for generating a client from swagger.json data.  However when I run the client I get an error.  The client makes a request to acumatica for data like:                        VendorApi va = new VendorApi(apiClient);                        List ids = new ArrayList();                    

Hello all, I need to Nightly update 200-500 Projects Tasks to Completed and then Run the Allocation through the REST API. Works great for 1 project 1 task. But I will need to many each night. Is there a way to batch them in instead of 1 call to ProjectTask and 1 to run the Allocation?  IS the REST API not the best way to do it? Thank you

Hi,I’m trying to filter out Project Tasks via my API query but so far haven’t been able to get this to work correctly. So far, I’ve tried filtering like this:“VisibilitySettings/TimeEntries eq 'true'”and“VisibilitySettings/TimeEntries eq true” For both of these filters, I will still get back ProjectTasks whose TimeEntries Visibility settings are equal to “false”. Is this possible to do?

My company has implemented integrated for UPS, however, we find that our discount with UPS is not applying. What could be causing this glitch and how can it be fixed?Acumatica’s Integrated Shipping Cost Our Expected Rate

I use $expand to examine an existing Sales Order:https://sandbox.com/entity/Default/22.200.001/SalesOrder/WB/WB00162584?$expand=FinancialSettings,BillToContact,BillToAddress,ShippingSettings,ShipToAddress,ShipToContact,Details,TotalsHowever, the Details JSON doesn’t include Subaccount.  Do I need to expand something else to see it?  I want to be able to create another details line and include the Subaccount but I’m not sure what to use.

When viewing a Blanket Order in the Acumatica UI, a tab is displayed which lists the children of that blanket order. Is there any way to fetch this list of orders using the REST API?Thank you.

Hello Community!!,Using SalesDemo, I am trying to add/update One Line item in Appointment Details with ActualQty, having Line type as "Non-Stock Item" through Postman PUT call using the “Appointment” EndPoint. Add Scenario: If the ActualQty is not included in the JSON request or if added as null then ActualQty is saving as 1.00 by default. But when I try to insert any value for ActualQty field I am getting an error as "exceptionMessage": "An error occurred during processing of the field Qty: Specified cast is not valid..".Update scenario: If the ActualQty is not incuded in the JSON request then the other fields are updating with out any error. If the ActualQty value is null then getting "error": "'BaseEffTranQty' cannot be empty.; 'BaseEffTranQty' cannot be empty.; BaseEffTranQty: 'BaseEffTranQty' cannot be empty.". Tried including the BaseEffTranQty but no fields are udpating. If the AcutalQty has any value such as 2, 2.0, 2.000000 or “2” then getting an "exceptionMessage": "An error

Hi, is it possible to overlap logo’s in Report Designer.  So I have a large company logo and the client wants the smaller accreditation to sit on top of the Company Logo.  Is this possible? Regards,Laura

I’ve seen the endpoint for this but not the the rest of the api.  Anyone know where we can access the full api vs. just the few examples from the integration site?Thanks!Melissa

I don’t see anywhere in Acumatica how we can link attached file in a product with Shopify to have that file visible in Shopify. I only see Media for URL, image or video link.Is there a way to have something to link pdf file like manual or spec sheet that could be set in Acumatica and be visible in shopify for customer, instead of doing it manually in Shopify?Is seems that “Files” on top of page of an article can’t be associate with Shopify,.. and I was curious to see how we could publish them because we have demand for… or if I must put it as suggestion.

I want to create a bill related to a subcontract. I am able to create bill for PO receipts but can not create for subcontract using the same steps.I have added SubcontractNbr and SubcontractLine in the Bill.Details entity like  After that if a bill is created through Subcontract via “CREATE AP BILL” button and we try to GET that bill through API, we get these fields (SubcontractNbr and SubcontractLine) in the response. But when we try to add these data while creating bill through PUT request, the items are not linked to the Subcontract. Payload:{ "Vendor": { "value": "20119" }, "VendorRef": { "value": "IX00614958-C" }, "Date": { "value": "04/06/2024" }, "VendorDocDate": { "value": "04/06/2024" }, "BranchID": { "value": "TESTCOMPAN" }, "DocDesc": { "value": "V004651-2" }, "CashDiscountDate": { "value": "04/06/2024" }, "PostPeriod": { "value": "06-2024" }, "DueDate": { "value": "02/06/2024" }, "Amount": { "value": 750 }, "Details": [

Good day,I am trying to add an invoice in the Documents to Apply tab for a Credit Memo on the Payments & Applications (AR302000) screen via the API endpoint: {{base_url}}/entity/{{endpointName}}/{{endpointVersion}}/PaymentWhen I push through the applicable payload, I get the following error message: “The document is out of the balance.; curyOrigDocAmt: The document is out of the balance.”The slight mind scratcher here is; suppose I open the credit memo on the Payments & Applications screen and then manually click the Load Documents button on the screen, let the system load the invoice, and then save. If I remove that line, save it again, and then push through the same API request, I don’t get an error and the invoice shows up on the Documents to Apply tab.What would be wrong with my initial attempt at adding this invoice line to the credit memo’s Documents to Apply detail section?Request:{ "Type": { "value": "Credit Memo" }, "ReferenceNbr": { "value": "FT

Hi Team,We have a requirement as we create a receipt via API calls and there is a User Defined Field tab in the form level on how to create and update those fields in the receipts screen through the API calls, can you please review and suggest the best way possible to achieve it.Thank you!

Hello Community!I’m researching a way to send an API call FROM Acumatica TO a third-party endpoint. I’ve read through the I310 course document and I’m not seeing what I’m looking for.Example flow: User clicks a button on a screen, API call goes out, data is returned to the screen.Could anyone please point me in the direction of the right documentation or any resource that could assist?Few quick notes:We are on 2024 R1 Build 24.108.0034Our tenant is hosted in the cloud (I do not have back-end access)I’m familiar with API and Postman, just not how to send from Acumatica Thank you,Justin Long

I have a project with two tasks on it. Both tasks are active. I am using REST API to mark the task as complete. I keep getting an error that says “The Complete Button is disabled”This message is misleading as the button is very much enabled on the UI.Please see screenshots. Call from PostmanComplete button on task. 

I’m trying to create AP Bill Payment by REST APII found that I can do it with “Check”, but it doesn’t work for me - may somebody have experiance with AP Payments and can say what I’m doing wrong.One of my API requests: PUT http://***/entity/Default/20.200.001/Check HTTP/1.1Accept: application/jsonUser-Agent: OpenAPI-Generator/1.0.0/csharpContent-Type: application/json{"ApplicationDate":{"value":"2024-09-08T00:00:00"},"CashAccount":{"value":"10011"},"Description":{"value":"Test"},"Details":[{"AmountPaid":{"value":15.0},"DocType":{"value":"Bill"},"ReferenceNbr":{"value":"TEST002"}}],"PaymentAmount":{"value":15.0},"PaymentMethod":{"value":"CHECK"},"PaymentRef":{"value":"Test001"},"Type":{"value":"Payment"},"Vendor":{"value":"V100"}}All my attemts finish with an error like: “exceptionMessage=The system failed to commit the Adjustments row.”