Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the connector beyond simple SELECT operations with Bullhorn CRM.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Bullhorn CRM, along with an indication of whether the procedure succeeded or failed.
CData Power BI Connector for Bullhorn CRM Stored Procedures
| Name | Description |
| CreateSchema | Generates a schema file for a specified table or view. This stored procedure supports development and documentation workflows by exporting the structural definition of an entity. |
| DownloadFile | Downloads a file that is attached to a specified entity. This stored procedure supports document management by retrieving attachments that users need to review or archive. |
| GetOAuthAccessToken | Gets an authentication token from BullhornCRM. |
| GetOAuthAuthorizationURL | Gets the authorization URL that must be opened separately by the user to grant access to your application. Only needed when developing Web apps. You will request the OAuthAccessToken from this URL. |
| RefreshOAuthAccessToken | Use this procedure to refresh the access token. |
| UploadFile | Uploads a file to a specified entity. This stored procedure supports documentation workflows by allowing users to add attachments that enhance record completeness or compliance. |