Develop Integrations with Web Services | APIs

I have a datetime field in Stock Item, this is the last time that I have exported the Stock Item Data to an external system.Is there a way that I can filter StockItem by comparing LastModified with the Exported date?Something like $filter=LastModified ge Exported. There are many examples using datetimeoffset buy in this case, the date to compare is in the stock item. 

I want to list the roles for a specific user. I have modified the webservice endpoints to include “Roles: ContactRoles” under Users.I am able to get the user information, but I am unable to get the Roles. I have tried the $expand in the URL. 1) Setup for endpoint.Acumatica Setup2) Call in POSTMANPostman Call 

HiAs mentioned in https://help.acumatica.com/(W(5))/Help?ScreenId=ShowWiki&pageid=c5e2f36a-0971-4b33-b127-3c3fe14106ffits possible to operate with odata uri conventions when querying entities (predefined or customized as well).however no odata metadata is available for all entities, which make it impossible to work with .Net OData clients packages, and require to build the HttpRequest parameters by myself.Am I correctly understand this, or there is a convenient way to do so ? (I do not want to define a GI for all entities I need)Thanks

Hi-I'm trying to add a PUT request to my payment screen (AR302000). However, when I test it using Postman, I encounter the following error, and I'm a bit stuck on where to find the issue and fix it. Here's the error message and the JSON data. If anyone could assist me in identifying what's wrong, I'd greatly appreciate it.Thanks a bunch!Error: JSON:{    "Type": {        "value": "PMT"    },    "ReferenceNbr": {        "value": "PAY0001"    },    "Status": {        "value": "Balanced"    },    "ApplicationDate": {        "value": "2023-12-28T00:00:00+00:00"    },    "PaymentRef": {        "value": "nugsl - INTEGRATED_ATM - 2023-12-28"    },    "CustomerID": {        "value": "C0001660"    },    "PaymentMethod": {        "value": "ATM"    },    "CashAccount": {        "value": "INTATMDSWC"    },    "Description": {        "value": "API Test."    },    "PaymentAmount": {        "value": 1400    },    "BranchID": {        "value": "01-DSWC"    },    "DocumentsToApply": [        {         

