CData Excel Add-In for OData 2019 - Online Help
Questions / Feedback?

Stored Procedures

CData Excel Add-In for OData 2019 - Build 19.0.7354

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 OData 2019 Stored Procedures

Name Description
CreateAssociation Creates an association between two entities based on a navigation property.
GetOAuthAccessToken Gets the auth token used to authenticate to the service.
GetOAuthAuthorizationUrl Gets an authorization URL from the data source. The authorization URL can be used to generate a verifier required to obtain the OAuth token.
GetSAPCSRFToken Returns a CSRF token and cookie for authentication to SAP.
ListAssociations Lists associations for a given table and navigation property.
ListNavigationProperties Lists navigation properties for a given table and the tables they are associated with. Navigation properties are used by the Association stored procedures.
RefreshOAuthAccessToken Obtains an updated OAuthAccessToken if passed a token to refresh.
RemoveAssociation Removes an association between two entities based on a navigation property.
Search Searches OData using the given URL.

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