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 Tableau Connector for Dynamics 365 Finance and Operations Stored Procedures
|CreateSchema||Creates a schema file for the specified table or view.|
|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.|
|RefreshOAuthAccessToken||Obtains an updated OAuthAccessToken if passed a token to refresh.|