Develop Integrations with Web Services | APIs

Technical discussions focused on Web Services and APIs for developers

  • 399 Topics
  • 1,675 Replies

399 Topics

H
Freshman I
hortegaFreshman I
asked in Develop Integrations with Web Services | APIs

"exceptionMessage": "The method or operation is not implemented.",

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

3
Naveen Boga
Captain II
3 hours ago
C
Freshman I
claudematherne24Freshman I
asked in Develop Integrations with Web Services | APIs

API into Google Sheets

Hey there everyone, Is there a way to connect a Google sheet into an Acumatica screen to get real time data?  

4
P
Freshman I
8 hours ago
E
Jr Varsity I
ericyzJr Varsity I
asked in Develop Integrations with Web Services | APIs

How to set premium freight price on Sales Order programmatically via API

Is it possible to send a total premium freight price value when creating a sales order?Below is the request we are sending but it does not work {"CustomerID":{"value":"855215____"},"FinancialSettings":{"Branch":{"value":"LOCAL"}},"CustomerOrder":{"value":"10"},"Details":[{"InventoryID":{"value":"CC-W0930"},"OrderQty":{"value":1},"UnitPrice":{"value":166},"custom":{"Transactions":{"UsrAssembled":{"value":true},"UsrHingePlacement":{"value":"Right"},"ManualPrice":{"value":true}}}},{"InventoryID":{"value":"ASSEMBLE"},"OrderQty":{"value":1},"UnitPrice":{"value":16.6},"custom":{"Transactions":{"ManualPrice":{"value":true}}}},{"InventoryID":{"value":"CUSTOM-CABINET"},"OrderQty":{"value":1},"UnitPrice":{"value":67.33},"custom":{"Transactions":{"ManualPrice":{"value":true}}}}],"Totals":{"PremiumFreight":{"value":175},"OverrideFreightAmount":{"value":true}}}  

9
Naveen Boga
Captain II
11 hours ago
C
Freshman I
chvakhilFreshman I
asked in Develop Integrations with Web Services | APIs

Inserting 'Sales Order Line' record raised at least one error.

Hi Team,  I am trying to push an SO. But getting this error while performing PUT on  https://<TEMP1>/<TEMP2>/entity/Default/22.200.001/SalesOrder Inserting  'Sales Order Line' record raised at least one error. Please review the errors.; UsrIndicatingUOM: ^Indicative UOM cannot be blank.; UsrIndicativeQty: ^Order Qty cannot be Zero. My Request Body:{ "OrderNbr": { "value": "<NEW>" }, "OrderType": { "value": "SO" }, "CustomerID": { "value": "T06708" }, "note": "", "CustomerOrder": { "value": "STG21002" }, "Details": [ { "note": "", "InventoryID": { "value": "0800000" }, "OrderQty": { "value": "1.0000" }, "MasterQty": { "value": "1.0000" }, "ManualPrice": { "value": true }, "UnitPrice": { "value": 125 },

2
L
Semi-Pro II
13 hours ago
J
Freshman II
jaysonFreshman II
asked in Develop Integrations with Web Services | APIs

Web Endpoint Services cant create endpoint for Recuring Transactions

I’m having issue creating Endpoint for Recurring TransactionsEndpoint: Fields: Postman Response: 

3
V
Acumatica Employee
13 hours ago
D
Freshman I
definitesteveFreshman I
asked in Develop Integrations with Web Services | APIs

Starting seeing this error in API response: An error has occurred while processing your request.

The response code is ok but I’m getting html returned in the response which contains the text: We're sorry! An error has occurred while processing your request. A report has been generated for our technical staff to investigate the problem. Please try to repeat your request later. Thank you for understanding. If I wait a few minutes and try again it works. In the System Monitor → System Events screen I can see that there are `Sign-In limit exceeded` events, however I can successfully create new login sessions so I don’t think that is the problem. 

5
L
Semi-Pro II
13 hours ago
G
Freshman I
gr24testFreshman I
asked in Develop Integrations with Web Services | APIs

Retrieve documents from API

Hello everyone, I’ve been wondering whether there is a way to retrieve documents through the API. Apparently there is no obvious way within the Default endpoint.For context: I am trying to listen to document creations to send a Push Notification to our service so I can download the document created.Thanks in advance!

2
G
Freshman I
19 hours ago
kyoung14
Jr Varsity II
kyoung14Jr Varsity II
asked in Develop Integrations with Web Services | APIs

File attachments to external system via API

We are going to implement an external system for crew and equipment scheduling for road construction/repair jobs.  Project Quotes will be created in Acumatica and converted to Projects.  At this point project info will be sent to this external system via an API/web service - that is all fine.  The challenge is that they also need any file (.pdf, .jpg, .xlsx, etc.) that was attached/linked to the Project in Acumatica to also be sent to this external system where it will be linked to the project there.  Is this possible?  Has anyone ever done anything like that before?  Another requirement from the receiving  system is that the files be converted to Base64 for use with their web service.I’m just curious to hear if anyone has done anything similar and to see what is even possible. 

2
Naveen Boga
Captain II
1 day ago
Omar Ghazi
Acumatica Moderator
Omar GhaziAcumatica Moderator
posted in Develop Integrations with Web Services | APIs

Microsoft Teams Integration Ready for Managed Availability! Searching for Customers

