HubSpot snapshot

A high-level look at Stitch's HubSpot (v01-03-2017) integration, including release status, useful links, and the features supported in Stitch.

STITCH
Release Status

Released

Supported By

Stitch

Stitch Plan

Paid

Singer GitHub Repository

HubSpot Repository

DATA SELECTION
Table Selection

Unsupported

Column Selection

Unsupported

REPLICATION SETTINGS
Anchor Scheduling

Unsupported

Table-level Reset

Unsupported

Configurable Replication Methods

Unsupported

TRANSPARENCY
Extraction Logs

Unsupported

Loading Reports

Unsupported

Connecting HubSpot

HubSpot setup requirements

To set up HubSpot in Stitch, you need:

  • A paid Stitch plan. While those currently in the Free Trial will also be able to set up HubSpot, replication will be paused until a paid plan is selected after the trial ends.

Initial and historical replication jobs

After you finish setting up HubSpot, its Sync Status may show as Pending on either the Stitch Dashboard or in the Integration Details page.

For a new integration, a Pending status indicates that Stitch is in the process of scheduling the initial replication job for the integration. This may take some time to complete.

Free historical data loads

The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota.


HubSpot table schemas

Replication Method :

Full Table

Primary Key :

id

API endpoint :

getCampaignForParticularCampaign

The campaigns table contains info about the campaigns in your HubSpot account.

id
INTEGER

The ID of the campaign.

appId
INTEGER

The Application ID for the given email.

appName
STRING

The Application Name for the given email.

contentId
INTEGER

The ID associated with the content.

counters__delivered
INTEGER

The count of delivered events for the given email.

counters__open
INTEGER

The count of open events for the given email.

counters__processed
INTEGER

The count of processed events for the given email.

counters__sent
INTEGER

The count of sent events for the given email.

name
STRING

The name of the email.

numIncluded
INTEGER

The number of included emails.

numQueued
INTEGER

The number of queued emails.

subType
STRING

The subtype of the email. For example: VariantB

subject
STRING

The subject of the email.

type
STRING

The type of the email. For example: AB


Replication Method :

Full Table

Primary Key :

companyId

API endpoint :

getACompany

The companies table contains info about the companies your HubSpot contacts belong to.

companyId
INTEGER

The ID of the company.

portalId
INTEGER

The ID of the portal the company is associated with.

isDeleted
BOOLEAN

Indicates if the company has been deleted in HubSpot.


Replication Method :

Key-based Incremental

Replication Key :

updatedAt

Primary Key :

listId

API endpoint :

getContactLists

The contact_lists table contains info about the contacts lists in your HubSpot account. Contact lists are used to segment contacts into groups, and there are two types: dynamic (smart lists) and static.

listId
INTEGER

The unique ID of the list.

updatedAt
DATE-TIME

The time that the list was last updated.

internalListId
INTEGER

The list’s internal list ID. This field has been deprecated by HubSpot - use listId in its place.

parentId
INTEGER

The ID of the folder that the list belongs to.

metaData__processing
STRING

Indicates the processing status of the contact list.

metaData__size
INTEGER

The number of contacts in the list.

metaData__error
STRING

Any errors that occurred the last time the list was processed.

metaData__lastProcessingStateChangeAt
DATE-TIME

The last time that the processing status changed.

metaData__lastSizeChangeAt
DATE-TIME

The last time that the size of the list changed.

dynamic
BOOLEAN

Indicates if the contact list is a dynamic list.

name
STRING

The name of the contact list.

filters

A list of filters used to define list membership. For example: adding only contacts who have submitted a particular form.

If your destination doesn't natively support nested data, this data may be denested into a subtable named contact_lists__filters. Refer to the Singer schema for details on possible attributes.

_sdc_source_key_listId
INTEGER

The unique ID of the list.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

value

Details about the filters used to define list membership.

If your destination doesn't natively support nested data, this data may be denested into a subtable named contact_lists__filters__value. Refer to the Singer schema for details on possible attributes.

portalId
INTEGER

The ID of the portal the contact list belongs to.

createdAt
DATE-TIME

The time that the list was created.

archived
BOOLEAN

Indicates if the contact list has been archived.

