Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the connector beyond simple SELECT 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 Power BI Connector 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. |
| 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. |