Missing Columns, Tables, or Valueslink
Issuelink
Columns, tables, or values are missing in the destination.
Environmentlink
Connector: HubSpot
Answerlink
Missing columns or tableslink
The HubSpot connector doesn't support the creation of empty tables and columns. As a result, we will not sync columns or tables to the destination if there is no applicable data in the source. See our HubSpot sync strategy for more information.
Missing engagement columns and tableslink
If you are missing an engagement table, check if we support it by doing the following:
- In HubSpot, find which HubSpot subscription your organization uses.
- Look for the table associated with your subscription in our HubSpot ERD.
We sync engagement columns to the relevant engagement child table with the name convention property_hs_<field>
. If you can't find an engagement column, go to the Schema tab in your HubSpot connector dashboard and click Schema settings. If your schema change setting is set to Block all, you must select each applicable column individually from the schema config.
Missing association columnslink
Association tables create associations between objects but don't contain columns related to the object. We will sync an object's columns to the relevant object's table. See our custom objects documentation for more information.
Missing deal_pipeline_stage_id
datalink
We populate deal_pipeline_stage_id
data into the DEAL_STAGE
table instead of the DEAL_PROPERTY_HISTORY
table.
Missing records or null
valueslink
When we deprecate a column or table, we may either no longer populate it with data or populate it with null
values. See our Hubspot release notes for more information on deprecated tables and columns.