Develop Integrations with Web Services | APIs

Hey All hope everyone is having a great weekend! i’m struggling with this Request i’m trying to make toGET: /ProjectTransactions,  i want to get ProjectTaskID or ProjectID  but when i added it i get this error {\"message\":\"An error has occurred.\",\"exceptionMessage\":\"GenericArguments[0], 'PX.Data.FieldNameParam', on 'PX.Data.Current`1[Field]' violates the constraint of type 'Field'.\     Thanks

I see the differences in the available fields. I am looking for info at a higher level.Also, does the SalesInvoice represent the same data that is at the Invoice UI, or is there another UI/Screen for SalesInvoice?

Hi all, We’re trying to create integrations and during the testing, I’m running into some issues with the api parameters. Does Acumatica support the following?  entity/default/22.200.001/vendor?$filter=VendorID eq '501446'&?$expand=MainContact,MainContact/AddressI find that when I try to use filter or select when expanding that I get unexpected or limited results. Is this a limitation of the api or is my syntax not correct?I’m trying to get an efficient query that gets a couple of fields on the vendor entity and a few off the expanded entities. I have been able to remove filter, select, and expand and get the entire data set, but I don’t want that waste in the automation.  Thanks in advance!

We’re trying to use an iPaaS service to search a customer record by email and add an activity, however we’re getting an error message and having difficulty deciphering its meaning and/or what might be causing this.Here’s our PUT request:PUT https://pXXXXXXXX.acumatica.com//entity/Cyclr/20.200.001/CustomersByEmail?$expand=Result HTTP/1.1Accept: application/jsonAuthorization: REDACTEDUser-Agent: Cyclr, (https://cyclr.com)Content-Type:application/json; charset=utf-8Content-Length:47{"Email":{"value":"kXXXXXX+test201@gmail.com"}} 500 Internal Server Error:{"message":"An error has occurred.","exceptionMessage":"The given key was not present in the dictionary.","exceptionType":"System.Collections.Generic.KeyNotFoundException","stackTrace":" at System.ThrowHelper.ThrowKeyNotFoundException()\r\n at System.Collections.Generic.Dictionary`2.get_Item(TKey key)\r\n at Microsoft.Data.OData.Query.SyntacticAst.ExpandBinder.GenerateExpandItem(ExpandTermToken tokenIn)\r\n at System.Linq.Enumerable.Where

I am working on an API integration that stopped working. I have narrowed the problem down to - endpoints on one tenant return an empty body in the response.I tested outside of my application using Insomnia to test results from endpoints. With everything equal other than the tenant, 5 different endpoints returned an empty body on one tenant, and worked as expected on another tenant in the same instance.Someone else did install a customization package between when things were working and when things broke. So, I am suspicious that the cause may lie in that package.I am relatively new to Acumatica. So, I don’t know where to begin looking. Can anyone point me in the right direction?

I’m testing adding a file using Postman and I’m getting the error:{    "message": "The request is invalid.",    "modelState": {        "": [            "Unable to translate bytes [E2] at index 10 from specified code page to Unicode."        ]    }} Here are the headers:In the body I’ve tried several different pdf files but I still get the same result.  I’m not sure what I need to change to get this to work.

Hi,I’m using Screen-Based SOAP API to generate PDF reports and saving them to local folders. It all works fine besides the financial reports.For our balance sheet, we have three parameters: Branch, Ledger, and Financial Period. For some reason, the schema does not contain the Branch and Ledger as part of the parameters. It only contains financial period in the parameter list. But then I tried to set a default value for the Branch and Ledger in the report setting, it’s still giving me the below error:System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.ArgumentNullException: Value cannot be null.Parameter name: key at System.ThrowHelper.ThrowArgumentNullException(ExceptionArgument argument) at System.Collections.Generic.Dictionary`2.FindEntry(TKey key) at PX.Data.PXViewCollection.TryGetOrCreateValue(String key, PXView& value) at PX.Data.PXViewCollection.get_Item(String key) at PX.Api.ScreenUtils.Submit(String screenId, IReadOnly

I have successfully updated the Ethnicity with my PUT call for tax Settings.I can confirm the update worked by doing a get call The UI won’t show the change. This only happens if the field is a drop down value. ​​​ 

I extent and point from default endpoint (version 22.200.001) of acumatica and I add new fields in the stockitem, then call the stockitem by postman to view warehousedetails(Qty on hand), getting exception message ‘GenericArguments[0], 'PX.Data.FieldNameParam', on 'PX.Data.Optional`1[Field]' violates the constraint of type 'Field'.’, but I m trying same with the default endpoint it working expected, please let me know what I did wrong by mistake. or how can I resolve it Extended endpoint for Stockitem  

Is it possible to post to $batch with 2023r1? 

in Acumatica I am exposing data of purchases order by Web service endpoint but json data is not in expected format as required, do acumatica have feature to transformation Json data format.Acumatica json format:{ "id": "81f542f0-42d5-ed11-9272-00155d056707", "rowNumber": 1, "note": { "value": "" }, "warehouseCode": { "value": "01" }, "type": { "value": "PO" }, "supplyNo": { "value": "123" }, "lineID": { "value": "1" }, "custom": {}, "_links": { "self": "/AcumaticaSmartFactory/entity/ewsfendpoint/22.200.001/PurchaseOrder/81f542f0-42d5-ed11-9272-00155d056707", "files:put": "/AcumaticaSmartFactory/entity/ewsfendpoint/22.200.001/files/PX.Objects.PO.POOrderEntry/Document/81f542f0-42d5-ed11-9272-00155d056707/{filename}" } }Required json format: { "warehouseCode": "01", "type": "Purchase Order", "supplyNo": "123", "lineID": 0 }

I am using Acumatica and want to create new endpoint for post data API to update/insert data in acumatica data base , in acumatica do we have any way to create a new web service endpoint without creating new screen/UI

Hi all,I found out for clients NOT using “Multiple Warehouse Locations” feature, the following WMS features not working:Put Away Scan and Receive Scan and TransferAny workaround for users to use scanner and move stock between warehouse and NOT locations? Thanks

Good day,I was wondering if someone could help me identify the reason for an error I am having when I insert CustomerLocationID creating an invoice. I receive data from a SOAP API endpoint, and I have a method to create customers and Locations if they don’t exist in acumatica to insert them on their corresponding fields. After my code verifies if the first Location exists and creates the new location or if already existed, just assigns it to CustomerLocationID field, it creates the first invoice successfully, but from there the second invoice gives an error that says there was a problem processing the field Location value “Any Location” Location cannot be found in the system.I don’t understand why the error says cannot be found in the system, when I check Customer Locations in Acumatica, it did create the new Location, and if I try to create the invoice manually with that Location, it saves with no problem. the first fragment of code is the class where I create the invoice and the seco

Hey Team  Hope everyone here is doing well i’m trying to create project tasks under existing project using Rest API  Endpoint : {{baseUrl}}/ProjectTaskMethod : PUTHeaders : Content-Type:application/jsonBody :  {  "ProjectID": {    "value": "100349"  },  "ProjectTaskID": {    "value": "L-726483"  },  "Description": {    "value": "TEST"  },  "VisibilitySettings": {    "GL": {      "value": "true"    },    "AP": {      "value": "true"    },    "CRM": {      "value": "true"    },    "Expenses": {      "value": "true"    },    "IN": {      "value": "true"    },    "PO": {      "value": "true"    },    "SO": {      "value": "true"    },    "TimeEntries": {      "value": "true"    },    "AR": {      "value": "true"    },    "CA": {      "value": "true"    }  }}  Error : "Inserting  'Project Task' record raised at least one error. Please review the errors.\nProjectID: 'Project ID' cannot be empty.\nTaskCD: 'Task ID' cannot be empty.",  The project Exist in Acumatica    Thanks

Hey Team i’m sending a POST request to create Project in Acumatica but it not throwing an Error at all it showing success but i can’t find it in Acumatica  POST : https://mycompany.acumatica.com/entity/projects/22.200.001/ProjectBODY :  {  "ProjectID": {    "value": "P-76732"  },  "ProjectCountry": {    "value": "Montgomery"  },  "Description": {    "value": "TEST"  },  "GL": {    "value": "CSMABAWA"  }}   Thank you so much

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