deleteable
BOOLEAN

Indicates if the list can be deleted. If false, the list is a system list and cannot be deleted.

listType
STRING

The type of list. For example: static or dynamic.


Replication Method :

Full Table

Primary Key :

canonical-vid

API endpoint :

getContacts

The contacts table contains info about individual contacts in HubSpot.

canonical-vid
INTEGER

The canonical ID of the contact. In HubSpot, contacts may have multiple vids, but the canonical-vid will be the primary ID for a contact.

vid
INTEGER

The internal ID of the contact.

merged-vids

A list of vids that have been merged into this contact record.

If your destination doesn't natively support nested data, this data may be denested into a subtable named contacts__merged-vids. Refer to the Singer schema for details on possible attributes.

_sdc_source_key_canonical-vid
INTEGER

The canonical ID of the contact. In HubSpot, contacts may have multiple vids, but the canonical-vid will be the primary ID for a contact.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

type
INTEGER

The vid that was merged into the contact record.

portal-id
INTEGER

The ID of the portal the contact is associated with.

is-contact
BOOLEAN

Indicates if the contact is a valid contact.

profile-token
STRING

A unique token that can be used to view the contact without logging into HubSpot.

profile-url
STRING

A unique token that can be used to view the contact without logging into HubSpot. Anyone with this URL can view (not edit) the contact’s record.

identity-profiles

A list of the identities of the contact.

If your destination doesn't natively support nested data, this data may be denested into a subtable named contacts__identity-profiles. Refer to the Singer schema for details on possible attributes.

_sdc_source_key_canonical-vid
INTEGER

The canonical ID of the contact. In HubSpot, contacts may have multiple vids, but the canonical-vid will be the primary ID for a contact.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

deleted-changed-timestamp
DATE-TIME

The timestamp of the last delete or change event associated with a contact’s identity profile.

saved-at-timestamp
DATE-TIME

A Unix timestamp in milliseconds of when the identity was last updated.

vid
INTEGER

The original vid for the identity.

identities

A list of individual identities for the contact.

If your destination doesn't natively support nested data, this data may be denested into a subtable named contacts__identity-profiles__identities. Refer to the Singer schema for details on possible attributes.

list-memberships

A list of the contact’s memberships in contact lists.

If your destination doesn't natively support nested data, this data may be denested into a subtable named contacts__list-memberships. Refer to the Singer schema for details on possible attributes.

_sdc_source_key_canonical-vid
INTEGER

The canonical ID of the contact. In HubSpot, contacts may have multiple vids, but the canonical-vid will be the primary ID for a contact.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

internal-list-id
INTEGER

The internal list ID.

is-member
BOOLEAN

Indicates if the contact is a member of the list.

static-list-id
INTEGER

The ID of the contact list.

timestamp
DATE-TIME

A Unix timestamp in milliseconds for when the contact joined the list.

vid
INTEGER

The vid of the contact record.

form-submissions

A list of form submissions for the contact.

If your destination doesn't natively support nested data, this data may be denested into a subtable named contacts__form-submissions. Refer to the Singer schema for details on possible attributes.

_sdc_source_key_canonical-vid
INTEGER

The canonical ID of the contact. In HubSpot, contacts may have multiple vids, but the canonical-vid will be the primary ID for a contact.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

conversion-id
STRING

A unique ID for the specific form conversion.

timestamp
DATE-TIME

A Unix timestamp in milliseconds of the time the submission occurred.

form-id
STRING

The GUID of the form the submission belongs to.

portal-id
INTEGER

The ID of the portal the submission belongs to.

page-url
STRING

The URL that the form was submitted on.

title
STRING

The title of the page that the form was submitted on.

merge-audits

Details about any merges that have happened for the record.

If your destination doesn't natively support nested data, this data may be denested into a subtable named contacts__merge-audits. Refer to the Singer schema for details on possible attributes.

_sdc_source_key_canonical-vid
INTEGER

The canonical ID of the contact. In HubSpot, contacts may have multiple vids, but the canonical-vid will be the primary ID for a contact.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

canonical-vid
INTEGER

The vid of the primary contact, or the record that was merged into.

