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 |
| AddOptedOutContacts | Unsubscribes the contact from all subscription preferences in Hubspot. |
| 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. |
| CreateList | Creates a new list in HubSpot with a filter branch payload. Returns the Id of the created list. |
| 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. |
| EnableSubscriptionPreferences | Subscribes the contact to the specified subscription type. Along with this, HubSpot enables all available subscription types for the specified contact with the default status of NOT_SPECIFIED. |
| GetAccountDetails | Retrieve HubSpot account details such as account type, time zone, currencies, and data hosting location. |
| GetEventOccurrences | Retrieve event occurrences associated with CRM objects. |
| GetOAuthAccessToken | Fetches the OAuth Access Token, which is used to authenticate and authorize Hubspot API calls. |
| GetOAuthAuthorizationURL | Retrieves the OAuth Authorization URL, allowing the client to direct the user's browser to the authorization server and initiate the OAuth process. |
| GetPropertyValidations | Returns one row per validation rule configured for CRM properties in HubSpot. ObjectTypeId is required. Filter by PropertyName to retrieve rules for a single property. |
| RefreshOAuthAccessToken | Refreshes an expired OAuth Access Token to maintain continuous authenticated access to Hubspot resources without requiring reauthorization from the user. |
| 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. |
| UpdateSubscriptionPreferences | Updates the subscription preferences for a contact in HubSpot. |
| UploadFile | Uploads a file to HubSpot's file manager for use in marketing or content purposes. |
| UpsertPropertyValidations | Adds or replaces a single validation rule for a CRM property in HubSpot. Issues one PUT request to the CRM Property Validations API. |