Develop Integrations with Web Services | APIs

 Hello, I’m wondering how I can go about importing a sales order into Acumatica by using the REST API. I realized that this is likely through the use of the Actions however I could not find one that would do the action of “New Sales Order” Any ideas on how to do this?

Good day, Can we kindly request some assistance regarding extracting data from a general enquiry form via an api call. We’re trying to export a large list of data (screenshot 1) containing product stock details. We’ve created a general inquiry form and extended an api endpoint. Upon trying to query this new endpoint we are receiving an error: "Optimization cannot be performed.View Results has BQL delegate (screenshot 2) We’ve also had a look at perhaps creating a custom export action endpoint (screenshot 3) for the general enquiry form. Unfortunately we’ve been unsuccessful in attempts to achieve this. Any guidance regarding either approach will be appreciated. Kind regards,Alecia

Team - I'm encountering an error while trying to create a new project record in Postman. I've included all the mandatory fields that are required when creating a project directly in the UI.Here's the issue:I'm getting an error when sending the request through Postman. I'm unsure if fields like "ProjectID" need to be populated when creating a record. In the UI, these seem to be generated automatically.For reference, I included "ProjectID" : {"value" : "<NEW>"} in my request body, but it didn't resolve the error.Could someone please advise on:What I might be missing that's causing the error (406) in Postman? Whether fields like "ProjectID" need a specific value when creating a record or are they indeed auto-generated?  I was referring the below link to create request, https://help.acumatica.com/(W(15))/Wiki/ShowWiki.aspx?pageid=13f5f5b8-33d1-40d9-83db-3f3dfc5dcba9

We are trying to add a new record in Details tab of Appointment. We are getting error when the number of records under details tab are more than 600. If it is less than 200 or so, we not see any error, everything works as expected.URL:https://xxxxx.acumatica.com/entity/customendpointname/20.200.002/Appointment?$expand=DetailsRequest Body:{"AppointmentNbr":{"value":"PM004839-1"},"Details":[{"Description":{"value":"test"},"LineType":{"value":"Instruction"},"TargetEquipmentID":{"value":"CHAUD02/ECOL201"},"note":{"value":"string"}}],"ServiceOrderType":{"value":"PM"}}HTTP PUTResponse from Acumatica REST API:request entity too largeError in Acumatica website system monitor screen:ContextScreenId = ~/ENTITY/DEFAULTKOLOTECH/20.200.002/APPOINTMENTContextUserIdentity = mounish@Beaver - ProductionCurrentCompany = Beaver - ProductionEventID = ResourceGovernor_ApiRequestTerminatedEventIdSourceContext = ResourceGovernorCustomData =[ {   "SqlRows": null,   "CorrelationID": "",   "ContextID": "",   "S

Hi,I have a customer trying to implement integration and we’re trying to attach files to bills but are unable to do so. it’s showing as success, but there’s no attachment.here’s the sample URL request:https://dev-acumatica.customername.com/customeracct/entity/default/22.200.001/Bill/INV/026331/files/file.pdfI’m trying to find any related API documentation for this specific endpoint but failed to do so. 

Hi all, I am planning and checking to find if there is a way to connect Acumatica with Zapier or MS Power automate to perform some tasks for eg if new customer added in acumatica so it should raise notification on teams to me and my Manager.  Note: This is just an example but I am planning to connect it for others tasks as well. Any guide will be appreciated. Thanks 

Is there an API collection available for Acumatica where we can access various sets of APIs? I have reviewed the Integration Development Guide provided in PDF format; however, I did not find a comprehensive list of APIs. The PDF book appears extensive, and its length sometimes makes it challenging to locate specific information. Could someone kindly assist me in obtaining a complete list of all APIs provided by Acumatica? 

We are in the middle of our Acumatica implementation and about to start a move from Magneto 2 into Big Commerce B2B.  We were hoping that Quotes between Acumatica/Big Commerce would sync and update each other.  Is anyone doing similar… how?

"I'm encountering difficulty locating the JSON Web Key Button and JSON Web Key URL options within my client application. While the shared secret box is visible, these two dialog boxes seem to be missing. What configuration adjustments are necessary to enable the visibility of these dialog boxes? Alternatively, could I be overlooking something crucial? Any guidance or assistance in resolving this issue would be greatly appreciated." 