vid-to-merge
INTEGER

The vid of the secondary contact, or the record that the data was merged from.

timestamp
DATE-TIME

A Unix timestamp in milliseconds of when the merge occurred.

user-id
INTEGER

The internal ID of the user who performed the merge.

num-properties-moved
INTEGER

The number of properties that were updated as a result of the merge.

merged-from-email__value
STRING

The email address of the secondary contact at the time of the merge.

merged-from-email__source-type
STRING

The method by which the email property was last updated. For example: contacts_web

merged-from-email__source-id
STRING

Additional data related to the source-type.

merged-from-email__source-label
STRING

Additional data related to the source-type.

merged-from-email__timestamp
INTEGER

A Unix timestamp in milliseconds for when the last email address was last updated.

merged-from-email__selected
BOOLEAN

Deprecated by HubSpot.

merged-from-email__source-vids

A list of secondary contact vids.

If your destination doesn't natively support nested data, this data may be denested into a subtable named contacts__merge-audits__merged-from-email__source-vids. Refer to the Singer schema for details on possible attributes.

merged-to-email__value
STRING

The email address of the primary contact at the time of the merge.

merged-to-email__source-type
STRING

The method by which the last email property was updated. For example: contacts_web

merged-to-email__source-id
STRING

Additional data related to the source-type.

merged-to-email__source-label
STRING

Additional data related to the source-type.

merged-to-email__timestamp
INTEGER

A Unix timestamp in milliseconds for when the last email address was last updated.

merged-to-email__selected
BOOLEAN

Deprecated by HubSpot.


Replication Method :

Full Table

Primary Key :

dealId :

                    portalId
API endpoint :

getRecentlyModifiedDeals

The deals table contains info about the deals in a HubSpot portal.

dealId
INTEGER

The ID of the deal.

portalId
INTEGER

The ID of the portal the deal is associated with.

isDeleted
BOOLEAN

Indicates if the deal has been deleted in HubSpot.

associations__associatedVids

IDs of the Vids, Companies, and Deals associated with the deal.

If your destination doesn't natively support nested data, this data may be denested into a subtable named deals__associations__associatedVids. Refer to the Singer schema for details on possible attributes.

associations__associatedCompanyIds

IDs of the Vids, Companies, and Deals associated with the deal.

If your destination doesn't natively support nested data, this data may be denested into a subtable named deals__associations__associatedCompanyIds. Refer to the Singer schema for details on possible attributes.

associations__associatedDealIds

IDs of the Vids, Companies, and Deals associated with the deal.

If your destination doesn't natively support nested data, this data may be denested into a subtable named deals__associations__associatedDealIds. Refer to the Singer schema for details on possible attributes.


Replication Method :

Key-based Incremental

Replication Key :

id

Primary Key :

id

API endpoint :

getEventsForCampaignOrRecipient

The email_events table contains info about email events and how recipients interact with content.

id
STRING

The ID of the event.

appId
INTEGER

The ID of the HubSpot application that sent the email message.

appName
STRING

The name of the HubSpot application that sent the email message.

browser__family
STRING

The family of the browser that serviced the event.

browser__name
STRING

The name of the browser that serviced the event.

browser__producer
STRING

The producer of the browser that serviced the event.

browser__producerUrl
STRING

The producer URL of the browser that serviced the event.

browser__type
STRING

The type of browser that serviced the event.

browser__url
STRING

The URL of the browser that serviced the event.

created
DATE-TIME

The time the event was created.

deviceType
STRING

The type of device used to service the event.

duration
INTEGER

The approximate number of milliseconds the user had opened the email message.

emailCampaignId
INTEGER

The ID of the email campaign that the email message is a part of.

emailCampaignGroupId
INTEGER

The ID of the email campaign group associated with the email message.

filteredEvent
BOOLEAN

Indicates if the event was filtered.

from
STRING

The from field of the email message.

hmid
STRING

An auto-generated ID that corresponds to the header X-HubSpot-MID in the email message.

ipAddress
STRING

The IP address where the event originated.

linkId
INTEGER

The ID of the link the recipient clicked in the email message.

location__city
STRING

The city where the event occurred.

location__country
STRING

