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

Integrações

Índice

Gráfico de relacionamento

Clique para ampliar

Associações

Campo Tipo

_id

text

_id

text

association_type

text

Contatos

  • 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
  • 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
Campo Tipo

id

text

createdat

timestamp

updatedat

timestamp

archived

boolean

property_x

text

property_y

text

property_z

text

Contatos arquivados

Campo Tipo

id

text

    Contatos > > id

archived

boolean

archivedat

timestamp

createdat

timestamp

properties__createdate

timestamp

properties__email

text

properties__firstname

text

properties__lastmodifieddate

timestamp

properties__lastname

text

updatedat

timestamp

Contatos: companhias relacionadas

Campo Tipo

contact_id

text

    Contatos > > id

company_id

text

    Empresas > > id

association_type

text

Contatos: deals relacionados

Campo Tipo

contact_id

text

    Contatos > > id

deal_id

text

    Negócios > > id

association_type

text

Contatos: formulários enviados

  • Esta integração é baseada na integração de Contatos da versão anterior da API  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

Objeto principal

Campo Tipo

vid

text

    Contatos > > id

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

contacts_form_submissions__contact_associated_by

Campo Tipo

vid

text

conversion_id

text

associated_by

text

Contatos: pertencimento a listas

  • Esta integração é baseada na integração de Contatos da versão anterior da API  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

    Contatos > > id

timestamp

timestamp

static_list_id

text

    Listas de contatos > > listid

internal_list_id

text

is_member

boolean

Contatos: tickets relacionados

Campo Tipo

contact_id

text

    Contatos > > id

ticket_id

text

    Tickets > > id

association_type

text

Negócios arquivados

Campo Tipo

id

text

    Negócios > > id

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

Negócios: tickets relacionados

Campo Tipo

deal_id

text

    Negócios > > id

ticket_id

text

    Tickets > > id

association_type

text

E-mails de marketing

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

Email events

hubspot_email_events_sent

Campo Tipo

id

text

appname

text

emailcampaignid

text

    E-mails de marketing > email_campaigns > campaign_id

smtpid

text

appid

float

emailcampaigngroupid

float

recipient

text

response

text

attempt

float

portalid

float

created

float

sentby__id

text

sentby__created

float

type

text

hubspot_email_events_sent

Campo Tipo

id

text

source

text

portalid

float

appid

float

subscriptions

text

sourceid

text

type

text

emailcampaignid

text

    E-mails de marketing > email_campaigns > campaign_id

created

float

recipient

text

hubspot_email_events_sent

Campo Tipo

id

text

appname

text

emailcampaignid

text

    E-mails de marketing > email_campaigns > campaign_id

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

hubspot_email_events_sent

Campo Tipo

id

text

appname

text

emailcampaignid

text

    E-mails de marketing > email_campaigns > campaign_id

portalid

float

appid

float

emailcampaigngroupid

float

recipient

text

response

text

attempt

float

smtpid

text

created

float

sentby__id

text

sentby__created

float

type

text

hubspot_email_events_sent

Campo Tipo

appname

text

type

text

emailcampaignid

text

    E-mails de marketing > email_campaigns > campaign_id

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

hubspot_email_events_sent

Campo Tipo

id

text

appname

text

emailcampaignid

text

    E-mails de marketing > email_campaigns > campaign_id

portalid

float

appid

float

recipient

text

attempt

text

smtpid

text

created

float

sentby__id

text

sentby__created

float

type

text

hubspot_email_events_sent

Campo Tipo

id

text

status

text

appname

text

emailcampaignid

text

    E-mails de marketing > email_campaigns > campaign_id

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

hubspot_email_events_sent

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

text

    E-mails de marketing > email_campaigns > campaign_id

browser__family

text

browser__name

text

browser__producer

text

browser__url

text

browser__producerurl

text

browser__version

text

browser__type

text

hubspot_email_events_sent

Campo Tipo

id

text

from

text

appname

text

replyto

text

type

text

emailcampaignid

text

    E-mails de marketing > email_campaigns > campaign_id

created

float

bcc

text

portalid

float

appid

float

emailcampaigngroupid

float

smtpid

text

sentby__id

text

sentby__created

float

recipient

text

cc

text

subject

text

hubspot_email_events_sent

Campo Tipo

id

text

appname

text

emailcampaignid

text

    E-mails de marketing > email_campaigns > campaign_id

smtpid

text

appid

float

emailcampaigngroupid

float

recipient

text

attempt

float

portalid

float

created

float

sentby__id

text

sentby__created

float

type

text

Empresas

  • 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
  • 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
Campo Tipo

id

text

createdat

timestamp

updatedat

timestamp

archived

boolean

property_x

text

property_y

text

property_z

text

Empresas arquivadas

Campo Tipo

id

text

    Empresas > > id

archived

boolean

archivedat

timestamp

createdat

timestamp

properties__createdate

timestamp

properties__domain

text

properties__hs_lastmodifieddate

timestamp

properties__name

text

updatedat

timestamp

Empresas: contatos relacionados

