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 |
| CreateSchema | Generates a schema definition file for a specified HubSpot table or view, useful for metadata documentation. |
| DeleteFile | Permanently deletes a file and its associated data and thumbnails from HubSpot's file manager. |
| GetOAuthAccessToken | Retrieves the OAuth access token required for authenticating API requests to HubSpot. |
| GetOAuthAuthorizationURL | Generates the HubSpot OAuth authorization URL used to obtain the access token for API authentication. |
| InsertEngagement | Inserts a new engagement record in HubSpot, such as a call, email, or task. Retrieval of existing engagements is limited via API. |
| RefreshOAuthAccessToken | Refreshes the OAuth access token to maintain authenticated access to HubSpot's APIs. |
| UpdateWorkflowContacts | Enrolls or unenrolls contacts from a specific workflow within HubSpot, enabling workflow automation management. |
| UploadFile | Uploads a new file to HubSpot's file manager for use in content or marketing assets. |