Experimente nossa plataforma

HubSpot

Adicionando o conector

Requisitos

  1. Siga os passos com um usuário do tipo Super admin
  2. O escopo mínimo necessário ao funcionamento do conector é crm.objects.contacts

Instruções

1) Faça login na sua conta do Hubspot com um usuário Super admin

2) Na parte superior direita, clique em configurações (ícone da engrenagem)

3) No menu à esquerda da página de configurações, selecione a opção de “Integrations”

4) Na expansão de Integrações, selecione “Private Apps”

5) Na página de Private apps, clique em “Create a private app

6) Na nova janela, em “Basic info” preencha um nome para o seu app, por exemplo “Kondado”. Caso deseje utilizar um logo para identificação interna, você pode utilizar este

7) Selecione a seção de “scopes” ao topo

8) Na seção de scopes, recomendamos que seja marcada a permissão de “Read” em todos os scopes disponíveis em CRM (não selecione a permissão “Write” porque não é necessária) e em Standard, recomendamos que sejam utilizados todos que não sejam de write

9) Após preencher os dados em “Basic info” e “Scopes”, selecione “Create app” na parte superior direita

10) Aceite o pop-up que irá surgir e depois quando receber a mensagem de que seu app foi criado, clique em show token e depois copie o token exibido

11) Faça login na plataforma da Kondado, vá para a seção de adicionar conectores e selecione o conector do Hubspot

12) Na página de criação do conector, copie o token obtido no passo 10 e clique em Salvar

Agora basta ir para a página de integrações, selecionar as integrações que você quer e começar a receber as informações no seu banco!

Agora que você já sabe como integrar dados do Hubspot pela Kondado, aproveite para conferir esse artigo, onde mostramos como criar relacionamentos entre os objetos do Hubspot e pivotar as suas propriedades.

Integrações

Índice

Gráfico de relacionamento

Clique para ampliar

Contatos [Versão Atual]

Esta integração trará os contatos e todas as suas propriedades em formato colunar – de acordo com a configuração da sua conta, em um formato similar ao abaixo:

Campo Tipo

id

text

createdat

timestamp

updatedat

timestamp

archived

boolean

property_x

text

property_y

text

property_z

text

Esta integração não captura deleções e arquivamentos: caso um registro seja removido por arquivamento ou deleção, isso não se refletirá na sua integração. Por isso, criamos uma integração específica de registros arquivados que você pode utilizar para remover os dados arquivados da sua visualização ou modelo. Os dados deletados não podem ser recuperados

Por padrão, todas as propriedades customizadas existentes na sua conta serão trazidas. Entretando, utilizar muitas propriedades pode impactar a velocidade de leitura dos dados. Recomendamos que você utilize apenas as propriedades necessárias, selecionando as que deseja na tela de criação/edição de integração, no momento de dar nome às tabelas, basta clicar em CAMPOS e desmarcar/marcar as propriedades/colunas desejadas

Se durante uma execução, forem encontrados mais do que 10 mil registros atualizados dentro de um período de 100 milisegundos, ou o savepoint inicial for superior a 3 dias da data atual, será realizada uma execução integral

Contatos arquivados [Versão Atual]

Campo Tipo

id

text

archived

boolean

archivedat

timestamp

createdat

timestamp

properties__createdate

timestamp

properties__email

text

properties__firstname

text

properties__lastmodifieddate

timestamp

properties__lastname

text

updatedat

timestamp

Contatos: pertencimento a listas [V1]

Esta integração é baseada na integração de Contatos [V1] e sua atualização depende da alteração da propriedade lastmodifieddate do contato. Além disso, entenda sobre o cálculo de savepoint neste changelog

Campo Tipo

vid

text

timestamp

timestamp

static_list_id

text

internal_list_id

text

is_member

boolean

Contatos: formulários enviados [V1]

Esta integração é baseada na integração de Contatos [V1] e sua atualização depende da alteração da propriedade lastmodifieddate do contato que registrou o envio de formulário, havendo um posterior filtro pela data de envio do formulário. Além disso, entenda sobre o cálculo de savepoint neste changelog

Objeto principal

Campo Tipo

vid

text

conversion_id

text

canonical_url

text

content_type

text

form_id

text

form_type

text

page_id

text

page_title

text

page_url

text

portal_id

text

timestamp

timestamp

title

text

contact_associated_by

Campo Tipo

vid

text

conversion_id

text

associated_by

text

Contatos: tickets relacionados [Versão Atual]

Campo Tipo

contact_id

int

ticket_id

int

association_type

text

Contatos: deals relacionados [Versão Atual]

Campo Tipo

contact_id

int

deal_id

int

association_type

text

Contatos: companhias relacionadas [Versão Atual]

Campo Tipo

contact_id

int

company_id

int

association_type

text

Listas de contatos

Campo Tipo

listid

text

archived

boolean

authorid

text

createdat

timestamp

deleteable

boolean

dynamic

boolean

internallistid

text

listtype

text

metadata__lastprocessingstatechangeat

timestamp

metadata__lastsizechangeat

timestamp

metadata__processing

text

metadata__size

float

name

text

portalid

text

readonly

boolean

updatedat

timestamp

Propriedades dos contatos [V1]

Objeto principal

Campo Tipo

favorited

boolean

description

text

createduserid

float

deleted

boolean

referencedobjecttype

text

updatedat

float

displaymode

text

externaloptions

boolean

displayorder

float

formfield

boolean

readonlyvalue

boolean

fieldtype

text

optionsaremutable

boolean

currencypropertyname

text

searchableinglobalsearch

boolean

createdat

float

textdisplayhint

text

showcurrencysymbol

boolean

property_name

text

updateduserid

float

iscustomizeddefault

boolean

calculated

boolean

favoritedorder

float

mutabledefinitionnotdeletable

boolean

label

text

groupname

text

hasuniquevalue

boolean

numberdisplayhint

text

hubspotdefined

boolean

searchtextanalysismode

text

hidden

boolean

type

text

optionsortstrategy

text

readonlydefinition

boolean

options

Campo Tipo

property_name

text

options__description

text

options__value

text

options__label

text

options__readonly

boolean

options__hidden

boolean

options__displayorder

float

options__doubledata

text

Esta integração é gratuita

Contatos [V1]

Objeto principal

Campo Tipo

addedat

float

vid

text

canonical_vid

float

portal_id

float

is_contact

boolean

profile_token

text

profile_url

text

_merged_vids

Campo Tipo

vid

text

merged_vid

float

form-submissions

Campo Tipo

vid

text

conversion_id

text

timestamp

float

form_id

text

portal_id

float

title

text

form_type

text

page_url

text

contact_associated_by

text

list-memberships

Campo Tipo

vid

text

static_list_id

float

internal_list_id

float

timestamp

float

list_memberships__vid

float

is_member

boolean

identity-profiles

Campo Tipo

vid

text

is_deleted

boolean

is_contact

boolean

pointer_vid

float

previous_vid

float

saved_at_timestamp

float

deleted_changed_timestamp

float

_identityProfiles_linkedVids

Campo Tipo

vid

text

linked_vid

float

_identityProfiles_identities

Campo Tipo

vid

text

type

text

value

text

timestamp

float

is_primary

boolean

is_secondary

boolean

_properties

Campo Tipo

vid

text

key

text

value

text

_properties_versions

Campo Tipo

vid

text

key

text

value

text

source_type

text

source_id

text

source_label

text

timestamp

float

selected

boolean

Por limitação da API, se durante uma execução forem encontrados mais do que 10 mil registros atualizados/criados dentro do período consultado (savepoint + janela de atualização) será realizada uma carga integral

Deals [Versão Atual]

Esta integração trará os deals e todas as suas propriedades em formato colunar – de acordo com a configuração da sua conta, em um formato similar ao abaixo:

Campo Tipo

id

text

createdat

timestamp

updatedat

timestamp

archived

boolean

property_x

text

property_y

text

property_z

text

Esta integração não captura deleções e arquivamentos: caso um registro seja removido por arquivamento ou deleção, isso não se refletirá na sua integração. Por isso, criamos uma integração específica de registros arquivados que você pode utilizar para remover os dados arquivados da sua visualização ou modelo. Os dados deletados não podem ser recuperados

