Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the connector beyond simple SELECT operations with Microsoft Dynamics CRM.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Microsoft Dynamics CRM, along with an indication of whether the procedure succeeded or failed.
CData Power BI Connector for Microsoft Dynamics CRM Stored Procedures
| Name | Description |
| Assign | Assigns an item to the specified user. |
| AssociateRequest | Executes an associate request. |
| CreateSchema | Creates a custom schema file based on the CRM View name, FetchXML expression, or SQL query. |
| DisassociateRequest | Executes a disassociate request. |
| ExecuteWorkflow | Executes an workflow request. |
| GenerateDeviceCredential | Generates the device name and password, which are used for Dynamics CRM Online authentication. This is currently deprecated |
| GetOAuthAccessToken | If using a Windows application, set Authmode to App. If using a Web app, set Authmode to Web and specify the Verifier obtained by GetOAuthAuthorizationUrl. |
| GetOAuthAuthorizationUrl | Gets the authorization URL that must be opened separately by the user to grant access to your application. |
| GetSTSUrl | Gets the address for the security token service. |
| RefreshOAuthAccessToken | Refreshes the OAuth access token used for authentication with AzureDataCatalog. |
| SetState | Sets the state and the status of the specified item. |
| UpdateRequest | Update an item to the specified user. |