The country where the event occurred.

location__state
STRING

The state where the event occurred.

portalId
INTEGER

The ID of the HubSpot portal that sent the email message.

recipient
STRING

The email address of the recipient of the email message.

response
STRING

The full response from the recipient’s email server.

sentBy__created
DATE-TIME

The time the email message’s SENT event occurred.

sentBy__id
STRING

The ID of the email message’s SENT event.

smtpId
STRING

The ID that HubSpot attaches to the email message.

subject
STRING

The subject line of the email message.

type
STRING

The type of event. Click the link in attribute’s name for more details about email event types.

url
STRING

The URL in the email message that the recipient clicked.

userAgent
STRING

The user agent responsible for the event.


Replication Method :

Key-based Incremental

Replication Key :

lastUpdated

Primary Key :

id

API endpoint :

getAllEngagements

The engagements table contains info about all the engagements in a HubSpot portal.

id
INTEGER

The ID for the engagement.

lastUpdated
DATE-TIME

The time the engagement was last updated.

portalId
INTEGER

The ID of the portal the engagement belongs to.

active
BOOLEAN

Indicates if the engagement is active.

createdAt
DATE-TIME

The time the engagement was created.

ownerId
INTEGER

The ID of the owner associated with the engagement.

type
STRING

The type of engagement. For example: NOTE OR TASK

timestamp
DATE-TIME

The time the engagement should appear in the timeline.

associations

IDs of the objects associated with the engagement. For example: contacts, deals.

If your destination doesn't natively support nested data, this data may be denested into a subtable named engagements__associations. Refer to the Singer schema for details on possible attributes.

_sdc_source_key_id
INTEGER

The ID for the engagement.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

contactIds

IDs of the contacts associated with the engagement.

If your destination doesn't natively support nested data, this data may be denested into a subtable named engagements__associations__contactIds. Refer to the Singer schema for details on possible attributes.

companyIds

IDs of the companies associated with the engagement.

If your destination doesn't natively support nested data, this data may be denested into a subtable named engagements__associations__companyIds. Refer to the Singer schema for details on possible attributes.

dealIds

IDs of the deals associated with the engagement.

If your destination doesn't natively support nested data, this data may be denested into a subtable named engagements__associations__dealIds. Refer to the Singer schema for details on possible attributes.

attachments

For NOTE engagements only. IDs of the files from the file manager that should display in the attachments list when viewing the engagement in HubSpot.

If your destination doesn't natively support nested data, this data may be denested into a subtable named engagements__attachments. Refer to the Singer schema for details on possible attributes.

_sdc_source_key_id
INTEGER

The ID for the engagement.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

id
INTEGER

The ID of the attachment.

metadata__body
STRING

For NOTE engagements, this will be the body of the note.

For TASK engagements, this will be the body or details of the task.

For MEETING engagements, this will be the body or details of the meeting.

For CALL engagements, this will be the details or notes of the call.

metadata__from__email
STRING

The email address of the sender.

metadata__from__firstName
STRING

The first name of the sender.

metadata__from__lastName
STRING

The last name of the sender.

metadata__to__email
SRING

The email address of the recipient.

metadata__cc__email
STRING

The email of the CC’d recipient.

metadata__bcc__email
STRING

The email of the BCC’d recipient.

metadata__subject
STRING

For EMAIL engagements, this will be the subject of the email.

For TASK engagements, this will be the subject or title of the task.

metadata__html
STRING

For EMAIL engagements only. The body of the HTML email.

metadata__text
STRING

For EMAIL engagements only. The body of the text-only email.

metadata__status
STRING

For TASK engagements only. The status of the task. For example: COMPLETED

metadata__forObjectType
STRING

For TASK engagements only. The object type the task is for. For example: CONTACT

metadata__startTime
INTEGER

For MEETING engagements only. The start time of the meeting.

metadata__endTime
INTEGER

For MEETING engagements only. The ending time of the meeting.

metadata__title
STRING

For MEETING engagements only. The title or subject of the meeting.

metadata__toNumber
STRING

For CALL engagements only. The phone number that was called.

metadata__fromNumber
STRING

For CALL engagements only. The phone number that placed the call.