I am trying to insert a vendor record using the REST API. I am met with the following error message.    "error": "Inserting  'Vendor' record raised at least one error. Please review the errors.; DiscTakenAcctID: 'Cash Discount Account' cannot be empty.; DiscTakenSubID: 'Cash Discount Sub.' cannot be empty.; TaxUseVendorCurPrecision: The Use Currency Precision flag was set because the tax report precision is equal to the currency precision", The JSON I am sending looks like this.{         "note": {             "value": "Abhijit - Testing"         },         "Cash Discount Account":{"value":"5922"},         "Cash Discount Sub":{"value":null},         "AccountRef": {},         "APAccount": {             "value": "2000"         },         "APSubaccount": {             "value": "000"         },         "CashAccount": {},         "CurrencyID": {             "value": "USD"         },         "CurrencyRateType": {},         "EnableCurrencyOverride": {             "value": false         },    

I’m attempting to add a new Vendor via the REST API. I receive the error:DiscTakenAcctID: 'Cash Discount Account' cannot be emptyThis is a required field located under the GL Accounts tab. However, the field does not appear when getting the list of Vendors via the REST API. How should the JSON be structured to include this field when adding a new Vendor via the REST API?

We are exporting Bills into Acumatica from our application, and I have gotten that mostly working as expected.  A new requirement to pay bills electronically inside our system has come across my JIRA board, and I was wondering if anyone else had any experience posting a payment that has been made externally to Acumatica.  Would I just use the PaymentAPI?

Does anyone know of a way to use a single Rest API PUT request to both, create an SO, and allocate serialized items to the lines?I have a call structured like this:{ "CustomerID": {"value": "C000517"}, "Date": {"value": "2022-08-28T00:00:00"}, "Description": {"value": "Postman Test"}, "Details": [ { "DiscountAmount": {"value": 10.00}, "ExtendedPrice": {"value": 2000.00}, "FreeItem": {"value": false}, "InventoryID": {"value": "TestItem"}, "OrderQty": {"value": 1.00}, "UnitPrice": {"value": 2000.00}, "UOM": {"value": "EA"}, "WarehouseID": {"value": "MAIN"}, "Allocations": [ { "SplitLineNbr": {"value": "2"}, "Allocated": { "value": true }, "AllocWarehouseID": { "value": "MAIN" }, "InventoryID": {

Hi everyone, I'm encountering an unusual issue when making an API call with the 23.202 build. I'm trying to change a sales order on hold status using the PutOnHold action, but I'm immediately receiving the following error. Once this error occurs, the subsequent GET call is also not functioning and getting the same error message.   "message": "An error has occurred."    "innerException": {        "message": "An error has occurred.",        "exceptionMessage": "A data corruption state has been detected. You cannot save the changes. Copy the data you have entered and reload the page. Date and Time: 2023-12-13T08:08:38; IncidentID: 8f01c121-fd44-4af9-bf02-6144bb6678c1; Name: Aggregate Validation: PX.Objects.SO.SOOrder+openLineCntr. You can view detailed information about the issue on the System Events tab of the System Monitor (SM201530) form.",        "exceptionType": "PX.Data.PXException",        "stackTrace": null Does anyone face this issue? 

Hello all, Just got our cloud instance up and a Second tenant  called “Demo Data Sandbox Tenant”Trying to Auth with the rest API and I get a 500 error “    "message": "An error has occurred.",    "exceptionMessage": "Current user cannot send API requests.",    "exceptionType": "PX.Data.PXException",” I am using this in my body{ "name" : "*************", "password" : "*****************", "tenant": "Demo Data Sandbox Tenant", "branch": "" } and URL is https://***********.acumatica.com/entity/auth/loginI have a local instance that I have been using for the API with no issues. Is there something I am missing for Multi Tennant?  User is an admin. Can log into the GUI no problem. Thank you

This past weekend, we just upgraded to Acumatica 2023 R1 (23.111.0019). We have an Excel app that retrieves some information from a Generic Inquiry through an OData request. It uses a specific account we created just for OData, so disregarding who is using it, it ends up submitting the request using this OData account.We’re aware of a known issue related to OData on our new version of Acumatica, but the error mentioned in the post is not exactly what we’re receiving as a response. And OData requests are actually working for some users.Everything has been working fine until after the upgrade, when we realized that the Excel app stopped working only for some users. We haven’t found a cause for this but we’re sure it’s not related to IP filters or individual account rights. For the users not able to use it, it returns the following error:{  "odata.error":{    "code":"","message":{      "lang":"en-US","value":"An error has occurred."    },"innererror":{      "message":"en-us\r\nParameter n

Hello Team, We are working on the following APIs and facing the issue as data not getting updated to the screen, even though the status is Success with 200 code. Custom Endpoint created for Endpoint for Restriction Group by Subaccount (GL104030):  Requirement  is to update groups for Subaccount API to select the Group names and save by passing the Subaccount ID and the Group name via API (Postman)   Endpoint for Journal Transaction screen (GL301000):Requirement is to reverse the Journal transaction entry. We have added the action to the standard Endpoint. Same issue here as well, call is success with 204 code but transaction is reversed. (Please confirm if its feasible or not Thanks & Regards,Vidyakeerthi K

I try to connected application and I receive authorization code but when I try to get access token, it show error I follow this document 

Hi guys,Any ideas, maybe one of us has had a similar problem to mine.I want to obtain the PDF file that I have uploaded on the Invoices and Notes screen "AR301000" by consulting through postman, the acumatic version is 2019R21.- I was able to insert using postman, here is the result. The postman's query and response failed.I hope I have been clear, maybe my English is not correct.Could you tell me what I'm doing wrong, I would appreciate it, thank you very much.

I need to know the endpoint to get the employee branch field.  This endpoint: {{testacuBaseUrl}}/Employee/C15315Just gives these fields:{    "id": "35029378-2110-ec11-89fc-000d3ac574da",    "rowNumber": 1,    "note": {        "value": ""    },    "EmployeeID": {        "value": "C15315"    },    "EmployeeName": {        "value": "Jason Olschewski"    },    "LastModifiedDateTime": {        "value": "2023-10-05T17:28:43.78-06:00"    },    "Status": {        "value": "Active"    },    "custom": {}}I’ve tried to expand the BAccount but it returns an error.I am currently using Build 21.212.0039

HiI exported a customization project with a connected application from version 2022R1and while import it into 2021R1 I got an error “Unknown tag OAuthClient” I assume its an issue with the version difference.Is there any option to export a customization project for an older version ?Do I need to have a customization project for each version ? 

Hello All,We have been working on some API connections and whenever i try to build up a connection using my Acumatica credentials, its gets connected and running but then the Acumatica ecosystem logs me out. How can I resolve this issue?Thanks in advance.

Hai, i have issue .The initial alternate was "PP001" and I wanted to change it to PP002, but what happened was not updating but adding a new line.so how do you want to update not add a new line in crossreference with the API?please help me, thank youurl : {{base_url}}/ExtendEndpoint/22.200.001/StockItem?$expand=CrossReferences&$filter=InventoryID eq 'FG34132'body :{    "CrossReferences": [        {            "VendorOrCustomer": {                "value": "DR00OPPP"            },            "AlternateType": {                "value": "Customer Part Number"            },            "AlternateID": {                "value": "PP002"            },            "UOM": {                "value": "PIECE"            },            "Description": {                "value": "PP002"            }        }    ] 

I’m not sure if this is possible or not. Does anyone know how to get a check copy image via the API? I know Acumatica generates the check copies via batch. But once its done, it does not store the check copy images. I would like to programmatically save each check copy. Has anyone done this before?   

Hi all, We’re still in implementation and I’m testing out the creation of Stock Items through the APIs. Back when we had two segment Item Classes, I had no trouble creating Stock Items. However, now that we’re testing out 5 level Item Classes, I’m having trouble finding the right ItemClass to send through the API. I keep getting “...cannot be found” on the Item Class object.For example, here is a class from the Acumatica view:  ONS.PIPE____.__REG___.________.___I’ve tried passing multiple combinations of that class. What is odd is when I query the stock item with that class, this is the output: I’ve tried using that string as an input also. Any help is greatly appreciated. 

Hi all, I am trying to create a customer using the rest API. I am not sending a CustomerID as I have the auto numbering turned on. It works great in the UI and Auto number works correctly. With the API it seams to just keep editing the same customer and not assigning a new ID.  It uses <NEW> for the customer id.  Am I missing a setting? Endpoint: http://localhost/AcumaticaERP/entity/Default/22.200.001/Customer Payload:{ // "CustomerID": {"value": "Cust04"}, "CustomerName": {"value": "Jane Dough"}, "CustomerClass": {"value": "Local"}, "SendDunningLettersbyEmail":{"value":false},"MainContact" : { "Email" : {"value" : "demo@gmail3.com" }, "Address" : { "AddressLine1" : {"value" : "40331 Lake Washington Blvd NE" }, "AddressLine2" : {"value" : "Suite 1030" }, "City" : {"value" : "Kirkland" }, "State" : {"value" : "WA" }, "PostalCode" : {"value" : "98033" } } } } 

Hello,I’m looking for a way to retrieve the Related Items from the Acumatica APIs. Is there any way to do this? I expected that I would be able to find it on the /entity/Default/20.200.001/StockItem API but it does not appear to exist as a detail object.

I’m writing a script to automatically process electronic invoices that come in through email and perform several actions after parsing up the invoices and extracting information from them.  I’m kind of new to REST API (I am very familiar with SQL) and so I was wondering how I could write a query that would return the InventoryID of the item based off 1) UPC (barcode) or 2) vendor and vendor code/alternate ID, which are things that are typically included on invoices.  My code is below: Private Sub test()  Dim ResponseText As String     If RESTQuery("Default/22.200.001/StockItem?$expand=CrossReferences&$select=InventoryID&$filter=CrossReferences/VendorOrCustomer%20eq%20'V000000247'%20and%20CrossReferences/AlternateID%20eq%20'8836'", ResponseText) <> 0 Then    Debug.Print "Query failed!"  Else    Debug.Print "Query successful!"  End IfEnd Sub The first part of the error message that is returned is: {"message":"An error has occurred.","exceptionMessage":"The parent value for

I am trying to write an Excel VBA macro to change Inventory IDs.  On a stock item’s page, there is a Change ID option, where I can do it manually.  I’d like to do something like this: Sub TestChangeInvID(ByRef Cookie1 As String, ByRef Cookie2 As String)  Dim Headers(4, 2) As String, Body As String, ResponseHeaders As String, ResponseText As String   Headers(1, 1) = "Accept"  Headers(1, 2) = "application/json"  Headers(2, 1) = "Content-type"  Headers(2, 2) = "application/json"  Headers(3, 1) = "Cookie"  Headers(3, 2) = "ASP.NET_SessionId=" & Cookie1  Headers(4, 1) = "Cookie"  Headers(4, 2) = ".ASPXAUTH=" & Cookie2  Body = "{""entity"" : {""InventoryID"" : {""value"":""MYITEM""}},""parameters"" : {""InventoryID"" : {""value"":""MYITEM1""}}}"   If SendData("POST", "https://alaskansales.acumatica.com/entity/Default/22.200.001/StockItem/ChangeID", Headers, Body, ResponseHeaders, ResponseText) = 204 Then    Debug.Print "Success!"  End IfEnd Sub It doesn’t work, I am guessing because

Is there a way to send an array of StockItem properties (including Attributes) so I can update more than one StockItem for each PUT operation?  Currently, I’m using the following URL:https://site.com/entity/Default/22.200.001/StockItemThe body that works for a single update consists of just one InventoryID:{    "InventoryID": {        "value": "12-3456"    },    "Attributes": [        {            "AttributeID": {                "value": "Color"            },            "Value": {                "value": ""            }        }    ],    "Content": {},    "PriceClass": {        "value": "TESTCLASS"    },    "custom": {        "ItemSettings": {            "BaseItemWeight": {                "type": "CustomDecimalField",                "value": 2.000000            },            "BaseItemVolume": {                "type": "CustomDecimalField",                "value": 0.000000            }        }    }    }I’ve tried putting an array ([ .. ]) around this one set but I keep getting the follo