Excel Add-In for Acumatica

Build 20.0.7633

Stored Procedures

Stored procedures are available to complement the data available from the Data Model. It may be necessary to update data available from a view using a stored procedure because the data does not provide for direct, table-like, two-way updates. In these situations, the retrieval of the data is done using the appropriate view or table, while the update is done by calling a stored procedure. Stored procedures take a list of parameters and return back a dataset that contains the collection of tuples that constitute the response.

CData Excel Add-In for Acumatica Stored Procedures

Name Description
GetOAuthAccessToken Gets the OAuth access token from Basecamp.
GetOAuthAuthorizationURL Gets the Acumatica authorization URL. Access the URL returned in the output in a Web browser.
RefreshOAuthAccessToken Refreshes the OAuth access token used for authentication.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7633