metadata__externalId
STRING

For CALL engagements only. For calls made in HubSpot, this will be the internal ID of the call.

metadata__durationMilliseconds
INTEGER

For CALL engagements only. The length of the call in milliseconds.

metadata__externalAccountId
STRING

For CALL engagements only. For calls made in HubSpot, this will be the internal ID of the account used to place the call.

metadata__recordingUrl
STRING

For CALL engagements only. The URL of the recording file.


Replication Method :

Key-based Incremental

Replication Key :

updatedAt

Primary Key :

guid

API endpoint :

getAllFormsFromAPortal

The forms table contains info about your HubSpot website forms.

guid
STRING

The GUID of the form.

updatedAt
DATE-TIME

The time the form was last updated.

deletedAt
INTEGER

If the form was deleted, the time that the deletion took place.

portalId
INTEGER

The ID of the portal the form belongs to.

name
STRING

The name of the form.

action
STRING

Deprecated by HubSpot.

method
STRING

The API method used to send the form submission. For example: POST

cssClass
STRING

The CSS class associated with the form.

redirect
STRING

The URL that the visitor will be redirect to after filling out the form.

submitText
STRING

The text that displays to the end-user to submit the form. For example: Submit or Send Form

followUpId
STRING

Deprecated by HubSpot.

notifyRecipients
STRING

A list of email addresses that should receive submission notifications.

leadNurturingCampaignId
STRING

The ID of the lead nurturing campaign the form is associated with.

formFieldGroups

Details about the fields in the form.

If your destination doesn't natively support nested data, this data may be denested into a subtable named forms__formFieldGroups. Refer to the Singer schema for details on possible attributes.

_sdc_source_key_guid
STRING

The GUID of the form.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

default
BOOLEAN

Indicates if the form group is a default group.

isSmartGroup
BOOLEAN

Indicates if the form field group is a smart group.

richText__content
STRING

The content of the rich text separator.

fields

Details about the form field in the form.

If your destination doesn't natively support nested data, this data may be denested into a subtable named forms__formFieldGroups__fields. Refer to the Singer schema for details on possible attributes.

createdAt
DATE-TIME

The time the form was created.

performableHtml
STRING

Deprecated by HubSpot.

migratedFrom
STRING

Deprecated by HubSpot.

ignoreCurrentValues
BOOLEAN

Indicates if the form will pre-populate fields with known values for known contacts.

deleteable
BOOLEAN

Indicates if the form is deleteable.

inlineMessage
STRING

The ‘thank you’ message that displays on the page after the form is submitted.

tmsId
STRING

Deprecated by HubSpot.

captchaEnabled
BOOLEAN

Indicates if a Captcha is enabled on the form.

campaignGuid
STRING

The GUID of the campaign the form is associated with.

cloneable
BOOLEAN

Indicates if the form is cloneable.

editable
BOOLEAN

Indicates if the form is editable.

formType
STRING

The type of form. For example: HUBSPOT

metaData

Metadata about the form.

If your destination doesn't natively support nested data, this data may be denested into a subtable named forms__metaData. Refer to the Singer schema for details on possible attributes.

_sdc_source_key_guid
STRING

The GUID of the form.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

name
STRING

Deprecated by HubSpot.

value
STRING

Deprecated by HubSpot.


Replication Method :

Key-based Incremental

Replication Key :

created_at

Primary Key :

keyword_guid

API endpoint :

getAKeyword

The keywords table contains info about your HubSpot portal keywords.

keyword_guid
STRING

The GUID of the keyword.

created_at
DATE-TIME

The time the keyword was created.

keyword
STRING

The text value of the keyword.

country
STRING

If the keyword is localized, this column will contain the selected country’s ID.

visits
INTEGER

The number of visits attributed to the keyword.

contacts
INTEGER

The number of contacts attributed to the keyword.

leads
INTEGER

The number of leads attributed to the keyword.


Replication Method :

Key-based Incremental

Replication Key :

updatedAt

Primary Key :

ownerId :

                    portalId
API endpoint :

getOwners

The owners table contains info about the owners that exist in your HubSpot portal. Owners are created and updated in HubSpot when new users are added or when owners are synced from Salesforce to HubSpot.