Campo Tipo

company_id

text

    Empresas > > id

contact_id

text

    Contatos > > id

association_type

text

Empresas: negócios relacionados

Campo Tipo

company_id

text

    Empresas > > id

deal_id

text

    Negócios > > id

association_type

text

Empresas: tickets relacionados

Campo Tipo

company_id

text

    Empresas > > id

ticket_id

text

    Tickets > > id

association_type

text

Envios de feedback

  • 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
  • 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
Campo Tipo

id

text

createdat

timestamp

updatedat

timestamp

archived

boolean

property_x

text

property_y

text

property_z

text

Histórico de propriedades

Campo Tipo

object_id

text

[en] ID of the object the property belongs to

property

text

[en] Name of the property

value

text

[en] Value of the property

timestamp

timestamp

[en] Timestamp of the property value

sourcetype

text

[en] Type of the source that updated the property value

sourceid

text

[en] Id of the source that updated the property value

updatedbyuserid

text

[en] Id of the user that updated the property value

Interações: Anotações

  • 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
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

Interações: Anotações: objetos relacionados

Campo Tipo

notes_id

text

    Interações: Anotações > > id

1_id

text

    Contatos > > id

    Negócios > > id

    Empresas > > id

    Tickets > > id

association_type

text

Interações: Chamadas

 

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
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

    Interações: Chamadas: Disposições > > id

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

Interações: Chamadas: Disposições

  • Esta integração é gratuita
Campo Tipo

id

text

[en] Call disposition id

label

text

[en] Call disposition label

deleted

boolean

[en] If call disposition has been deleted

Interações: Chamadas: objetos relacionados

Campo Tipo

calls_id

text

    Interações: Chamadas > > id

1_id

text

    Contatos > > id

    Negócios > > id

    Empresas > > id

    Tickets > > id

association_type

text

Interações: E-mails

  • 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
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

Interações: E-mails: objetos relacionados

Campo Tipo

emails_id

text

    Interações: E-mails > > id

1_id

text

    Contatos > > id

    Negócios > > id

    Empresas > > id

    Tickets > > id

association_type

text

Interações: Reuniões: objetos relacionados

Campo Tipo

meetings_id

text

    Interações: Reuniões > > id

1_id

text

    Contatos > > id

    Negócios > > id

    Empresas > > id

    Tickets > > id

association_type

text

Interações: Reuniões

  • 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

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_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

Interações: Tarefas

  • 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

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

Interações: Tarefas: objetos relacionados

Campo Tipo

tasks_id

text

    Interações: Tarefas > > id

1_id

text

    Contatos > > id

    Negócios > > id

    Empresas > > id

    Tickets > > id

association_type

text

Itens de linha

  • 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
  • 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
Campo Tipo

id

text

createdat

timestamp

updatedat

timestamp

archived

boolean

property_x

text

property_y

text

property_z

text

Itens de linha arquivados

Campo Tipo

id

text

    Itens de linha > > id

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

Itens de linha: negócios relacionados

Campo Tipo

line_item_id

text

    Itens de linha > > id

deal_id

text

    Negócios > > id

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

Negócios

  • 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:
  • 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
Campo Tipo

id

text

createdat

timestamp

updatedat

timestamp

archived

boolean

property_x

text

property_y

text

property_z

text

Negócios: contatos relacionados

Campo Tipo

deal_id

text

    Negócios > > id

contact_id

text

    Contatos > > id

association_type

text

Negócios: empresas relacionadas

Campo Tipo

deal_id

text

    Negócios > > id

company_id

text

    Empresas > > id

association_type

text

Objeto customizado

  • Por padrão, todas as propriedades customizadas existentes na sua conta serão trazidas. Entretanto, 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
Campo Tipo

id

text

createdat

timestamp

updatedat

timestamp

archived

boolean

property_x

text

property_y

text

property_z

text

Pipelines

  • Esta integração é gratuita

Objeto principal

Campo Tipo

default

boolean

displayorder

float

updatedat

float

active

boolean

objecttypeid

text

pipelineid

text

label

text

createdat

float

objecttype

text

hubspot_pipelines__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

Produtos

  • 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
  • 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
Campo Tipo

id

text

createdat

timestamp

updatedat

timestamp

archived

boolean

property_x

text

property_y

text

property_z

text

Proprietários

  • Esta integração é integral

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

Tickets

  • 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
  • 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
Campo Tipo

id

text

createdat

timestamp

updatedat

timestamp

archived

boolean

property_x

text

property_y

text

property_z

text

Tickets arquivados

Campo Tipo

id

text

    Tickets > > id

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: empresas relacionadas

Campo Tipo

ticket_id

text

    Tickets > > id

company_id

text

    Empresas > > id

association_type

text

Tickets: contatos relacionados

Campo Tipo

ticket_id

text

    Tickets > > id

contact_id

text

    Contatos > > id

association_type

text

Tickets: negócios relacionados

Campo Tipo

ticket_id

text

    Tickets > > id

deal_id

text

    Negócios > > id

association_type

text