Hi,I need to write a JavaScript function to process an external request. For which I need to pass some values such as session, cookie, DB values, from server side into the JavaScript function.However, I am not sure how can I pass these values from the server side after processing into javascript function. I have added a PXTextEdit control <px:PXTextEdit ID="UsrSessionCookie" runat="server" Size="XL" DataField="UsrSessionCookie" Visible="False" />which I though I can use to read the values using below syntax into JavaScript but I am not able to get it if I make these PXTextEdit Visible="False".px_alls['UsrSessionCookie'].getValue();I have also tried below to get values but no luck-document.getElementById("ctl00_phF_form_UsrSessionCookie");Also, I have to make sure that server side code executes first which will get all required values and then process the JavaScript request.Any suggestions?Thank you

Hello everyone,I've successfully integrated Acumatica with Adobe Sign, enabling me to send documents for signatures directly from Acumatica. The recipients are receiving the documents without any issues, signing them, and sending them back (they also receive a copy of their signature). However, when I attempt to track the status of the documents through Esign Central, they remain stuck on "draft." Oddly, when I check through the Adobe Sign website portal, it indicates that the documents are completed. Any insights or assistance on why this might be happening would be greatly appreciated. Thanks in advance 

"I currently have my Acumatica ERP running locally on my private PC. However, I now need to host it on a server to make it accessible for users to utilize the services we've developed. Can someone provide guidance on how to successfully host the Acumatica ERP on a server?"

Trying to create a SOOrder along with an ARPayment inside a PUT request. I receive the error:"Inserting  'AR Payment' record raised at least one error. Please review the errors.\nCashAccountID: 'Cash Account' cannot be empty." This is my json and route that I’m using:   

Hii I'm getting an issue while trying to create a customer in Acumatica from Salesforce using an API POST request. To address a mapping problem in the default endpoint, I've created a Custom Endpoint with an action named "Save" specifically for this purpose. However, upon sending the request, I receive an error message: "The request is invalid," along with details stating that "The Entity field is required."Could you please assist me in resolving this issue? 

I am unable to see the Add Shared Secret Dialog Box and Add JSON Web Key Dialog Box in my Connected Application Page in Acumatica. How to see these dialog box do i need to enable something or i am missing out something?  

I've been trying to generate my access token in the Acumatcia platform using the Authorization code flow but i am unable to generate it as it is raising me an error invalid client i have also tried the Resource owner password flow but still it is giving me the same error invalid client. I have generated the access code but when i am using that access code in authorization flow it is giving me an error . I have followed all the steps as told in their Acumatica Integration guide and made an client application in the acumatica , generated the client id and client secret.   Here i am using the post request to send in the request and is using the redirect uri of the postman only. By using the GET method i have generated the Authorization Code and was successful in it. Can anyone help me to resolve the issue of invalid client ?

Hello everyone I was hoping if someone could help me with this subject. We are using the Acumatica API for the upload of files in respect of  some payments.The thing is we can't attach files once an operation is closed, and we want to know if there is a workaround on this or an alternative that we can use to avoid this lock.Thanks for the help in advance.

