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, if applicable, 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 |
| CheckObjectSyncStatus | Check the sync status of a object, based on the integratorObjectId and type of object. |
| CreateSchema | Creates a schema file for the specified table or view. |
| DeleteFile | Permanently delete a file and all related data and thumbnails from file manager. |
| GetEcommerceTriggerURI | Retrieve the current ecommerce trigger URI. |
| GetOAuthAccessToken | Gets the OAuth access token from HubSpot. |
| GetOAuthAuthorizationURL | Gets the HubSpot authorization URL. Access the URL returned in the output in an Internet browser. This requests the access token that can be used as part of the connection string to HubSpot. |
| GetTotalCountFromRecent | Usage information for the operation GetTotalCountFromRecent.rsb. |
| ImportEcommercePages | Once you've received an import initialization request you can send batches of items to HubSpot via this Import Paged Endpoint. |
| InsertEngagement | Allows the insertion of engagements into HubSpot. Currently there is no good means of retrieving existing engagements via the HubSpot API. |
| RefreshOAuthAccessToken | Refreshes the OAuth access token used for authentication with various HubSpot services. |
| SendSyncMessages | Send a group of sync messages for a specific object type. Sync messages would be notifications of creates, updates, or deletes of ecommerce objects. Maximum number of Sync messages that you can send in one request is 200. |
| SetEcommerceTriggerURI | Check the sync status of a object, based on the integratorObjectId and type of object. |
| UpdateWorkflowContacts | You can enroll/unenroll contacts of a workflow. |
| UploadFile | Upload a new file to the file manager. |