Develop Integrations with Web Services | APIs

Hello AcuCommunity !I’m wondering if someone knows where can I find some resources or examples about a direct Integration in Acumatica. (How Acumatica Interacts with API services, Working with XML / SOAP ). Thank you for all your Knowledge!

I am using the customization project function. To insert my data into the database with the tables as updateFile and UploadFile when I Publish. So I wrote a script to be able to insert the data into the database script section.. But I got a message from Acu's support team that I can't do it this way. So is there any other way for me to help fulfill the above requirement?

Hi all, Is there a way to switch branches for the account used for Oauth? Our vendors are set up with Restricted company groups. When our api automation tries to create a Bill the user used in the Oauth authentication, it is set to one of our 10 branches, so the Bill PUT fails due to the branch being incorrect. During the automation we'll need to switch branches. I looked for a profile endpoint to maybe use and switch branches using the api, but didn't see one. Thoughts?Thanks!

Hi,In the field service management module, there is an option available to the technician to capture customer signature from mobile app which is then uploaded to the appointment screen.I am building an application which needs to do the same, hence I am looking for REST API call details to be able to capture and attach signature to the appointment.I did not find any relevant actions in the web service endpoint. See below. Thanks,Rajesh Mishra

Hi,I am unable to find the actions for few of the options which are available from the appointment screen but missing in web service endpoint. Please let me know what am I missing here.I am looking for endpoint actions for Hold Schedule on Calendar Depart CloneActions available from the appointment screen: Appointment Screen ActionsActions available in web service endpoint:Appointment Web Service Endpoint 

After a couple of rounds of trying to “PUT” records into the Stock Item that have the # symbol I’m beginning to think the API framework doesn’t accept special characters. Can someone confirm this? I’m using Power Automate Desktop to invoke the web service and insert stock items. I’ve tried the Replace Text action  (replace # with %%23 also replace # with \#), none of which work. Thanks in advance!

Hi Team,I am geting this exception while trying to add an employee with payment instructions using an endpoint.I cannot see the DetailValue property when I try to check the swagger documentation.Thanks 

