Develop Integrations with Web Services | APIs

I am updating entities via put request through the API and the responses from Acumatica are returning in text format instead of json even though I have added the accept header for application/json in the request and the response header specifies that it is in json format. With get requests for entities and put requests to get data from custom endpoints, I am getting json as expected. Does anyone know if this has been fixed in later versions of Acumatica? We are currently using 21R1 but plan to upgrade to 23R1 soon.

Hello Acumatica Community, Starting in Acumatica 23r200 we plan to remove the 17.200 and 18.200 endpoints. Please note that these are the last endpoints to support the SOAP API, so when it is removed integrations built using SOAP will no longer function.. We recommend updating solutions to use the latest endpoint, the REST API, and OData v4. For more information see page 6 of the 23r2 Developer Release notes.http://acumatica-builds.s3.amazonaws.com/builds/preview/23.2/ReleaseNotes

When trying to add this record with the TransferNbr in the request payload, The line items data is not including my custom fields. I have extended the endpoints to include newly added custom fields and they are working fine when I try to add the standalone Inventory Receipt, but they are not populated when I try to add TransferNbr and add the line items, the custom fields are not populated.

For this GI AR3010PL, I am trying to create a new web service endpoint. I am able to fetch All records but I need to fetch the “Due Date”​ filtered data. Not sure how to achieve that.  Following is how i am sending request in postman  

Hi ConnectionsI'm attempting to use an API to update vendor info like primary contacts and account addresses. Except for the vendor name, the application's other data fields are not updated. Please use the payload shown below as a guide.   {    "VendorID": {        "value": "V00001"    },    "VendorName": {        "value": "SSCI Energy Sdn Bhd"    },    "Name": {        "value": "Robert"    },    "Email": {        "value": "robert@sscienergy.com.my"    }} Thanks Ram 

Okay so I am working with Celigo to migrate data between legacy ERP systems to Acumatica.  One task is to create Customer Records in Acumatica, will work on Vendors next.  With Customers though there are two Topclass endpoints I am looking to use: Customer and BusinessAccount. However, 3 required fields on the Customer Record are AR Account, Sales Account, and Cash Discount Account. I am trying to set them via a webservice call but don’t see these fields available under the default Endpoint and under either Customer or BusinessAccount TopClasses. I know we can set them on the Customer Class via the CustomerClass Endpoint but don’t see it under Business Account or Customer. Any information on what these values are so I can set them using ideally the customer Endpoint? Do I need to duplicate the default Endpoint and then extend Customer? 

Hi, we need to perform an integration between Acumatica and IFS. The integration points are given below. How can we open an endpoint for IFS to perform these operations via GET and POST from the Acumatica end?Acumatica PO Transfer to IFS as IFS customer Order (GET request from IFS) IFS Shipment Integration to create Acumatica Proforma Invoice (POST request from IFS) IFS Shipment Integration to create Acumatica Purchase Receipt (POST request from IFS) Acumatica PO change order integration to IFS customer order (GET request from IFS) IFS sales part integration to create sales part in Acumatica (POST request from IFS)Thank you.

I am looking to see if there is an automated process for installing a license key to our Acumatica instance (non-production) via an API or other automated script. We are looking to refresh our Non-prod environment at least once a month, maybe even every 2 weeks. I have been able to automate everything except the reapplication of the license key. Any suggestions would be awesome! Thank you!

I’m trying to update an existing stock item record using a PUT request: but I’m getting the following "Object reference not set to an instance of an object." 500 error from the server. Why is this happening? I can retrieve the record just fine using a GET request.{ "message": "An error has occurred.", "exceptionMessage": "Operation failed", "exceptionType": "PX.Data.PXInvalidOperationException", "stackTrace": " at PX.Api.ContractBased.EntityService.Put(ISystemContract systemContract, String version, String name, EntityImpl entity, CbOperationContext operationContext, Boolean throwOnError)\r\n at PX.Api.ContractBased.Soap.SoapFacadeBase.PutImpl(EntityImpl entity, Boolean throwOnValidationError)\r\n at PX.Api.ContractBased.SystemContracts.V2.RestController.PutEntity(EntityImpl entity, String select, String filter, String expand, String custom)\r\n at lambda_method(Closure , Object , Object[] )\r\n at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionEx

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,  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