Develop Integrations with Web Services | APIs

'{"error":{"code":400,"details":[{"@type":"type.googleapis.com/google.rpc.ErrorInfo","metadata":{"action_name":"CreateAttachment","cause":"Invalid input for attribute Content to operation CreateAttachment.rsb, only InputStream is allowed.","connection_type":"Acumatica"}}],"message":"Unable to execute the specified action.","status":"FAILED_PRECONDITION"}}' We have been trying to pass CreateAttachment action, but it displays the following error. What kind of InputStream shall we provide? Any Ideas?

Hi Everyone.Is it possible for me to add a second statement in Acumatica? The first statement type would be the open statements. The second would be the balance brought forward. The open balance statement would be the default. I would then want to be able to generate a second balance brought forward statement and send both to the customer.Any ideas on how I could set this up?

I want to create a custom button and call it using the postman. I tried it with the "CreatePayment" button. But it doesn't work  Is it possible to do this? 

Good day. We’re having a bit of a struggle determining the naming of entities in order to extract the relevant information via api calls. Example: We are trying to expand/extract the Ecommerce Data tab field “description”. Where exactly can we look to find the naming of this entity to expand? Will appreciate any guidance.Thank you     

I am trying to get the Purchase Receipts and Purchase Orders filter by Date using RestAPI in postman, please provide me some example.

Hi Everyone,I'm trying to override the currency rate on a payment via the REST API.I can do this no worries in the UI however I'm struggling to get the API to do it.I've attempted to extend the endpoint to add the CurrencyRate field however this isn't making a difference, the payment will still create however it will just use the regular exchange rate.Does anyone know how to get this working? 

Hi everyone,I recently set up a new instance in MYOB Advanced and extended a new endpoint specifically for managing Purchase Orders. I'm trying to complete a purchase order through this endpoint, but I keep encountering an error. I'm hoping someone might be able to shed some light on this issue.Endpoint and Request: I'm sending a POST request to:POST http://localhost/MyStoreInstance7/entity/Default/1.1/PurchaseOrders/CompleteProcessingCategoryWith the following JSON body:{  "entity": {    "OrderNbr": "PO001326"  }}Response: However, I'm receiving a 500 Internal Server Error with the following details:{    "message": "An error has occurred.",    "exceptionMessage": "Operation failed",    "exceptionType": "PX.Data.PXInvalidOperationException",    "stackTrace": "...",    "innerException": {        "message": "An error has occurred.",        "exceptionMessage": "The Complete Order button is disabled.",        "exceptionType": "PX.Data.PXActionDisabledException",        "stackTrace": "..." 

Hi Forum, I recently created a Generic Inquiry and then Created an Entity on the Web Services panel extending the default endpoint. I followed the steps on this link: https://www.acumatica.com/blog/contract-based-apis-in-generic-inquiries/. The Guide works perfect, I could create the entity, I could retrieve the data using a Put method on Postman and everything seems fine, But, Now if I tried to filter the data using the information from one of the fields in the Results (The ProjectID). I can not filter the information. I tried to use the next query but it gives me the error shows in the image below: Query working:  Query not working:  My intention is not to just get the information in the Generic Inquiry, I can do that very easy with the Generic Inquiry directly, my end goal is to be able to update data on the Generic Inquiry. I want to update one field from the table I’m using in the Generic Inquiry. Please your help to know if I’m doing something wrong on my Query on Postman that I

Hello Community,I have been searching out for APIs related to Emails. Can anyone guide me out where can I find one? or any references.Thanks in advance.

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? 

In case we have:A store on eBay that we connect to from Shopify using Shopify Marketplace Connect App.  Our Shopify Online store Acumatica ERP.Will we be able to connect to our eBay Store via the native Shopify Connector and synchronize our product listings between both Shopify and eBay stores i real-time using Shopify Connector for integration with the ERP?

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.