ストアドプロシージャ

ストアドプロシージャはファンクションライクなインターフェースで、HubSpot の単純なSELECT/INSERT/UPDATE/DELETE 処理にとどまらず本製品の機能を拡張します。

ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにHubSpot から関連するレスポンスデータを返します。

CData JDBC Driver for HubSpot ストアドプロシージャ


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.