Por padrão, todas as propriedades customizadas existentes na sua conta serão trazidas. Entretando, utilizar muitas propriedades pode impactar a velocidade de leitura dos dados. Recomendamos que você utilize apenas as propriedades necessárias, selecionando as que deseja na tela de criação/edição de integração, no momento de dar nome às tabelas, basta clicar em CAMPOS e desmarcar/marcar as propriedades/colunas desejadas

Se durante uma execução, forem encontrados mais do que 10 mil registros atualizados dentro de um período de 100 milisegundos, ou o savepoint inicial for superior a 3 dias da data atual, será realizada uma execução integral

Deals arquivados [Versão Atual]

Campo Tipo

id

text

archived

boolean

archivedat

timestamp

createdat

timestamp

properties__amount

float

properties__closedate

timestamp

properties__createdate

timestamp

properties__dealname

text

properties__dealstage

text

properties__hs_lastmodifieddate

timestamp

properties__pipeline

text

updatedat

timestamp

Deals: contatos relacionados [Versão Atual]

Campo Tipo

deal_id

text

contact_id

text

association_type

text

Deals: companhias relacionadas [Versão Atual]

Campo Tipo

deal_id

text

company_id

text

association_type

text

Deals: tickets relacionados [Versão Atual]

Campo Tipo

deal_id

text

ticket_id

text

association_type

text

Owners [Versão Atual]

Objeto principal

Campo Tipo

id

text

userid

text

email

text

firstname

text

lastname

text

archived

boolean

createdat

timestamp

updatedat

timestamp

hubspot_owners_teams

Campo Tipo

owner_id

text

team_id

text

team_name

text

Por limitações na leitura dos dados, esta integração é integral

Propriedades dos deals [V1]

Objeto principal

Campo Tipo

favorited

boolean

description

text

createduserid

float

deleted

boolean

referencedobjecttype

text

updatedat

float

displaymode

text

externaloptions

boolean

displayorder

float

formfield

boolean

readonlyvalue

boolean

fieldtype

text

optionsaremutable

boolean

currencypropertyname

text

searchableinglobalsearch

boolean

createdat

float

textdisplayhint

text

showcurrencysymbol

boolean

property_name

text

updateduserid

float

iscustomizeddefault

boolean

calculated

boolean

favoritedorder

float

mutabledefinitionnotdeletable

boolean

label

text

groupname

text

hasuniquevalue

boolean

numberdisplayhint

text

hubspotdefined

boolean

searchtextanalysismode

text

hidden

boolean

type

text

optionsortstrategy

text

readonlydefinition

boolean

options

Campo Tipo

property_name

text

options__description

text

options__value

text

options__label

text

options__readonly

boolean

options__hidden

boolean

options__displayorder

float

options__doubledata

text

Esta integração é gratuita

Deals [V1]

Objeto principal

Campo Tipo

dealid

text

portalid

float

isdeleted

boolean

_associations

Campo Tipo

dealid

text

association_type

text

association_value

float

_properties

Campo Tipo

dealid

text

key

text

value

text

_properties_versions

Campo Tipo

dealid

text

key

text

value

text

source_id

text

timestamp

float

source

text

Por limitação da API, se durante uma execução forem encontrados mais do que 10 mil registros atualizados/criados dentro do período consultado (savepoint + janela de atualização) será realizada uma carga integral

Pipelines

Objeto principal

Campo Tipo

default

boolean

displayorder

float

updatedat

float

active

boolean

objecttypeid

text

pipelineid

text

label

text

createdat

float

objecttype

text

stages

Campo Tipo

pipelineid

text

stages__label

text

stages__createdat

float

stages__stageid

text

stages__updatedat

float

stages__active

boolean

stages__displayorder

float

stages__metadata__isclosed

text

stages__metadata__probability

float

Esta integração é gratuita

Owners [V1]

Objeto principal

Campo Tipo

activeuserid

text

portalid

text

updatedat

float

createdat

float

useridincludinginactive

text

firstname

text

hascontactsaccess

boolean

lastname

text

activesalesforceid

text

isactive

boolean

ownerid

text

type

text

email

text

remoteList

Campo Tipo

ownerid

text

remotelist__remoteid

text

remotelist__portalid

text

remotelist__remotetype

text

remotelist__ownerid

text

remotelist__active

boolean

remotelist__id

text

Companhias [Versão Atual]

Esta integração trará as companhias e todas as suas propriedades em formato colunar – de acordo com a configuração da sua conta, em um formato similar ao abaixo:

Campo Tipo

id

text

createdat

timestamp

updatedat

timestamp

archived

boolean

property_x

text

property_y

text

property_z

text

Esta integração não captura deleções e arquivamentos: caso um registro seja removido por arquivamento ou deleção, isso não se refletirá na sua integração. Por isso, criamos uma integração específica de registros arquivados que você pode utilizar para remover os dados arquivados da sua visualização ou modelo. Os dados deletados não podem ser recuperados

Por padrão, todas as propriedades customizadas existentes na sua conta serão trazidas. Entretando, utilizar muitas propriedades pode impactar a velocidade de leitura dos dados. Recomendamos que você utilize apenas as propriedades necessárias, selecionando as que deseja na tela de criação/edição de integração, no momento de dar nome às tabelas, basta clicar em CAMPOS e desmarcar/marcar as propriedades/colunas desejadas

Se durante uma execução, forem encontrados mais do que 10 mil registros atualizados dentro de um período de 100 milisegundos, ou o savepoint inicial for superior a 3 dias da data atual, será realizada uma execução integral

Companhias arquivadas [Versão Atual]

Campo Tipo

id

text

archived

boolean

archivedat

timestamp

createdat

timestamp

properties__createdate

timestamp

properties__domain

text

properties__hs_lastmodifieddate

timestamp

properties__name

text

updatedat

timestamp

Companhias: contatos relacionados [Versão Atual]

Campo Tipo

company_id

text

contact_id

text

association_type

text

Companhias: deals relacionados [Versão Atual]

Campo Tipo

company_id

text

deal_id

text

association_type

text

Companhias: tickets relacionados [Versão Atual]

Campo Tipo

company_id

text

ticket_id

text

association_type

text

Propriedades das companhias [V1]

Objeto principal

Campo Tipo

favorited

boolean

description

text

createduserid

float

deleted

boolean

referencedobjecttype

text

updatedat

float

displaymode

text

externaloptions

boolean

displayorder

float

formfield

boolean

readonlyvalue

boolean

fieldtype

text

optionsaremutable

boolean

currencypropertyname

text

searchableinglobalsearch

boolean

createdat

float

textdisplayhint

text

showcurrencysymbol

boolean

property_name

text

updateduserid

float

iscustomizeddefault

boolean

calculated

boolean

favoritedorder

float

mutabledefinitionnotdeletable

boolean

label

text

groupname

text

hasuniquevalue

boolean

numberdisplayhint

text

hubspotdefined

boolean

searchtextanalysismode

text

hidden

boolean

type

text

optionsortstrategy

text

readonlydefinition

boolean

options

Campo Tipo

property_name

text

options__description

text

options__value

text

options__label

text

options__readonly

boolean

options__hidden

boolean

options__displayorder

float

options__doubledata

text

Esta integração é gratuita

Companhias [V1]

Objeto principal

Campo Tipo

companyid

text

portalid

float

isdeleted

boolean

_properties

Campo Tipo

companyid

text

key

text

value

text

_properties_versions

Campo Tipo

companyid

text

key

text

value

text

source_id

text

timestamp

float

source

text

Por limitação da API, se durante uma execução forem encontrados mais do que 10 mil registros atualizados/criados dentro do período consultado (savepoint + janela de atualização) será realizada uma carga integral

Tickets [Versão Atual]

Esta integração trará os tickets e todas as suas propriedades em formato colunar – de acordo com a configuração da sua conta, em um formato similar ao abaixo:

Campo Tipo

id

text

createdat

timestamp

updatedat

timestamp

archived

boolean

property_x

text

property_y

text

property_z

text

