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 the specified item to the cart of the current user. |
| CreateRecord | Inserts the specified record into the target table in ServiceNow. |
| CreateSchema | Creates a schema file for the specified table or view. It you specify 'Location' connection property, the schema file will be created in the directory it addresses. |
| DeleteRecord | Deletes the specified record into the target table in ServiceNow. |
| DownloadAttachment | Download a file attachment from a specific record. |
| 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 the specified record of the target table in ServiceNow. |
| GetTableSchema | Creates a JSONSchema of the target table in ServiceNow. |
| RefreshOAuthAccessToken | Refreshes the OAuth access token used for authentication with various ServiceNow services. |
| SubmitOrder | Checks out the user cart, based on the current check-out type (one-step or two-step). |
| UpdateRecord | Updates the specified record into the target table in ServiceNow. |
| UploadAttachment | Upload a file as an attachment to a specified record. |