Stored Procedures

Stored procedures are function-like interfaces that extend the functionality of the server beyond simple SELECT/INSERT/UPDATE/DELETE 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 Code Assist MCP for Microsoft Dynamics CRM Stored Procedures


Name	Description
Assign	Assigns a record to a specified user or team. The Table parameter specifies the entity type, and the AssigneeType parameter accepts either 'User' or 'Team'.
AssociateRequest	Associates two entities via a named relationship. The RelationshipName must be a valid relationship name defined in Dynamics CRM.
CreateSchema	Creates a custom schema file based on the CRM View name, FetchXML expression, or SQL query. If Query is not specified, the TableName should be set to an existing CRM View name.
DisassociateRequest	Removes an association between two entities via a named relationship. The RelationshipName must be a valid relationship name defined in Dynamics CRM.
ExecuteWorkflow	Executes a workflow on a specified entity. The WorkflowId must be the GUID of an activated workflow in Dynamics CRM. The procedure returns the Id of the resulting AsyncOperation.
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 status of a record. The StateCode and StatusCode values can be either names (e.g., 'Won') or numeric codes (e.g., '1'), depending on the UseNameForPicklistValue connection property.
UpdateRequest	Updates a record using JSON-formatted attributes. This is useful for complex updates that involve multiple attribute types, including OptionSetValue and EntityReference.