Esta integração não captura deleções e arquivamentos: caso um registro seja removido por arquivamento ou deleção, isso não se refletirá na sua integração. Por isso, criamos uma integração específica de registros arquivados que você pode utilizar para remover os dados arquivados da sua visualização ou modelo. Os dados deletados não podem ser recuperados

Por padrão, todas as propriedades customizadas existentes na sua conta serão trazidas. Entretando, utilizar muitas propriedades pode impactar a velocidade de leitura dos dados. Recomendamos que você utilize apenas as propriedades necessárias, selecionando as que deseja na tela de criação/edição de integração, no momento de dar nome às tabelas, basta clicar em CAMPOS e desmarcar/marcar as propriedades/colunas desejadas

Se durante uma execução, forem encontrados mais do que 10 mil registros atualizados dentro de um período de 100 milisegundos, ou o savepoint inicial for superior a 3 dias da data atual, será realizada uma execução integral

Tickets arquivados [Versão Atual]

Campo Tipo

id

text

archived

boolean

archivedat

timestamp

createdat

timestamp

properties__content

text

properties__createdate

timestamp

properties__hs_lastmodifieddate

timestamp

properties__hs_pipeline

text

properties__hs_pipeline_stage

text

properties__hs_ticket_category

text

properties__hs_ticket_priority

text

properties__subject

text

updatedat

timestamp

Tickets: contatos relacionados [Versão Atual]

Campo Tipo

ticket_id

int

contact_id

int

association_type

text

Tickets: deals relacionados [Versão Atual]

Campo Tipo

ticket_id

int

deal_id

int

association_type

text

Tickets: companhias relacionadas [Versão Atual]

Campo Tipo

ticket_id

int

company_id

int

association_type

text

Propriedades dos tickets [V1]

Objeto principal

Campo Tipo

favorited

boolean

description

text

createduserid

text

externaloptions

boolean

referencedobjecttype

text

updatedat

text

displaymode

text

numberdisplayhint

text

favoritedorder

float

formfield

boolean

readonlyvalue

boolean

fieldtype

text

optionsaremutable

text

searchableinglobalsearch

boolean

displayorder

float

textdisplayhint

text

showcurrencysymbol

text

property_name

text

updateduserid

text

iscustomizeddefault

boolean

calculated

boolean

deleted

text

mutabledefinitionnotdeletable

boolean

createdat

text

label

text

groupname

text

hasuniquevalue

boolean

hubspotdefined

boolean

currencypropertyname

text

searchtextanalysismode

text

hidden

boolean

type

text

optionsortstrategy

text

readonlydefinition

boolean

options

Campo Tipo

property_name

text

options__doubledata

text

options__value

text

options__label

text

options__readonly

text

options__hidden

boolean

options__displayorder

float

options__description

text

Esta integração é gratuita

Tickets [V1]

Objeto principal

Campo Tipo

ticketid

text

portalid

float

isdeleted

boolean

_properties

Campo Tipo

ticketid

text

key

text

value

text

_properties_versions

Campo Tipo

ticketid

text

key

text

value

text

source_id

text

timestamp

float

source

text

_associations

Campo Tipo

ticketid

text

association_type

text

associated_id

text

Por limitação da API, se durante uma execução forem encontrados mais do que 10 mil registros atualizados/criados dentro do período consultado (savepoint + janela de atualização) será realizada uma carga integral

Email events

Sent

Campo Tipo

id

text

from

text

appname

text

replyto

text

type

text

emailcampaignid

float

created

float

bcc

text

portalid

float

appid

float

emailcampaigngroupid

float

smtpid

text

sentby__id

text

sentby__created

float

recipient

text

cc

text

subject

text

Dropped

Campo Tipo

id

text

appname

text

emailcampaignid

float

portalid

float

appid

float

emailcampaigngroupid

float

recipient

text

dropreason

text

attempt

float

smtpid

text

created

float

sentby__id

text

sentby__created

float

type

text

dropmessage

text

Processed

Campo Tipo

id

text

appname

text

emailcampaignid

float

smtpid

text

appid

float

emailcampaigngroupid

float

recipient

text

attempt

float

portalid

float

created

float

sentby__id

text

sentby__created

float

type

text

Delivered

Campo Tipo

id

text

appname

text

emailcampaignid

float

smtpid

text

appid

float

emailcampaigngroupid

float

recipient

text

response

text

attempt

float

portalid

float

created

float

sentby__id

text

sentby__created

float

type

text

Deferred

Campo Tipo

id

text

appname

text

emailcampaignid

float

portalid

float

appid

float

emailcampaigngroupid

float

recipient

text

response

text

attempt

float

smtpid

text

created

float

sentby__id

text

sentby__created

float

type

text

Bounce

Campo Tipo

id

text

status

text

appname

text

emailcampaignid

float

portalid

float

appid

float

emailcampaigngroupid

float

recipient

text

response

text

category

text

attempt

float

smtpid

text

created

float

sentby__id

text

sentby__created

float

type

text

Open

Campo Tipo

appname

text

type

text

emailcampaignid

float

created

float

portalid

float

devicetype

text

location__country

text

location__state

text

location__zipcode

text

location__city

text

filteredevent

boolean

appid

float

duration

float

useragent

text

smtpid

text

sentby__id

text

sentby__created

float

recipient

text

id

text

browser__family

text

browser__name

text

browser__producer

text

browser__url

text

browser__producerurl

text

browser__version

text

browser__type

text

Click

Campo Tipo

id

text

type

text

appname

text

url

text

linkid

float

useragent

text

created

float

smtpid

text

emailcampaigngroupid

float

referer

text

location__country

text

location__state

text

location__city

text

filteredevent

boolean

appid

float

portalid

float

devicetype

text

sentby__id

text

sentby__created

float

recipient

text

emailcampaignid

float

browser__family

text

browser__name

text

browser__producer

text

browser__url

text

browser__producerurl

text

browser__version

text

browser__type

text

Status change

Campo Tipo

id

text

source

text

portalid

float

appid

float

subscriptions

text

sourceid

text

type

text

emailcampaignid

float

created

float

recipient

text

Spam report

Campo Tipo

id

text

appname

text

emailcampaignid

float

portalid

float

appid

float

recipient

text

attempt

text

smtpid

text

created

float

sentby__id

text

sentby__created

float

type

text

Marketing Emails

Objeto principal

Campo Tipo

id

text

ab

boolean

abhourstowait

float

absamplesizedefault

text

absamplingdefault

text

abstatus

text

absuccessmetric

text

abtestid

text

abtestpercentage

float

abvariation

boolean

absoluteurl

text

analyticspageid

text

analyticspagetype

text

archived

boolean

author

text

authorname

text

campaign

text

campaignname

text

campaignutm

text

canspamsettingsid

text

categoryid

float

createpage

boolean

created

timestamp

createdbyid

text

currentstate

text

currentlypublished

boolean

customreplyto

text

customreplytoenabled

boolean

domain

text

emailbody

text

emailcampaigngroupid

text

emailnote

text

emailtemplatemode

text

emailtype

text

feedbacksurveyid

text

freezedate

timestamp

fromname

text

hascontentaccessrules

boolean

htmltitle

text

isgraymailsuppressionenabled

boolean

ispublished

boolean

isrecipientfatiguesuppressionenabled

boolean

language

text

livedomain

text

maxrssentries

float

metadescription

text

name

text

pageexpiryenabled

boolean

pageredirected

boolean

portalid

text

previewkey

text

primaryemailcampaignid

text

primaryrichtextmodulehtml

text

processingstatus

text

publishdate

timestamp

publishedat

timestamp

publishedbyemail

text

publishedbyid

text

publishedbyname

text

publishedurl

text

replyto

text

resolveddomain

text

rssemailbytext

text

rssemailclickthroughtext

text

rssemailcommenttext

text

rssemailentrytemplateenabled

boolean

rssemailimagemaxwidth

float

rssemailurl

text

securitystate

text

slug

text

state

text

subcategory

text

subject

text

subscription

text

subscriptionname

text

templatepath

text

transactional

boolean

unpublishedat

timestamp

updated

timestamp

updatedbyid

