Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the add-in 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 Excel Add-In 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. |