We upgraded to 23R1 and our tax override code described in this old post stopped working.  We also tried extending the web service endpoint and included the new field "DisableAutomaticTaxCalculation" in 23R1 and this did not help either.Here is what the sample json: { "OrderType": { "value": "SO" }, "CustomerID": { "value": "AMAZONG" }, "Description": { "value": "Amazon Order" }, "Details": [ { "InventoryID": { "value": "ITEM1" }, "OrderQty": { "value": 1.0 }, "UOM": { "value": "EA" }, "UnitPrice": { "value": 9.99 } } ], "TaxDetails": [ { "TaxID": { "value": "MANUAL" }, "TaxableAmount": { "value": 9.99 }, "TaxAmount": { "value": 1.00 } } ], "TaxTotal": { "value": 1.00 }, "FinancialSettings": { "OverrideTaxZone": { "value": true }, "CustomerTaxZone": { "value": "MANUAL" }, "DisableAutomaticTaxCalculation": {

Hello everyone,I extended  an endpoint for point of sale, I am able to fetch the data that I need very well from postmansee below. However, when I try to update any detail , I get the following error,see below how I’m trying to update line description to “TEST” I get the above/following error{ "message": "An error has occurred.", "exceptionMessage": "Unable to cast object of type 'PX.Data.PXResult`2[IGFS.DAC.IGFSQuickOrder,PX.Objects.AR.Customer]' to type 'IGFS.DAC.IGFSQuickOrder'.", "exceptionType": "System.InvalidCastException", "stackTrace": " at PX.Data.Events.FieldSelecting`2.get_Row()\r\n at IGFS.GraphExtensions.IGFSCreatePaymentExt._(FieldSelecting`2 e)\r\n at PX.Data.PXFieldSelecting.Invoke(PXCache sender, PXFieldSelectingEventArgs args)\r\n at PX.Data.PXCache.OnFieldSelecting(String name, Object row, Object& returnValue, Boolean forceState, Boolean externalCall)\r\n at PX.Data.PXCache.RaiseFieldSelecting(String name, Object row, Object& returnValu

Hi team, I hope everyone is doing well, I would like to know if there is a way to customize a custom entity created in an Acumatica Instance through REST API.Please see an example below of the Entity I created, As you can see, this is a Custom Entity with a custom name and is basically a summary from different tables. I use this table to create a Generic Inquiry for other reports but, the Fields Forecast should come from a third party software that I have.   I tried to create a Custom Endpoint but I didn’t know how to link this table to an screen or how to map the fields from the entry. If you can help me with some links or something I can refer to know how to solve question.  Thank you so much in advance!

Hello,I am running into an issue with Salesforce Sync Data Provider and export scenario for business accounts.In Salesforce, there are Person Accounts and Accounts. They are very similar except Person Accounts require the Last Name, and Accounts require just “Name” The problem I am having, is the default export scenario is setup to only export the ‘Account Name’ to the “Name” field, and will fail on person accounts due to their not being a “Last Name” field provided. Is there a way on one export scenario, I can still have both fields exporting to avoid errors and still get to export both account types? If I add the Last Name field, it causes normal accounts to fail due to the Last Name field. 

I’m a little confused with the OAuth logout method. I have the login/token method working, but once the token is issued and the api’s are finished do I need to post a logout? Or can I continue to use that token for subsequent calls. Also, if I need to logout, what do I pass? I see the methods in the videos about Postman, but I’m using Power Automate Desktop actions for the automation. Thanks!

Hello,I have successfully created a postman script that takes a csv reference file (Itemcd, filename) and creates the images (stored and referenced from a local source) in Acumatica on a stock item. I then set that image as the ImageURL, however, when I log into the system to check, the file is uploaded, the imageurl is updated, however, the image preview is not showing the image. What entity do I need to call to set this? I figure I could get the data in there and even if it isn’t available via api, I could do some event handler to finish it all the way.. thanks in advance!  

Hi I am new to Acumatica. I would like to know how to pull all the Sales Quotes using the postman. If someone can provide a API signature i would be greatful.

Hello all, We will be using the api’s to create new stock items as needed. Does Acumatica have the ability to accept a PUT command to Stock Items with multiple records? Or should we just loop through the needed records and create them individually? Thanks

I am trying to access the Ship-to Address information seen on the invoice Addresses screen here:However I don’t see an available endpoint for that in the API. How do I pull this info in the API?  

When i call Sales Orders API and put the data in the body when i execute the Request i Get 500 Status code with "exceptionMessage":"Object reference not set to an instance of an object."but when i put the same data manually the order saves normally.anyone faced this problem before ?Below is the StackStack Trace For http://Websiteserver/siteName/entity/Integration/18.200.001/SalesOrder 

I am trying to create a new customer in Acumatica using the API URL https://acumatica.ipaas.com/AcumaticaERP/entity/default/22.200.001/Customer. The request body that I am using is as follows:{ "CustomerID": {"value": "Checking2"}, "CustomerName": {"value": "Aurangzeb"}, "CustomerClass": {"value": "LOCAL"}, "StatementCycleID": {"value": "EMO"}, "DiscTakenAcctID": {"value": "CHECKING"}}However, I am getting the following error message:"error": "Inserting 'Customer' record raised at least one error. Please review the errors.; DiscTakenAcctID: 'Cash Discount Account' cannot be empty."The DiscTakenAcctID field in the request body is set to the ID of a valid cash discount account. I am not sure why I am getting this error.Can anyone help me troubleshoot this issue?

Does anyone know how or if it is even possible to set the Comments when uploading a file via the API? 

{ "Date": { "value": "2022-05-12T00:00:00+00:00" }, "PostPeriod": { "value": "062022" }, "Description": { "value": "2022-05-12T00:00:00+00:00" }, "Details": [ { "InventoryID": { "value": "SAM-GAL-NOT-5-32" }, "Warehouse": { "value": "IMMDFW" }, "ReasonCode":{ "value": "IN RECEIPT" }, "LineDetails": { "LotSerialAttributes": [ { "Attribute": { "value": "ASSETTAG" }, "Value": { "value": "Passed000ggg" }, "custom": {} } ], "LotSerialNbr"

I am trying to add contact info in leads API. With the following URL and body. But it is giving an error  "Last Name or Account Name (or both) should be filled in." Can anyone help me here please. http://localhost/MyInstance/entity/Default/22.200.001/LeadBODY:{ "ContactID" : {"value" : "Param"}, "Description" : {"value": "My Test Lead"}, "Source": {"value": "W"}, "CRM Info":[{ "Contact Preferences":{ "FirstName": {"value": "Param"}, "LastName": {"value": "Test"} } }]} 

hello everyone,I have extended a default endpoint to include users. I am able to fetch details from the summary area using a get request on postman. However, I have tried to pull roles of specific users but I’m just getting errors.Kindly assist on how I can fetch and manipulate roles of a specific user using rest api on post man. all responses will be highly appreciated. Thank you 

Hi,How I can filter a custom GI using Rest API?Thanks,EV

I am attempting to get the Tax Rate from a SalesInvoice.I have created a custom field - in SalesInvoice->TaxDetails I added TaxRate with the Mapped Object Taxes and the mapped field Tax Rate.I am calling this field, and others with a GET request to the following:/entity/[My Custom Endpoint]/22.200.001/SalesInvoice?%24filter=CustomerOrder%20eq%20'nnnnnnnnnnn'&%24expand=Details,TaxDetails&%24select=CustomerID,CustomerOrder,ReferenceNbr,Description,Amount,Status,Details%2FOrderNbr,TaxDetails%2FTaxRateWithout my custom field in the URI the result is as expected.With my custom field I get: "Optimization cannot be performed.The following fields cause the error:\r\nTaxDetails.TaxID: View Taxes has BQL delegate\r\n",How can I get the data from my custom field? Or, do I need to set the custom field up differently?

Through web api not able get vendor order by LastModifiedDateTime.