text

url

text

userssheadlineassubject

boolean

hubspot_marketing_emails__mailing_lists_included

Campo Tipo

marketing_email_id

text

mailing_list_id

text

hubspot_marketing_emails__vids_included

Campo Tipo

marketing_email_id

text

vid

text

hubspot_marketing_emails__email_campaigns

Campo Tipo

marketing_email_id

text

campaign_id

text

hubspot_marketing_emails__vids_excluded

Campo Tipo

marketing_email_id

text

vid

text

hubspot_marketing_emails__mailing_lists_excluded

Campo Tipo

marketing_email_id

text

mailing_list_id

text

Engagements [V1]

Objeto principal

Campo Tipo

id

text

bodypreviewhtml

text

bodypreview

text

bodypreviewistruncated

boolean

uid

text

source

text

timestamp

float

lastupdated

float

portalid

text

teamid

text

modifiedby

float

createdby

float

active

boolean

ownerid

text

type

text

createdat

float

metadata_status

text

session_visitorstarttime

float

email_loggedfrom

text

call_disposition

text

call_recordingurl

text

call_fromnumber

text

email_text

text

email_messageid

text

session_closedat

float

session_durationmilliseconds

float

session_agentjointime

float

session_isbot

boolean

meeting_starttime

float

metadata_threadid

text

call_externalaccountid

text

metadata_body

text

session_visitorendtime

float

metadata_subject

text

session_numvisitormessages

float

email_attachedvideowatched

boolean

email_validationskipped

text

meeting_endtime

float

session_conversationsource

text

email_sender

text

task_forobjecttype

text

session_url

text

meeting_title

text

task_reminders

text

email_html

text

session_visitorwaittimemilliseconds

float

call_tonumber

text

email_sendeventid

text

call_durationmilliseconds

float

session_online

boolean

task_senddefaultreminder

boolean

call_externalid

text

session_numagentmessages

float

task_type

text

email_attachedvideoopened

boolean

email_mediaprocessingstatus

text

task_completiondate

float

meetingoutcome

text

activitytype

text

associations

Campo Tipo

engagement_id

text

association_type

text

association_value

text

note_attachments

Campo Tipo

engagement_id

text

note_attachment_id

text

email_addresses

Campo Tipo

engagement_id

text

firstname

text

lastname

text

raw

text

address_type

text

email

text

Esta integração não captura deleções e arquivamentos. Desta forma, engagements que foram removidos do HubSpot podem continuar a aparecer no seu destino. Para ressincronizar, basta fazer uma edição avançada da integração

Por limitação da API, se durante uma execução forem encontrados mais do que 10 mil registros atualizados/criados dentro do período consultado (savepoint + janela de atualização) será realizada uma carga integral

Engagements: Calls [Versão Atual]

Campo Tipo

id

text

createdat

timestamp

updatedat

timestamp

archived

boolean

hs_activity_type

text

[en] Call and meeting type – The activity type of the engagement

hs_all_assigned_business_unit_ids

text

[en] Business units – The business units this record is assigned to.

hs_at_mentioned_owner_ids

text

[en] At-Mentioned Owner Ids – The owners that have been at-mentioned on the engagement

hs_attachment_ids

text

[en] Attached file IDs – The IDs of the files that are attached to the engagement

hs_body_preview

text

[en] Call notes preview – A truncated preview of the call notes

hs_body_preview_html

text

[en] HTML Body Preview – The HTML representation of the engagement body preview

hs_body_preview_is_truncated

boolean

[en] Body Preview Truncated – Indicates if the engagement body was truncated for the preview

hs_call_app_id

float

[en] Integrating App ID – The App ID associated with the integrating app

hs_call_authed_url_provider

text

[en] Authenticated recording files url provider – URL which returns Authenticated audio/video URL of the recording

hs_call_body

text

[en] Call notes – The body of the call

hs_call_callee_object_id

float

[en] Callee object id – The id of the callee

hs_call_callee_object_type

text

[en] Callee object type – The type of callee

hs_call_direction

text

[en] Call direction – The direction of a call

hs_call_disposition

text

[en] Call outcome – The outcome of the call

hs_call_duration

float

[en] Call duration – The duration of the call, in milliseconds

hs_call_external_account_id

text

[en] External Account ID – External Account ID

hs_call_external_id

text

[en] External ID – The external ID of the call

hs_call_from_number

text

[en] From Number – The phone number of the person that initiated the call

hs_call_has_transcript

boolean

[en] Transcript Available – Flag to indicate if the call has an associated transcript

hs_call_recording_url

text

[en] Recording URL – The URL of the recorded call audio

hs_call_source

text

[en] Call Source – The source of the call to differentiate VoIP vs Video Conferencing Apps

hs_call_status

text

[en] Call status – The status of the call

hs_call_title

text

[en] Call Title – The title of the call

hs_call_to_number

text

[en] To Number – The phone number of the person that was called

hs_call_transcription_id

float

[en] Call transcription id – The id of the transcription

hs_call_video_recording_url

text

[en] Video url – Video URL of the recording

hs_call_zoom_meeting_uuid

text

[en] Unique Zoom Meeting ID – The Zoom meeting unique identifier of the call

hs_calls_service_call_id

float

[en] Calls Service Call ID – The Calls Service specific global unique identifier for a call

hs_created_by

float

[en] Activity created by – The user who created the engagement

hs_created_by_user_id

float

[en] Created by user ID – The user that created this object. This value is automatically set by HubSpot and may not be modified.

hs_createdate

timestamp

[en] Create date – The date that an engagement was created

hs_engagement_source

text

[en] Engagement Source – The source that created this engagement

hs_engagement_source_id

text

[en] Engagement Source ID – The specific ID of the process that created this engagement

hs_follow_up_action

text

[en] Follow up action – What action should be performed during follow up

hs_gdpr_deleted

boolean

[en] GDPR deleted – Indicates the body of this engagement has been cleared because of a GDPR delete request

hs_lastmodifieddate

timestamp

[en] Last modified date – The date any property on this engagement was modified

hs_merged_object_ids

text

[en] Merged object IDs – The list of object IDs that have been merged into this object. This value is automatically set by HubSpot and may not be modified.

hs_modified_by

float

[en] Updated by – The user who last updated the engagement

hs_object_id

float

[en] Object ID – The unique ID for this object. This value is automatically set by HubSpot and may not be modified.

hs_product_name

text

[en] Product name – The name of the product associated with this engagement

hs_queue_membership_ids

text

[en] Queue Memberships – The list of queues that contain this engagement

hs_timestamp

timestamp

[en] Activity date – The date that an engagement occurred

hs_unique_creation_key

text

[en] Unique creation key – Unique property used for idempotent creates

hs_unique_id

text

[en] Unique ID – The unique ID of the engagement

hs_unknown_visitor_conversation

boolean

[en] Unknown Visitor Conversation – Whether or not this communication was made with an unknown visitor

hs_updated_by_user_id

float

[en] Updated by user ID – The user that last updated this object. This value is automatically set by HubSpot and may not be modified.

hs_user_ids_of_all_notification_followers

text

[en] User IDs of all notification followers – The user IDs of all users that have clicked follow within the object to opt-in to getting follow notifications

hs_user_ids_of_all_notification_unfollowers

text

[en] User IDs of all notification unfollowers – The user IDs of all object owners that have clicked unfollow within the object to opt-out of getting follow notifications

hs_user_ids_of_all_owners

text

[en] User IDs of all owners – The user IDs of all owners of this object

hubspot_owner_assigneddate

timestamp

[en] Owner Assigned Date – The timestamp when an owner was assigned to this engagement

hubspot_owner_id

text

[en] Activity assigned to – The user that the activity is assigned to in HubSpot. This can be any HubSpot user or Salesforce integration user, and can be set manually or via Workflows.

hubspot_team_id

text

[en] HubSpot Team – The team of the owner of an engagement.

hs_all_owner_ids

text

[en] All owner ids – The value of all owner referencing properties for this object, both default and custom

hs_all_team_ids

text

[en] All team ids – The team ids corresponding to all owner referencing properties for this object, both default and custom

