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 JDBC Driver 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. |