ストアドプロシージャ
ストアドプロシージャはファンクションライクなインターフェースで、Microsoft Dynamics 365 の単純なSELECT/INSERT/UPDATE/DELETE 処理にとどまらず本製品 の機能を拡張します。
ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにMicrosoft Dynamics 365 から関連するレスポンスデータを返します。
CData Cmdlets PowerShell Module for Microsoft Dynamics 365 ストアドプロシージャ
| Name | Description |
| CreateAssociation | Creates an association between two entities using the specified navigation property. This procedure is essential for linking related entities dynamically and requires the IncludeNavigationProperties connection property to be enabled. |
| CreateSchema | Generates a schema file for a specified table or view, providing a structural blueprint for data organization. |
| EnableChangeTracking | Enables change tracking on an entity, allowing incremental updates and efficient data synchronization. Note: This feature is irreversible once activated. |
| GetAdminConsentURL | Retrieves the admin consent URL required for granting domain-wide access to the application by an administrator. Necessary when using custom OAuth credentials. |
| GetOAuthAccessToken | Fetches the OAuth Access Token, which is used to authenticate and authorize API calls made to Dynamics 365. |
| GetOAuthAuthorizationUrl | Retrieves the OAuth Authorization URL, allowing the client to direct the user's browser to the authorization server and initiate the OAuth process. |
| ListAssociations | Lists all associations for a specified table and its related navigation properties. Requires the IncludeNavigationProperties connection property to be enabled. |
| ListNavigationProperties | Displays the navigation properties for a specified table, showing their relationships with associated tables. Useful for defining entity associations and dependencies. |
| RefreshOAuthAccessToken | Refreshes an expired OAuth Access Token to maintain continuous authenticated access to Dynamics 365 resources without requiring reauthorization from the user. |
| RemoveAssociation | Deletes an association between two entities based on a specified navigation property. This requires the IncludeNavigationProperties connection property to be enabled. |