hs_all_accessible_team_ids

text

[en] All accessible team ids – The team ids, including up the team hierarchy, corresponding to all owner referencing properties for this object, both default and custom

Esta integração está em modo beta

Esta integração não captura deleções e arquivamentos: caso um registro seja removido por arquivamento ou deleção, isso não se refletirá na sua integração. Por isso, criaremos uma integração específica de registros arquivados que você pode utilizar para remover os dados arquivados da sua visualização ou modelo. Estamos aguardando a liberação desta funcionalidade para esse endpoint pelo HubSpot. Os dados deletados não podem ser recuperados

Se durante uma execução, forem encontrados mais do que 10 mil registros atualizados dentro de um período de 100 milisegundos, ou o savepoint inicial for superior a 3 dias da data atual, será realizada uma execução integral

Engagements: Calls: Dispositions

Campo Tipo

id

text

[en] Call disposition id

label

text

[en] Call disposition label

deleted

boolean

[en] If call disposition has been deleted

Esta integração é gratuita

Engagements: Calls: objetos relacionados [Versão Atual]

Campo Tipo

calls_id

text

1_id

text

association_type

text

Esta integração está em modo beta

Engagements: Emails [Versão Atual]

Campo Tipo

id

text

createdat

timestamp

updatedat

timestamp

archived

boolean

hs_all_assigned_business_unit_ids

text

[en] Business units – The business units this record is assigned to.

hs_at_mentioned_owner_ids

text

[en] At-Mentioned Owner Ids – The owners that have been at-mentioned on the engagement

hs_attachment_ids

text

[en] Attached file IDs – The IDs of the files that are attached to the engagement

hs_body_preview

text

[en] Body preview – A truncated preview of the engagegement body

hs_body_preview_html

text

[en] HTML Body Preview – The HTML representation of the engagement body preview

hs_body_preview_is_truncated

boolean

[en] Body Preview Truncated – Indicates if the engagement body was truncated for the preview

hs_created_by

text

[en] Activity created by – The user who created the engagement

hs_created_by_user_id

float

[en] Created by user ID – The user that created this object. This value is automatically set by HubSpot and may not be modified.

hs_createdate

timestamp

[en] Create date – The date that an engagement was created

hs_direction_and_unique_id

text

[en] Email direction and unique ID – The direction and unique ID of the email concatenated by :

hs_email_attached_video_id

text

[en] Attached Video – The ID of a video optionally attached to an email

hs_email_attached_video_name

text

[en] Attached Video Name – The name of a video optionally attached to an email

hs_email_attached_video_opened

boolean

[en] Attached Video Opened – Has the video attachment been opened

hs_email_attached_video_watched

boolean

[en] Attached Video Watched – Has the video attachement been watched

hs_email_bcc_email

text

[en] Email BCC Address – Email addresses of the email's BCC recipients

hs_email_bcc_firstname

text

[en] Email BCC First Name – First names of the email's BCC recipients

hs_email_bcc_lastname

text

[en] Email BCC Last Name – Last names of the email's BCC recipients

hs_email_bcc_raw

text

[en] Email BCC – Raw header values of the email's BCC recipients

hs_email_cc_email

text

[en] Email CC Address – Email addresses of the email's CC recipients

hs_email_cc_firstname

text

[en] Email CC First Name – First names of the email's CC recipients

hs_email_cc_lastname

text

[en] Email CC Last Name – Last names of the email's CC recipients

hs_email_cc_raw

text

[en] Email CC – Raw header values of the email's CC recipients

hs_email_direction

text

[en] Email Direction – The direction the email was sent in

hs_email_encoded_email_associations_request

text

[en] Encoded Email Associations Request – Encoded email associations request

hs_email_error_message

text

[en] Error Message – The error that occurred while sending the email

hs_email_facsimile_send_id

text

[en] Email Send Id – The ID of the email send event sent through Facsimile

hs_email_from_email

text

[en] Email From Address – Email address of the email's sender

hs_email_from_firstname

text

[en] Email From First Name – First name of the email's sender

hs_email_from_lastname

text

[en] Email From Last Name – Last name of the email's sender

hs_email_from_raw

text

[en] Email From – Raw header value of the email's sender

hs_email_headers

text

[en] Email Headers – The sender and receivers of the email

hs_email_html

text

[en] Email body – This is the body of any email sent from a record. It doesn't include emails received from contacts.

hs_email_logged_from

text

[en] Logged From – Where the email was logged

hs_email_media_processing_status

text

[en] Media Processing Status – Processing status for this email's images and attachments

hs_email_member_of_forwarded_subthread

boolean

[en] Email is member of forwarded subthread – Whether this email is a member of a forwarded subthread

hs_email_message_id

text

[en] Message ID – The ID of the message

hs_email_migrated_via_portal_data_migration

boolean

[en] email_migrated_via_portal_data_migration – Indicates that the email was migrated from another portal using DataMigration tool

hs_email_pending_inline_image_ids

text

[en] Email pending inline image file IDs – File IDs of pending inline images in the email's HTML

hs_email_post_send_status

text

[en] Post-Send Status – A description of what happened to the email (successful send, bounced, dropped) and why

hs_email_recipient_drop_reasons

text

[en] Recipient-Drop Reasons – A list of the dropped recipients paired with the reason each was dropped

hs_email_send_event_id

text

[en] Email Send Event Id – The ID of the email send event

hs_email_send_event_id_created

timestamp

[en] Email Send Event Id Created – The date when the email send event ID was created

hs_email_sender_email

text

[en] Email Sender Address – Email address of the email's sender

hs_email_sender_firstname

text

[en] Email Sender First Name – First name of the email's sender

hs_email_sender_lastname

text

[en] Email Sender Last Name – Last name of the email's sender

hs_email_sender_raw

text

[en] Email Sender – Raw header value of the email's sender

hs_email_sent_via

text

[en] Sent Via – How the email was sent

hs_email_status

text

[en] Email send status – The send status of the email

hs_email_subject

text

[en] Email subject – The subject of the email

hs_email_text

text

[en] Text – The plaintext of the email

hs_email_thread_id

text

[en] Thread ID – The thread that the email belongs to

hs_email_to_email

text

[en] Email To Address – Email addresses of the email's recipients

hs_email_to_firstname

text

[en] Email To First Name – First names of the email's recipients

hs_email_to_lastname

text

[en] Email To Last Name – Last names of the email's recipients

hs_email_to_raw

text

[en] Email To – Raw header values of the email's recipients

hs_email_tracker_key

text

[en] Tracker Key – The tracker key of the email

hs_email_validation_skipped

text

[en] Validation Skipped – Validation skipped that would have otherwise rejected logging

hs_engagement_source

text

[en] Engagement Source – The source that created this engagement

hs_engagement_source_id

text

[en] Engagement Source ID – The specific ID of the process that created this engagement

hs_follow_up_action

text

[en] Follow up action – What action should be performed during follow up

hs_gdpr_deleted

boolean

[en] GDPR deleted – Indicates the body of this engagement has been cleared because of a GDPR delete request

hs_lastmodifieddate

timestamp

[en] Last modified date – The date any property on this engagement was modified

hs_merged_object_ids

text

[en] Merged object IDs – The list of object IDs that have been merged into this object. This value is automatically set by HubSpot and may not be modified.

hs_modified_by

text

[en] Updated by – The user who last updated the engagement

hs_object_id

float

[en] Object ID – The unique ID for this object. This value is automatically set by HubSpot and may not be modified.

hs_product_name

text

[en] Product name – The name of the product associated with this engagement

hs_queue_membership_ids

text

[en] Queue Memberships – The list of queues that contain this engagement

hs_timestamp

timestamp

[en] Activity date – The date that an engagement occurred

hs_unique_creation_key

text

[en] Unique creation key – Unique property used for idempotent creates

hs_unique_id

text

[en] Unique ID – The unique ID of the engagement

hs_updated_by_user_id

float

[en] Updated by user ID – The user that last updated this object. This value is automatically set by HubSpot and may not be modified.

hs_user_ids_of_all_notification_followers

text

[en] User IDs of all notification followers – The user IDs of all users that have clicked follow within the object to opt-in to getting follow notifications