UPDATE: March 3, 2023Thank you to our partners and customers who signed up to try our Teams integration customization and provide feedback! As announced during the Summit 2023 Keynote session, Microsoft Teams integration will be available as part of the core product starting 2023 R1 as part of our new Experimental Features. We have made a lot of great improvements both in the integration as well as its usability. Yet we are just beginning.We will be ending the Managed Availability Program for Teams integration for any new requests. This means that if you were a partner or customer as part of the program, you can continue using the integration as a customization that was provided. However, support, ongoing maintenance, and support for future versions will no longer be available from April 4, 2023. We will continue to monitor this community site as well as our interaction with customers and partners to collect ideas and feedback to help improve our Microsoft Teams Integration (core).Sinc

39
manikantad18
Pro I
3 days ago
D
Freshman I
definitesteveFreshman I
asked in Develop Integrations with Web Services | APIs

How to access Accounts Receivable/Payable Aging reports via Rest API

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:  

1
K
Acumatica Employee
3 days ago
M
Freshman I
mvamvakasFreshman I
asked in Develop Integrations with Web Services | APIs

StorageDetailsInquiry and StorageDetailsLocationInquiry not giving enough inventory data

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

4
Chris Hackett
Community Manager
4 days ago
E
Jr Varsity II
eellistonJr Varsity II
asked in Develop Integrations with Web Services | APIs

How to Fetch Latest data from API

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

5
V
Acumatica Employee
4 days ago
J
Freshman II
jchavezFreshman II
asked in Develop Integrations with Web Services | APIs

How to filter an GI when exposed via Web Service EndPoint?

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

2
V
Acumatica Employee
4 days ago
A
Freshman III
AlexBFreshman III
asked in Develop Integrations with Web Services | APIs

Integration in Acumatica

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!

2
J
Semi-Pro III
4 days ago
E
Jr Varsity II
eellistonJr Varsity II
asked in Develop Integrations with Web Services | APIs

Rest API Logout

I have a bunch of .NET “jobs” that sync and pull data from Acumatica for use in an external eCommerce website.I often hit the login rate limit error and have been told to make sure I logout after each iteration. I call the /identity/connect/token endpoint and pass in my client_id, secret, API Username and API Password with the grant type of password. Its a typical oAuth flow. In testing via postman, I have logged in, did a simple GET query to return some data...then call the logout endpoint (with my bearer token). It returns a 204 success status code. /entity/auth/logout The issue is, I can go back and call the GET query to return some data. I would expect that my bearer token would be invalidated and that GET call would fail. However, it still works. This leads me to believe that I am not truly being logged out. I am reading that I need to pass in a cookie to the logout call, but I can’t really find out how that works. I am not used to working with cookies in a typical oAuth pattern. 

9
D
Freshman I
7 days ago
P
Freshman I
phatFreshman I
asked in Develop Integrations with Web Services | APIs

Cannot insert data using database scripts feature

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?

4
Joe Schmucker
Captain II
7 days ago
jamest
Freshman II
jamestFreshman II
asked in Develop Integrations with Web Services | APIs

Switching branches with Oauth

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!

7
Chris Hackett
Community Manager
9 days ago
R
Freshman I
rajeshmishra90Freshman I
asked in Develop Integrations with Web Services | APIs

REST API for capturing and uploading signature in appointment

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

1
Y
Jr Varsity I
13 days ago
R
Freshman I
rajeshmishra90Freshman I
asked in Develop Integrations with Web Services | APIs

Looking for missing actions endpoint in Web Service REST API for appointment screen

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 

1
Y
Jr Varsity I
13 days ago
jamest
Freshman II
jamestFreshman II
asked in Develop Integrations with Web Services | APIs

API and special characters

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!

4
Chris Hackett
Community Manager
15 days ago
K
Freshman I
kuldeepsinghFreshman I
asked in Develop Integrations with Web Services | APIs

"Inserting 'Payment Type Detail' record raised at least one error. Please review the errors.; DetailValue: 'Value' cannot be empty.",

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 

2
S
Acumatica Employee
15 days ago
I
Freshman I
ihe63Freshman I
asked in Develop Integrations with Web Services | APIs

Web Service Endpoints - Validate Endpoint fails

Hello,In the Web Service Endpoint screen in 2020/R1, when I click on Validate Endpoint for endpoint Default/18.200.001, it executes for about a minute, then fails with this exception:Exception of type 'System.Web.HttpUnhandledException' was thrown. PX.Data.PXNotEnoughRightsException: You don't have enough rights on 'Select'. …Can anyone please shed some light on what is happening?  

4
mawe4585
Freshman II
17 days ago
SBalmer1
Freshman I
SBalmer1Freshman I
asked in Develop Integrations with Web Services | APIs

Cant get Tax Override and new Disable Automatic Tax Calculation working with REST API and 23R1

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": {

4
SBalmer1
Freshman I
18 days ago
Michael Ndungi
Varsity I
Michael NdungiVarsity I
asked in Develop Integrations with Web Services | APIs

Unable to update record using Restful API

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

4
Michael Ndungi
Varsity I
18 days ago
H
Freshman I
hortegaFreshman I
asked in Develop Integrations with Web Services | APIs

Update Custom Entity

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!

4
J
Semi-Pro III
23 days ago

Badge winners

Show all badges
Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2023  Acumatica, Inc. All rights reserved