ownerId
INTEGER

The ID of the owner.

portalId
INTEGER

The ID of the portal the owner is associated with.

updatedAt
DATE-TIME

The time that the owner was last updated in HubSpot.

type
STRING

The type of owner. For example: person

firstName
STRING

The first name of the owner.

lastName
STRING

The last name of the owner.

email
STRING

The email address associated with the owner.

createdAt
DATE-TIME

The time that the owner was created in HubSpot.

remoteList

Details about the remote list associated with the owner.

If your destination doesn't natively support nested data, this data may be denested into a subtable named owners__remoteList. Refer to the Singer schema for details on possible attributes.

_sdc_source_key_ownerId
INTEGER

The ID of the owner.

_sdc_source_key_portalId
INTEGER

The ID of the portal the owner is associated with.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

portalId
INTEGER

The ID of the portal the owner is associated with.

ownerId
INTEGER

The ID of the owner.

remoteId
STRING

The ID of the remote list.

remoteType
STRING

The remote list type.

active
BOOLEAN

Indicates if the owner is active.


subscription_changes

Replication Method :

Key-based Incremental

Replication Key :

timestamp

Primary Key :

recipient :

                    portalId :
                
            
                
                    timestamp
API endpoint :

getSubscriptionsTimeline

The subscription_changes table contains info about changes made subscriptions.

recipient
STRING

The contact associated with the subscription change event.

portalId
INTEGER

The ID of the portal associated with the subscription change event.

timestamp
DATE-TIME

The time that the subscription change event occurred.

changes

Details about the subscription change event.

If your destination doesn't natively support nested data, this data may be denested into a subtable named subscription_changes__changes. Refer to the Singer schema for details on possible attributes.

_sdc_source_key_recipient
STRING

The contact associated with the subscription change event.

_sdc_source_key_portalId
INTEGER

The ID of the portal associated with the subscription change event.

_sdc_source_key_timestamp
DATE-TIME

The time that the subscription change event occurred.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

change
STRING

The action associated with the change. Ex: SUBSCRIBED

timestamp
DATE-TIME

The time that this particular event occurred.

source
STRING

The source of the change. Ex: SOURCE_RECIPIENT

portalId
INTEGER

The ID of the portal associated with the change event.

subscriptionId
INTEGER

If applicable, the ID of the subscription involved in the change event.

changeType
STRING

The type of change. Ex: SUBSCRIPTION_STATUS

causedByEvent__id
STRING

The ID of the event that caused the change.

causedByEvent__created
DATE-TIME

The time that the event that caused the change occurred.


Replication Method :

Key-based Incremental

Replication Key :

updatedAt

Primary Key :

id

API endpoint :

getWorkflows

The workflows table contains info about the workflows in your HubSpot portal.

id
INTEGER

The ID of the workflow.

updatedAt
DATE-TIME

The time that the workflow was last updated.

name
STRING

The name of the workflow.

type
STRING

The type of workflow. For example: DRIP_DELAY

enabled
BOOLEAN

Indicates if the workflow is enabled in your HubSpot portal.

inserted-at
DATE-TIME

The time that the workflow was inserted.

personaTagIds

Info about the personas tied to the workflow.

If your destination doesn't natively support nested data, this data may be denested into a subtable named workflows__personaTagIds. Refer to the Singer schema for details on possible attributes.

_sdc_source_key_id
INTEGER

The ID of the workflow.

_sdc_level_0_id
INTEGER

This column forms part of a composite key for the table. The value will auto-increment for each unique record, beginning with 0.

value
INTEGER

The ID of the persona tied to the workflow.

contactListIds__enrolled
INTEGER

The number of contacts currently enrolled in the workflow.

contactListIds__active
INTEGER

The number of active contacts for the workflow.

contactListIds__steps

Summary info for the contact lists associated with the workflow.

If your destination doesn't natively support nested data, this data may be denested into a subtable named workflows__contactListIds__steps. Refer to the Singer schema for details on possible attributes.



Questions? Feedback?

Did this article help? If you have questions or feedback, feel free to submit a pull request with your suggestions, open an issue on GitHub, or reach out to us.