hs_user_ids_of_all_notification_unfollowers

text

[en] User IDs of all notification unfollowers – The user IDs of all object owners that have clicked unfollow within the object to opt-out of getting follow notifications

hs_user_ids_of_all_owners

text

[en] User IDs of all owners – The user IDs of all owners of this object

hubspot_owner_assigneddate

timestamp

[en] Owner Assigned Date – The timestamp when an owner was assigned to this engagement

hubspot_owner_id

text

[en] Activity assigned to – The user that the activity is assigned to in HubSpot. This can be any HubSpot user or Salesforce integration user, and can be set manually or via Workflows.

hubspot_team_id

text

[en] HubSpot Team – The team of the owner of an engagement.

hs_all_owner_ids

text

[en] All owner ids – The value of all owner referencing properties for this object, both default and custom

hs_all_team_ids

text

[en] All team ids – The team ids corresponding to all owner referencing properties for this object, both default and custom

hs_all_accessible_team_ids

text

[en] All accessible team ids – The team ids, including up the team hierarchy, corresponding to all owner referencing properties for this object, both default and custom

Esta integração está em modo beta

Esta integração não captura deleções e arquivamentos: caso um registro seja removido por arquivamento ou deleção, isso não se refletirá na sua integração. Por isso, criaremos uma integração específica de registros arquivados que você pode utilizar para remover os dados arquivados da sua visualização ou modelo. Estamos aguardando a liberação desta funcionalidade para esse endpoint pelo HubSpot. Os dados deletados não podem ser recuperados

Se durante uma execução, forem encontrados mais do que 10 mil registros atualizados dentro de um período de 100 milisegundos, ou o savepoint inicial for superior a 3 dias da data atual, será realizada uma execução integral

Engagements: Emails: objetos relacionados [Versão Atual]

Campo Tipo

emails_id

text

1_id

text

association_type

text

Esta integração está em modo beta

Engagements: Meetings [Versão Atual]

Objeto principal

Campo Tipo

id

text

createdat

timestamp

updatedat

timestamp

archived

boolean

hs_activity_type

text

[en] Call and meeting type – The activity type of the engagement

hs_all_assigned_business_unit_ids

text

[en] Business units – The business units this record is assigned to.

hs_at_mentioned_owner_ids

text

[en] At-Mentioned Owner Ids – The owners that have been at-mentioned on the engagement

hs_attachment_ids

text

[en] Attached file IDs – The IDs of the files that are attached to the engagement

hs_attendee_owner_ids

text

[en] HubSpot attendee owner IDs – List of HubSpot owner IDs for additional attendees

hs_body_preview

text

[en] Body preview – A truncated preview of the engagegement body

hs_body_preview_html

text

[en] HTML Body Preview – The HTML representation of the engagement body preview

hs_body_preview_is_truncated

boolean

[en] Body Preview Truncated – Indicates if the engagement body was truncated for the preview

hs_created_by

float

[en] Activity created by – The user who created the engagement

hs_created_by_user_id

float

[en] Created by user ID – The user that created this object. This value is automatically set by HubSpot and may not be modified.

hs_createdate

timestamp

[en] Create date – The date that an engagement was created

hs_engagement_source

text

[en] Engagement Source – The source that created this engagement

hs_engagement_source_id

text

[en] Engagement Source ID – The specific ID of the process that created this engagement

hs_follow_up_action

text

[en] Follow up action – What action should be performed during follow up

hs_gdpr_deleted

boolean

[en] GDPR deleted – Indicates the body of this engagement has been cleared because of a GDPR delete request

hs_i_cal_uid

text

[en] iCalUid – The iCalUid of the synced event

hs_internal_meeting_notes

text

[en] Internal Meeting Notes –

hs_lastmodifieddate

timestamp

[en] Last modified date – The date any property on this engagement was modified

hs_meeting_body

text

[en] Meeting description – The text description of the meeting

hs_meeting_calendar_event_hash

text

[en] Meeting calendar event hash – The unique hash for the meeting

hs_meeting_change_id

text

[en] Meeting change id – The unique change id for the meeting

hs_meeting_created_from_link_id

text

[en] Created From Link ID – Created From Link ID

hs_meeting_end_time

timestamp

[en] Meeting end time – The date when the meeting ends

hs_meeting_external_url

text

[en] External URL – The external URL for the meeting

hs_meeting_location

text

[en] Meeting location – Where the meeting takes place

hs_meeting_location_type

text

[en] Location type – The type of location for the meeting event

hs_meeting_outcome

text

[en] Meeting outcome – The outcome of this meeting

hs_meeting_pre_meeting_prospect_reminders

text

[en] Pre-meeting prospect reminders – A list of dates when meeting reminders should be sent to prospects

hs_meeting_source

text

[en] Meeting source – The source where the meeting was booked

hs_meeting_source_id

text

[en] Source ID – The source ID of the meeting

hs_meeting_start_time

timestamp

[en] Meeting start time – The date when the meeting starts

hs_meeting_title

text

[en] Meeting name – The title of the meeting

hs_meeting_web_conference_meeting_id

text

[en] Web conference meeting ID – The meeting ID of the web conference

hs_merged_object_ids

text

[en] Merged object IDs – The list of object IDs that have been merged into this object. This value is automatically set by HubSpot and may not be modified.

hs_modified_by

float

[en] Updated by – The user who last updated the engagement

hs_object_id

float

[en] Object ID – The unique ID for this object. This value is automatically set by HubSpot and may not be modified.

hs_product_name

text

[en] Product name – The name of the product associated with this engagement

hs_queue_membership_ids

text

[en] Queue Memberships – The list of queues that contain this engagement

hs_scheduled_tasks

text

[en] Scheduled tasks

hs_timestamp

timestamp

[en] Activity date – The date that an engagement occurred

hs_unique_creation_key

text

[en] Unique creation key – Unique property used for idempotent creates

hs_unique_id

text

[en] Unique ID – The unique ID of the engagement

hs_updated_by_user_id

float

[en] Updated by user ID – The user that last updated this object. This value is automatically set by HubSpot and may not be modified.

hs_user_ids_of_all_notification_followers

text

[en] User IDs of all notification followers – The user IDs of all users that have clicked follow within the object to opt-in to getting follow notifications

hs_user_ids_of_all_notification_unfollowers

text

[en] User IDs of all notification unfollowers – The user IDs of all object owners that have clicked unfollow within the object to opt-out of getting follow notifications

hs_user_ids_of_all_owners

text

[en] User IDs of all owners – The user IDs of all owners of this object

hubspot_owner_assigneddate

timestamp

[en] Owner Assigned Date – The timestamp when an owner was assigned to this engagement

hubspot_owner_id

text

[en] Activity assigned to – The user that the activity is assigned to in HubSpot. This can be any HubSpot user or Salesforce integration user, and can be set manually or via Workflows.

hubspot_team_id

text

[en] HubSpot Team – The team of the owner of an engagement.

hs_all_owner_ids

text

[en] All owner ids – The value of all owner referencing properties for this object, both default and custom

hs_all_team_ids

text

[en] All team ids – The team ids corresponding to all owner referencing properties for this object, both default and custom

hs_all_accessible_team_ids

text

[en] All accessible team ids – The team ids, including up the team hierarchy, corresponding to all owner referencing properties for this object, both default and custom

hubspot_engagements_meetings_scheduledtasks

Campo Tipo

meeting_id

text

timestamp

timestamp

portalid

text

engagementtype

text

tasktype

text

uuid

text

Esta integração está em modo beta

Esta integração não captura deleções e arquivamentos: caso um registro seja removido por arquivamento ou deleção, isso não se refletirá na sua integração. Por isso, criaremos uma integração específica de registros arquivados que você pode utilizar para remover os dados arquivados da sua visualização ou modelo. Estamos aguardando a liberação desta funcionalidade para esse endpoint pelo HubSpot. Os dados deletados não podem ser recuperados

Se durante uma execução, forem encontrados mais do que 10 mil registros atualizados dentro de um período de 100 milisegundos, ou o savepoint inicial for superior a 3 dias da data atual, será realizada uma execução integral