Hi There,I am trying to run a REST query to retrieves some fields at AR Line Level (coming from ARTran) with a couple of fields coming from the ARInvoice header table.If I start just with the AR Tran part, I have this:/ODatav4/PX_Objects_AR_ARTran?$select=RefNbr,LineNbr&$filter=RefNbr eq 'AR012031'which works fine.I then try to add the expand clause to pull in the related information from AR Invoice. This gets me this:/ODatav4/PX_Objects_AR_ARTran?$select=RefNbr,LineNbr&$filter=RefNbr eq 'AR012031'&$expand=ARInvoiceByRefNbrwhich also works fine.However - lets say I only want to see the InvoiceDate - I add a select giving me this:/ODatav4/PX_Objects_AR_ARTran?$select=RefNbr,LineNbr&$filter=RefNbr eq 'AR012031'&$expand=ARInvoiceByRefNbr($select=InvoiceDate)BANG!And this rather exciting error message that I can’t make head nor tail of.   "innererror": {            "message": "Column DocType is not found in DAC ARRegister. ",            "type": "PX.Data.PXNotSupportedEx

Hi,I’m trying to test Acumatica’s OAuth Authorization flow using Postman. I need to implement an API that will generally be called from a website (our customer portal) and return some information from our company’s Acumatica via OData.I followed the steps in the I300 Web Services course: https://openuni.acumatica.com/courses/integration/i300-web-services-basic-data-retrieval/as well as in the reference documents: https://help-2021r1.acumatica.com/(W(2))/Wiki/ShowWiki.aspx?pageid=2930d2f7-e081-4d0e-8879-93907ce82607I am able to use the Resource Owner Password Credentials flow successfully, but we need to implement the Authorization flow, using a client_id + client_secret approach.I already created a Client in the Connected Applications screen, and set the flow to Authorization Code.Please correct me if I’m wrong: I understand that every time this API will be called, it will need to first request an authorization code from (GET) https://<Acumatica ERP instance URL>/identity/connect

Hi all, Hope you guys are doing good. I am trying to get customer data from my Acumatica instance using some script. Is there any API/endpoint available to get the customer screen field/data together and using code. Please guide me in this . Thanks

Hi everyone, is there a way to modify this License Monitoring Console in my local?I’m trying to use the acumatica api in my local and i’m getting “api login limit” response.

I have new payment processor installed in acumatica. When trying to import payment from bigcommerce. Got issue The payment could not be imported because the combination of the NMI (CREDIT_CARD) store payment method and the NMI store order payment method is not mapped to an ERP payment method for the USD currency or the mapping is inactive in the store settings.Please suggest what could be wrong?

I am trying to expose a Generic Inquiry as a REST endpoint. This Generic Inquiry has a filter parameter of date. When I try to call the endpoint from POSTMAN, it keeps on erroring out.I followed the instructions in acumatica help that tell you to encode the datetime   You should encode date and time values in URL format before passing them as the value of the parameter. For example, you can encode the current date and time by using the System.Net.WebUtility.URLEncode() method as follows: WebUtility.UrlEncode(new DateTimeOffset(DateTime.Now).ToString("yyyy-MM-ddTHH:mm:ss.fffK")).I have tried to call this using different syntax, but it looks like it is erroring out.The parameter is ReportDate and is of type datetime.  I have tried  1) $filter=(ReportDate eq datetime '2024-03-01T00:00:00.000')2) $filter=(ReportDate gt datetimeoffset '2024-03-01T00:00:00.000')3) $filter=(ReportDate eq datetimeoffset '2024-03-01T00:00:00.000')4) $filter=(ReportDate eq datetime '2024-03-01')Each of these cal

Hi Team,Line Details are not adding while creating shipment from REST API using custom endpoint.Below is the JSON used.Note: Tried same JSON using Default endpoint (22.200.001),line details are adding but ship via is not updating using the default endpoint.{    "Type": {        "value": "Shipment"    },    "CustomerID": {        "value": "ASHTEST"    },    "WarehouseID": {        "value": "MAIN"    },    "Operation": {        "value": "Issue"    },    "ShipmentDate": {        "value": "02/28/2024"    },    "Details": [        {            "OrderNbr": {                "value": "000041"            },            "OrderType": {                "value": "SO"            },            "OrderLineNbr": {                "value": 1            },            "InventoryID": {                "value": "DV1221"            },            "ShippedQty": {                "value": 1            },            "UOM": {                "value": "EA"            }        }    ],    "Packages": [        {           

I'm using the Acumatica RESTClient and Acumatica Default_22.200.001 libraries in building an API interface. I'm connecting to the Default endpoint. The Purchase Order screen has a User Defined Field based off an Attribute.I am able to create the PO however the UDF field is not updated. The Custom field in the generated JSON request is only showing the Type but not the Value of the attribute. Below are some code snippets:public class CustomStringField : Acumatica.RESTClient.ContractBasedApi.Model.CustomField { public string Value { get; set; } }Acumatica.RESTClient.ContractBasedApi.Model.CustomStringField customStringField = new Acumatica.RESTClient.ContractBasedApi.Model.CustomStringField() { viewName = "Document", fieldName = "AttributeESTPONBR", Type = "CustomStringField", Value = "E123" };PurchaseOrder order = new PurchaseOrder() {