ストアドプロシージャ
ストアドプロシージャはファンクションライクなインターフェースで、ServiceNow の単純なSELECT/INSERT/UPDATE/DELETE 処理にとどまらず本製品 の機能を拡張します。
ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにServiceNow から関連するレスポンスデータを返します。
CData Code Assist MCP for ServiceNow ストアドプロシージャ
| Name | Description |
| AddToCart | Adds a specified item to the current user's cart in the Service Catalog. |
| CreateRecord | Inserts a new record into a specified ServiceNow table. |
| CreateSchema | Creates a schema file for a specified table or view, saving it to the directory defined in the 'Location' connection property. |
| DeleteRecord | Deletes a specified record from a target table in ServiceNow. |
| DownloadAttachment | Downloads a file attachment from a specified record. |
| GetAllRecords | Retrieves records of the target table in ServiceNow. |
| GetOAuthAccessToken | Gets the OAuth access token from ServiceNow. |
| GetOAuthAuthorizationURL | Gets the Service Now 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 Service Now. |
| GetRecord | Retrieves a specified record from a target table in ServiceNow without requiring metadata permissions. |
| GetTableSchema | Generates a JSON schema for a specified table to describe its structure and field definitions. |
| RefreshOAuthAccessToken | Refreshes the OAuth access token used for authentication with various ServiceNow services. |
| SubmitOrder | Submits the current user's cart order based on the configured checkout process. |
| UpdateRecord | Updates an existing record in a target table in ServiceNow. |
| UploadAttachment | Uploads a file as an attachment to a specified record. |