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 Dynamics 365 Stored Procedures


Name	Description
CreateAssociation	Creates an association between two entities based on a navigation property. Set the IncludeNavigationProperties connection property to true in order to use this stored procedure.
CreateSchema	Creates a schema file for the specified table or view. Note: This stored procedure only applies when Edition is set to either FinOpsOnline, FinOpsOnPremise or HumanResources.
GetAdminConsentURL	Gets the admin consent URL that must be opened separately by an admin of a given domain to grant access to your application. Only needed when using custom OAuth credentials.
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.
ListAssociations	Lists associations for a given table and navigation property. Set the IncludeNavigationProperties connection property to true in order to use this stored procedure.
ListNavigationProperties	Lists navigation properties for a given table and the tables they are associated with. Navigation properties are used by the Association stored procedures. Set the IncludeNavigationProperties connection property to true in order to use this stored procedure.
RefreshOAuthAccessToken	Obtains an updated OAuthAccessToken if passed a token to refresh.
RemoveAssociation	Removes an association between two entities based on a navigation property. Set the IncludeNavigationProperties connection property to true in order to use this stored procedure.