Engagements: Meetings: objetos relacionados [Versão Atual]

Campo Tipo

meetings_id

text

1_id

text

association_type

text

Esta integração está em modo beta

Engagements: Notes [Versão Atual]

Campo Tipo

id

text

createdat

timestamp

updatedat

timestamp

archived

boolean

hs_all_assigned_business_unit_ids

text

[en] Business units – The business units this record is assigned to.

hs_at_mentioned_owner_ids

text

[en] At-Mentioned Owner Ids – The owners that have been at-mentioned on the engagement

hs_attachment_ids

text

[en] Attached file IDs – The IDs of the files that are attached to the engagement

hs_body_preview

text

[en] Body preview – A truncated preview of the engagegement body

hs_body_preview_html

text

[en] HTML Body Preview – The HTML representation of the engagement body preview

hs_body_preview_is_truncated

boolean

[en] Body Preview Truncated – Indicates if the engagement body was truncated for the preview

hs_created_by

float

[en] Activity created by – The user who created the engagement

hs_created_by_user_id

float

[en] Created by user ID – The user that created this object. This value is automatically set by HubSpot and may not be modified.

hs_createdate

timestamp

[en] Create date – The date that an engagement was created

hs_engagement_source

text

[en] Engagement Source – The source that created this engagement

hs_engagement_source_id

text

[en] Engagement Source ID – The specific ID of the process that created this engagement

hs_follow_up_action

text

[en] Follow up action – What action should be performed during follow up

hs_gdpr_deleted

boolean

[en] GDPR deleted – Indicates the body of this engagement has been cleared because of a GDPR delete request

hs_lastmodifieddate

timestamp

[en] Last modified date – The date any property on this engagement was modified

hs_merged_object_ids

text

[en] Merged object IDs – The list of object IDs that have been merged into this object. This value is automatically set by HubSpot and may not be modified.

hs_modified_by

float

[en] Updated by – The user who last updated the engagement

hs_note_body

text

[en] Note body – The body of the note

hs_object_id

float

[en] Object ID – The unique ID for this object. This value is automatically set by HubSpot and may not be modified.

hs_product_name

text

[en] Product name – The name of the product associated with this engagement

hs_queue_membership_ids

text

[en] Queue Memberships – The list of queues that contain this engagement

hs_timestamp

timestamp

[en] Activity date – The date that an engagement occurred

hs_unique_creation_key

text

[en] Unique creation key – Unique property used for idempotent creates

hs_unique_id

text

[en] Unique ID – The unique ID of the engagement

hs_updated_by_user_id

float

[en] Updated by user ID – The user that last updated this object. This value is automatically set by HubSpot and may not be modified.

hs_user_ids_of_all_notification_followers

text

[en] User IDs of all notification followers – The user IDs of all users that have clicked follow within the object to opt-in to getting follow notifications

hs_user_ids_of_all_notification_unfollowers

text

[en] User IDs of all notification unfollowers – The user IDs of all object owners that have clicked unfollow within the object to opt-out of getting follow notifications

hs_user_ids_of_all_owners

text

[en] User IDs of all owners – The user IDs of all owners of this object

hubspot_owner_assigneddate

timestamp

[en] Owner Assigned Date – The timestamp when an owner was assigned to this engagement

hubspot_owner_id

text

[en] Activity assigned to – The user that the activity is assigned to in HubSpot. This can be any HubSpot user or Salesforce integration user, and can be set manually or via Workflows.

hubspot_team_id

text

[en] HubSpot Team – The team of the owner of an engagement.

hs_all_owner_ids

text

[en] All owner ids – The value of all owner referencing properties for this object, both default and custom

hs_all_team_ids

text

[en] All team ids – The team ids corresponding to all owner referencing properties for this object, both default and custom

hs_all_accessible_team_ids

text

[en] All accessible team ids – The team ids, including up the team hierarchy, corresponding to all owner referencing properties for this object, both default and custom

Esta integração está em modo beta

Esta integração não captura deleções e arquivamentos: caso um registro seja removido por arquivamento ou deleção, isso não se refletirá na sua integração. Por isso, criaremos uma integração específica de registros arquivados que você pode utilizar para remover os dados arquivados da sua visualização ou modelo. Estamos aguardando a liberação desta funcionalidade para esse endpoint pelo HubSpot. Os dados deletados não podem ser recuperados

Se durante uma execução, forem encontrados mais do que 10 mil registros atualizados dentro de um período de 100 milisegundos, ou o savepoint inicial for superior a 3 dias da data atual, será realizada uma execução integral

Engagements: Notes: objetos relacionados [Versão Atual]

Campo Tipo

notes_id

text

1_id

text

association_type

text

Esta integração está em modo beta

Engagements: Tasks [Versão Atual]

Objeto principal

Campo Tipo

id

text

createdat

timestamp

updatedat

timestamp

archived

boolean

hs_all_assigned_business_unit_ids

text

[en] Business units – The business units this record is assigned to.

hs_at_mentioned_owner_ids

text

[en] At-Mentioned Owner Ids – The owners that have been at-mentioned on the engagement

hs_attachment_ids

text

[en] Attached file IDs – The IDs of the files that are attached to the engagement

hs_body_preview

text

[en] Notes (preview) – A plain-text preview of the notes field on a task

hs_body_preview_html

text

[en] HTML Body Preview – The HTML representation of the engagement body preview

hs_body_preview_is_truncated

boolean

[en] Body Preview Truncated – Indicates if the engagement body was truncated for the preview

hs_calendar_event_id

text

[en] Calendar Event ID – The event ID for the synced task.

hs_created_by

float

[en] Created by – The user who created the engagement

hs_created_by_user_id

float

[en] Created by user ID – The user that created this object. This value is automatically set by HubSpot and may not be modified.

hs_createdate

timestamp

[en] Created at – The date that an engagement was created

hs_engagement_source

text

[en] Source – The source that created this engagement

hs_engagement_source_id

text

[en] Source ID – The specific ID of the process that created this engagement

hs_follow_up_action

text

[en] Follow up action – What action should be performed during follow up

hs_gdpr_deleted

boolean

[en] GDPR deleted – Indicates the body of this engagement has been cleared because of a GDPR delete request

hs_lastmodifieddate

timestamp

[en] Last modified at – The date any property on this engagement was modified

hs_merged_object_ids

text

[en] Merged object IDs – The list of object IDs that have been merged into this object. This value is automatically set by HubSpot and may not be modified.

hs_modified_by

float

[en] Last modified by – The user who last updated the engagement

hs_msteams_message_id

text

[en] MS Teams message ID – The message ID for the created task.

hs_num_associated_companies

float

[en] Associated Companies – The number of companies associated with this task

hs_num_associated_contacts

float

[en] Associated Contacts – The number of contacts associated with this task

hs_num_associated_deals

float

[en] Associated Deals – The number of deals associated with this task

hs_num_associated_queue_objects

float

[en] Associated Queue Objects – The number of objects associated with this task that support task queues

hs_num_associated_tickets

float

[en] Associated Tickets – The number of tickets associated with this task

hs_object_id

float

[en] Object ID – The unique ID for this object. This value is automatically set by HubSpot and may not be modified.

hs_product_name

text

[en] Product name – The name of the product associated with this engagement

hs_queue_membership_ids

text

[en] Queue – The list of queues that contain this engagement

hs_task_body

text

[en] Notes – The content in the notes field on a task

hs_task_completion_date

timestamp

[en] Completed at – The date that the task was completed

hs_task_contact_timezone

text

[en] Contact Time Zone – The time zone of the associated contact

hs_task_for_object_type

text

[en] For Object Type – The object type for the task

hs_task_is_all_day

boolean

[en] Task is all day – Determines if the task is due all day or at a specific time

hs_task_last_contact_outreach

timestamp

[en] Last contacted – The last time a call, email, or meeting was logged for the associated contact. This is set automatically by HubSpot based on user actions in the contact record

hs_task_last_sales_activity_timestamp

timestamp

[en] Last engagement – The date of the last sales activity with the associated contact. This is set automatically by HubSpot based on user actions in the contact record

