ストアドプロシージャ
ストアドプロシージャはファンクションライクなインターフェースで、Vault CRM の単純なSELECT 処理にとどまらず本製品 の機能を拡張します。
ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにVault CRM から関連するレスポンスデータを返します。
CData Power BI Connector for Vault CRM ストアドプロシージャ
| Name | Description |
| CreateDocument | Create a single document. |
| CreateDocumentVersion | Add a new draft version of an existing document. You can choose to either use the existing source file, or a new source file. These actions will increase the document's minor version number. This is analogous to using the Create Draft action in the UI. Note that not all documents are eligible for draft creation. For example, you cannot create a draft of a checked out document. |
| CreateSchema | Creates a schema file for the specified table or view. |
| DownloadDocumentFile | Download a document file. |
| GetOAuthAccessToken | Gets the OAuth access token from the Azure AD Authentication Provider. |
| GetOAuthAuthorizationURL | Gets the Azure AD authorization URL. Access the URL returned in the output in a Web browser. This requests the access token that can be used as part of the connection string to the Azure AD Authentication Provider. |
| RefreshOAuthAccessToken | Refreshes the OAuth access token used for authentication with the Azure AD Authentication Provider. |
| UpdateDocument | Update editable field values on the latest version of a single document. Deprecated - Perform Update on Documents table instead. |