ストアドプロシージャ

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

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

CData SSIS Components for HubSpot ストアドプロシージャ


Name	Description
CreateCustomObject	Create a Custom Object in HubSpot. May not work for the OAuth Authentication scheme due to insufficient OAuth Apps scopes, use the PrivateAppToken authentication instead.
CreateCustomProperty	Create a Custom Property for a HubSpot Object.
CreateSchema	Creates a schema file for the specified table or view.
DeleteCustomObject	Delete an existing Custom Object in HubSpot. May not work for the OAuth Authentication scheme due to insufficient OAuth Apps scopes, use the PrivateAppToken authentication instead.
DeleteCustomProperty	Delete an existing Custom Property for a HubSpot Object.
DeleteFile	Permanently delete a file and all related data and thumbnails from file manager.
DownloadFile	Download a file. Requires files or files.ui_hidden.read as a scope.
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.
GetTotalCountForQuery	Usage information for the operation GetTotalCountForQuery.rsb.
RefreshOAuthAccessToken	Refreshes the OAuth access token used for authentication with various HubSpot services.
UpdateCustomObject	Update an existing Custom Object in HubSpot. May not work for the OAuth Authentication scheme due to insufficient OAuth Apps scopes, use the PrivateAppToken authentication instead.
UpdateCustomProperty	Update an existing Custom Property for a HubSpot Object.
UploadFile	Upload a new file to the file manager.