Develop Integrations with Web Services | APIs

I am using a REST API and want to do the following:Provide data to a screen and invoke an Action The action updates some data and I need to retrieve the data The data is not persisted in a DB, so a subsequent query is not possible.My REST API call performs the action, but no data is returned, only “Status 204 No Content”.Any help/guidance would be appreciated. Crestwood AssociatesRob Millman

We have some heavy customizations around Sales Orders and we also have Avalara integration. When the Sales Order is saved, it can take a few seconds to save the order. When I add an order via the Rest API, I don’t receive back a Location header like I would when I call a Release action, for example.My question is: Is there something I can do to make Acumatica return a Location header when saving (PUTting) a Sales Order via the Rest API?

Hi all,I’ve been running into some issues while trying to create a purchase receipt for a purchase order through the REST API.I’m making a PUT request to /PurchaseReceipt in Postman with this body:{ "VendorID": { "value": "DER" }, "LocationID": { "value": "MAIN" }, "Details": [ { "InventoryID": { "value": "10068777051226" }, "Warehouse": { "value": "NORR" }, "Location": { "value": "J01A" }, "LotSerialNbr": { "value": "1016" }, "ExpirationDate": { "value": "2025-05-01T00:00:00+00:00" }, "POOrderType": { "value": "Normal" }, "POOrderNbr": { "value": "PO000271" }, "POOrderLineNbr": { "value": 1 } } ]}But I end up with a 422 and the following error messa

Hi Experts,I am currently working on integrating with Acumatica and I have encountered a situation where I need to retrieve the count of records while executing an API from Postman.I have a few questions regarding this: Is there a solution to obtain the count of records in Acumatica through the API? What is the purpose of the "$expand" key? Is there an alternative way to import all inner nodes without explicitly specifying them using the "$expand" parameter? How can I determine the "Data Type" of a field when retrieving the schema of an object within the Acumatica system from Postman? I would greatly appreciate your assistance.  

Hi, I faced with such error while trying to insert such set of data to AcumaticaURL :https://Agroup.acumatica.com/entity/ARTSEndpoint/22.200.001/BillBODY :{  "VendorRef": {    "value": "00067001"  },  "DueDate": {    "value": "05/22/2023"  },  "Vendor": {    "value": "PU0262"  },  "PaymentMethod": {    "value": "BACBOS"  },  "Date": {    "value": "05/22/2023"  },  "Description": {    "value": "docAlpha BatchID \"25270\""  },  "CashAccount": {    "value": "10305"  }}The error is the following I tried many values for Cash Account field but result remains sameTried different combinations with Vendors and PaymentMethods but it does not workI mapped this field in EndpointWhat Can cause such issue ?

hi, i need help.I want to attach a file in line Purchase order with API.I am using the Acumatica version 2021 R2

Hi all, I am busy retrieving information regarding activities using the RestApi, but have some difficulty linking the ownerID to a specific user to get his contact details. Using the RestApi, is there any way of getting the contact details for an owner by using the ownerID? I can’t seem to find an entity to search owners by, or I might be overlooking something. Thank you   

Hi Community :   Is it possible to recognize more than 3 fields (Description, Date, Amount) on Expense Receipt Image Recognition for Mobile Application ?  Thanks.

