CData JDBC Driver for HubSpot 2019 - Online Help
Questions / Feedback?

Stored Procedures

CData JDBC Driver for HubSpot 2019 - Build 19.0.7424

Stored procedures are available to complement the data available from the Data Model. It may be necessary to update data available from a view using a stored procedure because the data does not provide for direct, table-like, two-way updates. In these situations, the retrieval of the data is done using the appropriate view or table, while the update is done by calling a stored procedure. Stored procedures take a list of parameters and return back a dataset that contains the collection of tuples that constitute the response.

CData JDBC Driver for HubSpot 2019 Stored Procedures

Name Description
CheckObjectSyncStatus Check the sync status of a object, based on the integratorObjectId and type of object.
ContactStatistics Basic contact statistics that can be retrieved from HubSpot such as the total number and when the last new contact was created..
CreateSchema Creates a schema file for the specified table or view.
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.
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.

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7424.0