Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the driver beyond simple SELECT/INSERT/UPDATE/DELETE operations with HubSpot.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from HubSpot, along with an indication of whether the procedure succeeded or failed.
CData ODBC Driver for HubSpot Stored Procedures
| Name | Description |
| CreateCustomObject | Creates a custom object in HubSpot. Requires private-app token authentication if OAuth scopes are insufficient. |
| CreateCustomProperty | Adds a custom property to a HubSpot object, enhancing CRM data flexibility. |
| CreateSchema | Generates a schema definition file for a specified HubSpot table or view, aiding in documentation. |
| DeleteCustomObject | Deletes an existing custom object from HubSpot. private-app token authentication is recommended for insufficient OAuth scopes. |
| DeleteCustomProperty | Removes a custom property from a HubSpot object, streamlining data fields. |
| DeleteFile | Permanently deletes a file and all related metadata and thumbnails from HubSpot's file manager. |
| DownloadFile | Downloads a file from HubSpot's file manager. Requires appropriate file access scopes. |
| GetOAuthAccessToken | Retrieves the OAuth access token for authenticated API requests to HubSpot. |
| GetOAuthAuthorizationURL | Generates the OAuth authorization URL required for HubSpot API authentication. |
| RefreshOAuthAccessToken | Refreshes the OAuth access token used to maintain API session continuity in HubSpot. |
| UpdateCustomObject | Updates an existing custom object in HubSpot. May require private-app token authentication due to OAuth scope limitations. |
| UpdateCustomProperty | Modifies an existing custom property for a HubSpot object, supporting data customization. |
| UploadFile | Uploads a file to HubSpot's file manager for use in marketing or content purposes. |