Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the add-in beyond simple SELECT/INSERT/UPDATE/DELETE operations with ServiceNow.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from ServiceNow, along with an indication of whether the procedure succeeded or failed.
CData Excel Add-In for ServiceNow Stored Procedures
| 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. |