Develop Integrations with Web Services | APIs

Is there a way to pull the AR and AP Aging reports through the rest API? Specifically these are the reports I’m referring to:  

HelloI’m trying to use a webservice endpoint with StorageDetailsInquiry and StorageDetailsLocationInquiry to get all the inventory from a specific warehouse, but it seems that those endpoints only give me the first row of data from each InventoryID if there are multiple lots worth of data.I’ve attached screenshots of the inventory rows that I need and my postman response when I try to get those rows.The endpoint we are using is /StorageDetailsInquiry?$expand=StorageDetailsHas anyone else had issues with this? Thanks

I have a sync going where I am trying to do “delta” loads of different types of data from Acumatica. I am extracting certain entities for use in an external customer facing eCommerce website. What is the best method I should use to make sure I am getting the latest data. For instance, If I run a sync every hour, how to I go about ensuring I get the latest records (ie: SalesOrder, Invoices, StockItems, etc.)I have GI’s created for them all which work well. My approach right now is to use the “LastModifiedOn” date and load records based on that. I then page through those result sets (if needed).  Sometimes we need to do a full resync or “hydration” of a new entity….so I sync in nested batches.Psudeo code isLastModifiedOn ge 09/14/2023 and LastModifiedOn le 09/15/2023 $top=100, $skip=100 (page 2) Inside of that, I will page if needed.I am not confident I am doing this the best and most efficient way. I wanted to ping the broader community to see if there may be a better approachThank you

Hi,I’m able to use the API to retrieve data from a GI exposed via an extended web service endpoint.I’ve been following the steps from multiple sources, being this the most complete:When I try to pass the filter in the body, I get the same results as if I pass a blank body: {} returning all the data unfiltered.I realized that I don’t have the “filter” option (used in the post above) when I click on Populate, at the top entity level:I am using Acumatica 2023 R1.Did this process change in this version of Acumatica?Am I missing something to configure through the GI instead?Any help will be much appreciated.Thanks!J Chavez

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"} } }]}