hs_task_priority

text

[en] Priority – The priority of task

hs_task_probability_to_complete

float

[en] Task probability to complete – The probability the task will be completed

hs_task_relative_reminders

text

[en] Relative Task Reminders – The dates (relative to the due date) when reminders will be sent

hs_task_reminders

text

[en] Reminder – The dates when reminders will be sent

hs_task_repeat_interval

text

[en] Interval – How often the task should repeat

hs_task_send_default_reminder

text

[en] Send Default Reminder – Whether or not a reminder should be sent when the task is due

hs_task_sequence_enrollment_active

boolean

[en] Sequence Enrollment Is Active – Whether the sequence enrollment this task is a part of is currently active

hs_task_sequence_step_enrollment_id

text

[en] Sequence step enrollment Id – The id of the sequence step that created the task

hs_task_sequence_step_order

float

[en] Sequence Step Order – The order of this task in the sequence at time of enrollment

hs_task_status

text

[en] Status – The status of the task

hs_task_subject

text

[en] Title – The subject text for the task

hs_task_template_id

float

[en] Task template id – The id of template the task was created from

hs_task_type

text

[en] Type – The type of task

hs_timestamp

timestamp

[en] Due date – The date that an engagement occurred

hs_unique_creation_key

text

[en] Unique creation key – Unique property used for idempotent creates

hs_unique_id

text

[en] Unique ID – The unique ID of the engagement

hs_updated_by_user_id

float

[en] Updated by user ID – The user that last updated this object. This value is automatically set by HubSpot and may not be modified.

hs_user_ids_of_all_notification_followers

text

[en] User IDs of all notification followers – The user IDs of all users that have clicked follow within the object to opt-in to getting follow notifications

hs_user_ids_of_all_notification_unfollowers

text

[en] User IDs of all notification unfollowers – The user IDs of all object owners that have clicked unfollow within the object to opt-out of getting follow notifications

hs_user_ids_of_all_owners

text

[en] User IDs of all owners – The user IDs of all owners of this object

hubspot_owner_assigneddate

timestamp

[en] Owner Assigned Date – The timestamp when an owner was assigned to this engagement

hubspot_owner_id

text

[en] Assigned to – The user that the activity is assigned to in HubSpot. This can be any HubSpot user or Salesforce integration user, and can be set manually or via Workflows.

hubspot_team_id

text

[en] HubSpot Team – The team of the owner of an engagement.

hs_all_owner_ids

text

[en] All owner ids – The value of all owner referencing properties for this object, both default and custom

hs_all_team_ids

text

[en] All team ids – The team ids corresponding to all owner referencing properties for this object, both default and custom

hs_all_accessible_team_ids

text

[en] All accessible team ids – The team ids, including up the team hierarchy, corresponding to all owner referencing properties for this object, both default and custom

hubspot_engagements_tasks_scheduledtasks

Campo Tipo

task_id

text

timestamp

timestamp

portalid

text

engagementtype

text

tasktype

text

uuid

text

Esta integração está em modo beta

Esta integração não captura deleções e arquivamentos: caso um registro seja removido por arquivamento ou deleção, isso não se refletirá na sua integração. Por isso, criaremos uma integração específica de registros arquivados que você pode utilizar para remover os dados arquivados da sua visualização ou modelo. Estamos aguardando a liberação desta funcionalidade para esse endpoint pelo HubSpot. Os dados deletados não podem ser recuperados

Se durante uma execução, forem encontrados mais do que 10 mil registros atualizados dentro de um período de 100 milisegundos, ou o savepoint inicial for superior a 3 dias da data atual, será realizada uma execução integral

Engagements: Tasks: objetos relacionados [Versão Atual]

Campo Tipo

tasks_id

text

1_id

text

association_type

text

Esta integração está em modo beta

Line Items

Esta integração trará os Line Items e todas as suas propriedades em formato colunar – de acordo com a configuração da sua conta, em um formato similar ao abaixo:

Campo Tipo

id

text

createdat

timestamp

updatedat

timestamp

archived

boolean

property_x

text

property_y

text

property_z

text

Esta integração não captura deleções e arquivamentos: caso um registro seja removido por arquivamento ou deleção, isso não se refletirá na sua integração. Por isso, criamos uma integração específica de registros arquivados que você pode utilizar para remover os dados arquivados da sua visualização ou modelo. Os dados deletados não podem ser recuperados

Por padrão, todas as propriedades customizadas existentes na sua conta serão trazidas. Entretando, utilizar muitas propriedades pode impactar a velocidade de leitura dos dados. Recomendamos que você utilize apenas as propriedades necessárias, selecionando as que deseja na tela de criação/edição de integração, no momento de dar nome às tabelas, basta clicar em CAMPOS e desmarcar/marcar as propriedades/colunas desejadas

Se durante uma execução, forem encontrados mais do que 10 mil registros atualizados dentro de um período de 100 milisegundos, ou o savepoint inicial for superior a 3 dias da data atual, será realizada uma execução integral

Line Items arquivados [Versão Atual]

Campo Tipo

id

text

archived

boolean

archivedat

timestamp

createdat

timestamp

properties__amount

float

properties__createdate

timestamp

properties__hs_lastmodifieddate

timestamp

properties__hs_product_id

text

properties__quantity

float

updatedat

timestamp

Line Items: deals relacionados

Campo Tipo

line_item_id

text

deal_id

text

association_type

text

Products

Esta integração trará os Produtos e todas as suas propriedades em formato colunar – de acordo com a configuração da sua conta, em um formato similar ao abaixo:

Campo Tipo

id

text

createdat

timestamp

updatedat

timestamp

archived

boolean

property_x

text

property_y

text

property_z

text

Por padrão, todas as propriedades customizadas existentes na sua conta serão trazidas. Entretando, utilizar muitas propriedades pode impactar a velocidade de leitura dos dados. Recomendamos que você utilize apenas as propriedades necessárias, selecionando as que deseja na tela de criação/edição de integração, no momento de dar nome às tabelas, basta clicar em CAMPOS e desmarcar/marcar as propriedades/colunas desejadas

Se durante uma execução, forem encontrados mais do que 10 mil registros atualizados dentro de um período de 100 milisegundos, ou o savepoint inicial for superior a 3 dias da data atual, será realizada uma execução integral

Feedback Submissions

Esta integração trará as pesquisas Net Promoter Score (NPS), Customer Satisfaction (CSAT), Customer Effort Score (CES) e Custom Surveys e todas as suas propriedades em formato colunar – de acordo com a configuração da sua conta, em um formato similar ao abaixo:

Campo Tipo

id

text

createdat

timestamp

updatedat

timestamp

archived

boolean

property_x

text

property_y

text

property_z

text

Por padrão, todas as propriedades customizadas existentes na sua conta serão trazidas. Entretando, utilizar muitas propriedades pode impactar a velocidade de leitura dos dados. Recomendamos que você utilize apenas as propriedades necessárias, selecionando as que deseja na tela de criação/edição de integração, no momento de dar nome às tabelas, basta clicar em CAMPOS e desmarcar/marcar as propriedades/colunas desejadas

Se durante uma execução, forem encontrados mais do que 10 mil registros atualizados dentro de um período de 100 milisegundos, ou o savepoint inicial for superior a 3 dias da data atual, será realizada uma execução integral

Objeto customizado

Campo Tipo

id

text

createdat

timestamp

updatedat

timestamp

archived

boolean

property_x

text

property_y

text

property_z

text

Por padrão, todas as propriedades customizadas existentes na sua conta serão trazidas. Entretando, utilizar muitas propriedades pode impactar a velocidade de leitura dos dados. Recomendamos que você utilize apenas as propriedades necessárias, selecionando as que deseja na tela de criação/edição de integração, no momento de dar nome às tabelas, basta clicar em CAMPOS e desmarcar/marcar as propriedades/colunas desejadas

Se durante uma execução, forem encontrados mais do que 10 mil registros atualizados dentro de um período de 100 milisegundos, ou o savepoint inicial for superior a 3 dias da data atual, será realizada uma execução integral

Associações

Campo Tipo

_id

text

_id

text

association_type

text