JDBC Driver for HubSpot

Build 22.0.8462

Workflows

Select and manage HubSpot workflows.

Table Specific Information

Workflows are automated tasks in HubSpot. You can perform automated tasks with contacts by enrolling contacts in workflows.

Select

When selecting workflows, data may be filtered by the WorkflowId. For example:

SELECT * FROM Workflows WHERE WorkflowId='123456789'

Columns

Name Type ReadOnly References Description
Id [KEY] Long True

The Id of the workflow.

Name String False

The name of the workflow.

Description String False

A description of the workflow.

IsEnabled Boolean False

A boolean indicating if this workflow is enabled.

CreatedAt Datetime True

When the workflow was created.

UpdatedAt Datetime True

When the workflow was last updated.

AllowContactToTriggerMultipleTimes Boolean False

A boolean indicating if the workflow can be triggered for the same contact multiple times.

CanEnrollFromSalesforce Boolean False

A boolean indicating if contacts can be enrolled to this workflow from Salesforce.

IsInternal Boolean False

A boolean indicating if the workflow is internal.

LegacyCampaignId Long False

The campaign id associated with the workflow if available.

LegacyMigration Boolean False

A boolean indicating if the workflow was migrated from the legacy lead nurturing tool.

IsListening Boolean False

A boolean indicating if the workflow is listening or active.

ContactListIdsCompleted Long True

The number of contacts that have been completed.

ContactListIdsEnrolled Long True

The number of contacts that have been enrolled.

ContactListIdsFailed Long True

The number of contacts that have failed in the workflow.

ContactListIdsSucceeded Long True

The number of contacts that have successfully completed the workflow.

NurtureTimeRangeEnabled Boolean False

A boolean indicating if this workflow is enabled for a nurture time range.

NurtureTimeRangeStartHour Integer False

The hour of day nurturing begins for this workflow.

NurtureTimeRangeStopHour Integer False

The hour of day nurturing ends for this workflow.

OnlyExecOnBizDays Boolean False

A boolean indicating if this workflow should only execute on standard business days.

StepsAggregate String False

An aggregate of the steps to take when executing this workflow.

SupresssionSettingsAggregate String False

An aggregate of supression properties for this workflow.

TriggerSetsAggregate String False

An aggregate of trigger sets for this workflow.

TriggersAggregate String False

An aggregate of triggers for this workflow.

UnenrollmentSettingType String False

The type of unenrollment setting for this workflow.

UnenrollmentSettingExcludedWorkflowsAggregate String False

An workflows to exclude a contact from if they enroll in this workflow.

GoalListAggregate String False

An aggregate of goal ids for this workflow.

ExtraUrlParameters String True

An input only property for specifying additional parameters when selecting data from HubSpot. Specify the parameters as name=value pairs in a comma separated list. For instance, 'param1=value1,param2=value2,param3=value3'.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462