ストアドプロシージャ

ストアドプロシージャはファンクションライクなインターフェースで、Microsoft Dynamics CRM の単純なSELECT/INSERT/UPDATE/DELETE 処理にとどまらず本製品の機能を拡張します。

ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにMicrosoft Dynamics CRM から関連するレスポンスデータを返します。

CData Code Assist MCP for Microsoft Dynamics CRM ストアドプロシージャ


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	Dynamics CRM Online 認証で使用されるデバイス名とパスワードを生成します。これは現在非推奨です。
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	セキュリティトークンサービスのアドレスを取得します。
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.