Hi, I need to call api to retrieve some transactions details from 3rd party application into acumatica erp. For testing, I used below code in my own customization project. This is a POST request and url is also defined there. public virtual async Task<IEnumerable> InsertSelectedLines(PXAdapter adapter) {foreach (PXResult<SOLine, SOOrder> result in POrdersView.Select()) { if (lineExt.Selected1 == true) { APProformaItemList toBeInserted = new APProformaItemList(); toBeInserted.Ponbr = order.OrderNbr; toBeInserted.LineNbr = lineNbr++; var url = String.Format("https://sandbox.corporate- api.hsbc.com/mock/v2/transactions"); HttpClient client= new HttpClient(); //added reference client.DefaultRequestHeaders.Add("ContentType

Hi,We recently upgraded to 2021R2 and I am now unable to apply invoices to a payment via the API.The invoice can be applied manually without issue. I am seeing this error message:"An error occurred during processing of the field Reference Nbr.: Reference Nbr. 'IN150421' cannot be found in the system.\nPX.Data.PXOuterException: An error occurred during processing of the field Reference Nbr.: Reference Nbr. 'IN150421' cannot be found in the system.", This is the PUT command, using Default/17.200.001/Payment {  "ReferenceNbr":{"value":"013185"},  "DocumentsToApply":[                       {                        "AmountPaid": {"value" : "641.99" },                        "DocType": {"value": "Invoice" },                        "ReferenceNbr": {"value" : "IN150421" }                    }                   ]} Thanks in Advance for any help.

Hi,  I’m a newbie to webhooks, so I might have missed something simple, please be patient with me 😀 I created a GI and created a push notification to send to a Zapier webhook. However the notification isn’t firing, and I’m not sure why. I attached the XML of the GI.  

Version: { AcumaticaBuildVersion: 22.114.0029, OemBuildVersion: 2022.114.203.2690, DatabaseVersion: 2022.114.203.2690 },PUT: /entity/Default/20.200.001/Check{ "Vendor": { "Value": "A1", "Error": null }, "PaymentMethod": { "Value": "AUTODISBUR", "Error": null }, "CashAccount": { "Value": "100010", "Error": null }, "PaymentRef": { "Value": "8ed73344409a4a6f84afcf846f3bbc84", "Error": null }, "ApplicationDate": null, "Description": { "Value": "[Fleet Batch: 000001]", "Error": null }, "PaymentAmount": { "Value": 486.94, "Error": null }, "Status": null, "ReferenceNbr": null, "Type": null, "Details": [ { "DocType": { "Value": "Bill", "Error": null }, "ReferenceNbr": { "Value": "207668", "Error": null }, "AmountPaid": null,

How can i create a new support case record in Acumatica using REST API action endpoint? Case Screen 

From my understanding, an order status cannot be set when creating a sales order via the API? Would this have to be done by updating the order? We are importing orders from a shopping cart, and so we need to be able to set the sales order status according to the order status. For example, if it has a payment, but that has been flagged by our processor, I need to have those orders set to Hold in Acumatica (they are set to Open by default since they have a payment attached). If it can’t be set at the time of SO creation, how would it be updated via the API?

Hi Allhappy to be part of this amazing community I have a question in the SO you can see i have a value on this custom field i mapped it from Salesforce   but when i call this Order using /SalesOrder?$custom=document.attributeCPQORDNBR&$filter=OrderType eq 'SO'  and OrderNbr eq 'SO0016632'&$top=100 this is the response it showing Null even i have a value as you can see in the 1st image i don’t know why Thanks 

When unpublishing Customization Projects we are constantly running into errors due to the Customization Project not completely unpublishing. And even deleting the Customization Project does not resolve the errors. Can someone help me troubleshoot? Thanks!

Hello,I have a Generic Inquiry that allows some parameters to be passed in. I hooked up a web API endpoint to the Generic Inquiry and it was working fine. But, I wanted to limit the privileges of the user so I created a new user.With the admin user I can call the API just fine and get a response but with the new user I created I can get a response but the details from the query are blank. I have logged in to the UI and the generic inquiry gives me results. What am I doing wrong here?  Thanks,Andrew

Good day,Our E-Commerce developer is experiencing an failed SO with Payment Authorization on the API when the customer has the Avalara Tax Zone.  (If the customer profile does not have the Avalara tax zone, the SO with Payment works fine; we need the customer profile to have the Avalara tax zone-not an option.).  In a nutshell, the current API Calls/Puts are as follow:Customer Profile with contact is created with Avalara Tax Zone.  (No issues) then the Sales Order with a Payment Authorization is created (Failed).  Attached are pdfs of the issue JSON and Postman.My initial thoughts is the need to separate step 2 into two steps; Create SO (let Avalara do it’s initial tax calculation) and then add the payment authorization which would complete the transaction through the API. Any thoughts or suggestion would be greatly appreciated.  (The developer believes i the Avalara tax zone that is causing the failure).  If we separate out #2, do we need a new API endpoint for the payment authorizati

Hello,We have written an integration for an eCommerce platform utilizing the Contract based REST APIs. We have implemented Logout after each request according to guidance from the documentation, and other discussions here in this community, and that helped resolve some issues we were encountering with License limits.Unfortunately, this seems to have exposed a different issue. We are now routinely experience poor performance, and this is apparently related to a number of our calls were getting denied or throttled. You can see below that starting on 4/17, the system is reporting a number of declined and delayed requests. While this is a small percentage of all the transactions, we believe this is a significant number of calls we are making from our system. When we login with our user, we are using a scope of api only. We are open to the suggestion that this is an improper scope for our implementation, and can adjust this if that is suggested. Our API user is configured to allow for up to

I am calling the JournalTransaction endpoint and expanding Details (as shown below).{{BaseURL}}entity/Default/22.200.001/JournalTransaction?$expand=DetailsI would like to apply the $filter param to the field Details/BranchID. In other words, I would like to return all the Detail lines that have a certain BranchID.A simple filter query: $filter=Details/BranchID eq 'SOFT' This returns the error “The parent value for a property access of a property 'BranchID' is not a single value. Property access can only be applied to a single value.” This is likely because Details to BranchID is a one-to-many relationship. I have looked into other syntaxes and found that you can use Lambda Operators: $filter=Details/any(d: d/BranchID eq 'SOFT') This returns the error “The method or operation is not implemented.” Another option is passing the $filter directly in the $expand parameter (also shown in the OData v3 Documentation): $expand=Details($filter=BranchID eq 'SOFT') This returns the error "Term '

Im trying to PUT a Kit assembly from the API in my test environment. It was working and as I continued to test I noticed that I started getting error relating the PostPeriod?PUT : {    "AutoBuiltKit": {        "value": true    },    "ReferenceNbr": {        "value": "<new>"    },    "Date": {        "value": "2023-04-25T00:00:00"    },    "Description": {        "value": "TESTING SO006541"    },    "Hold": {        "value": false    },    "KitInventoryID": {        "value": "ELECOMP2  "    },    "Qty": {        "value": 3    },    "PostPeriod": {         "value": "08-2021"    },    "Revision": {        "value": 10    },    "Type": {        "value": "Balanced"    },    "UOM": {        "value": "EA"    },    "WarehouseID": {        "value": "WHOLESALE "    }} errors below: 

Hi,I am constantly getting HTTP 500 error with Invoice endpoint when called using HttpClient C# code with part of stack trace below.In postman I get the same error the first time but I try it again it works. So, the issue is not with the payload and it is not with HttpClient C# code because it works with Customer endpoint.Any suggestions please?Thanks{"message":"An error has occurred.","exceptionMessage":"An error occurred during processing of the field Type value FCH The 'FCH' list value is not allowed for the Type field. The allowed values are: Invoice, Debit Memo, Credit Memo, Credit WO..","exceptionType":"PX.Api.SyImportProcessor+PXFieldErrorException","stackTrace":"   at PX.Api.ContractBased.ExportTableHelperExtensions.RunExportAndAssertSuccess(SyExportContext exportContext)\r\n   at PX.Api.ContractBased.EntityService.GetList(ISystemContract systemContract, String version, String name, EntityImpl entity, CbOperationContext operationContext, Boolean ignoreValueFields, PXGraph graph

Does anyone know why this checkbox wont save? I also cant POST the value via the API, yet I can GET it and it reads null. Ive set commit changes = true?.  

I’m trying to create and confirm a shipment all in a single Rest API call. I’m trying to do this in Postman first just to see it work. What am I getting wrong?POST URL: http://accounting/(W(1))/entity/Default/20.200.001/Shipment/ConfirmShipmentStructure:{    "entity": {        "ShipmentNbr": {            "value": ""        },        "Type": {            "value": "Shipment"        },        "Operation": {            "value": "Issue"        },        "ShipmentDate": {            "value": "9/13/2022"        },        "CustomerID": {            "value": "CUST2943"        },        "WarehouseID": {            "value": "XODUS"        },        "ShipVia": {            "value": "UPS NXT DAY AE"        },        "OverrideFreightPrice": {            "value": true        },        "FreightAmount": {            "value": 5.67        },        "Details": [            {                "OrderType": {                    "value": "SO"                },                "OrderNbr": {                    "va

Hi everyone,A customer with On Hold status placed an order from BigCommerce. When we synced it, there is an error saying that the customer is not active.Is there a setting where we can allow non-active customers SO to be synced?