You can't use this until you register with us!

Description

Use information in HubSpot to update data in BigQuery.

Purchasing Options

HubSpot to BigQuery Loader - $99.99 / month

Available Actions

Update Contacts

Use contact information in HubSpot to update data in BigQuery.

Variables

Source Parameters
hubspot_con required

API Key or Access Token to connect to HubSpot.

col_names required

Shared Config containing mappings between BigQuery column names and HubSpot contact property names.

last_run required

Datetime stamp indicating the last run time. Formatted as YYYY-MM-DD HH:MM:SS in UTC timezone.


Destination Parameters
gcp_con required

Credentials to use to access the BigQuery Cloud Data Warehouse.

project required

Name of the project with the dataset where the data will be updated.

dataset required

Name of the dataset with the table where the data will be updated.

table required

Name of the table where the data will be updated.

insert_only required

Enable to append data retrieved directly to the table without any deduplication against existing rows beforehand.

process_increment required

This Task will process data in increments. Set a value in this field to determine the size of each increment.


Update Companies

Use company information in HubSpot to update data in BigQuery.

Variables

Source Parameters
hubspot_con required

API Key or Access Token to connect to HubSpot.

col_names required

Shared Config containing mappings between BigQuery column names and HubSpot contact property names.

last_run required

Datetime stamp indicating the last run time. Formatted as YYYY-MM-DD HH:MM:SS in UTC timezone.


Destination Parameters
gcp_con required

Credentials to use to access the BigQuery Cloud Data Warehouse.

project required

Name of the project with the dataset where the data will be updated.

dataset required

Name of the dataset with the table where the data will be updated.

table required

Name of the table where the data will be updated.

insert_only required

Enable to append data retrieved directly to the table without any deduplication against existing rows beforehand.

process_increment required

This Task will process data in increments. Set a value in this field to determine the size of each increment.


Update Deals

Use deal information in HubSpot to update data in BigQuery.

Variables

Source Parameters
hubspot_con required

API Key or Access Token to connect to HubSpot.

col_names required

Shared Config containing mappings between BigQuery column names and HubSpot contact property names.

last_run required

Datetime stamp indicating the last run time. Formatted as YYYY-MM-DD HH:MM:SS in UTC timezone.


Destination Parameters
gcp_con required

Credentials to use to access the BigQuery Cloud Data Warehouse.

project required

Name of the project with the dataset where the data will be updated.

dataset required

Name of the dataset with the table where the data will be updated.

table required

Name of the table where the data will be updated.

insert_only required

Enable to append data retrieved directly to the table without any deduplication against existing rows beforehand.

process_increment required

This Task will process data in increments. Set a value in this field to determine the size of each increment.


Update Products

Use product information in HubSpot to update data in BigQuery.

Variables

Source Parameters
hubspot_con required

API Key or Access Token to connect to HubSpot.

col_names required

Shared Config containing mappings between BigQuery column names and HubSpot contact property names.

last_run required

Datetime stamp indicating the last run time. Formatted as YYYY-MM-DD HH:MM:SS in UTC timezone.


Destination Parameters
gcp_con required

Credentials to use to access the BigQuery Cloud Data Warehouse.

project required

Name of the project with the dataset where the data will be updated.

dataset required

Name of the dataset with the table where the data will be updated.

table required

Name of the table where the data will be updated.

insert_only required

Enable to append data retrieved directly to the table without any deduplication against existing rows beforehand.

process_increment required

This Task will process data in increments. Set a value in this field to determine the size of each increment.


Update Tickets

Use ticket information in HubSpot to update data in BigQuery.

Variables

Source Parameters
hubspot_con required

API Key or Access Token to connect to HubSpot.

col_names required

Shared Config containing mappings between BigQuery column names and HubSpot contact property names.

last_run required

Datetime stamp indicating the last run time. Formatted as YYYY-MM-DD HH:MM:SS in UTC timezone.


Destination Parameters
gcp_con required

Credentials to use to access the BigQuery Cloud Data Warehouse.

project required

Name of the project with the dataset where the data will be updated.

dataset required

Name of the dataset with the table where the data will be updated.

table required

Name of the table where the data will be updated.

insert_only required

Enable to append data retrieved directly to the table without any deduplication against existing rows beforehand.

process_increment required

This Task will process data in increments. Set a value in this field to determine the size of each increment.


Update Quotes

Use quote information in HubSpot to update data in BigQuery.

Variables

Source Parameters
hubspot_con required

API Key or Access Token to connect to HubSpot.

col_names required

Shared Config containing mappings between BigQuery column names and HubSpot contact property names.

last_run required

Datetime stamp indicating the last run time. Formatted as YYYY-MM-DD HH:MM:SS in UTC timezone.


Destination Parameters
gcp_con required

Credentials to use to access the BigQuery Cloud Data Warehouse.

project required

Name of the project with the dataset where the data will be updated.

dataset required

Name of the dataset with the table where the data will be updated.

table required

Name of the table where the data will be updated.

insert_only required

Enable to append data retrieved directly to the table without any deduplication against existing rows beforehand.

process_increment required

This Task will process data in increments. Set a value in this field to determine the size of each increment.


Update Owners

Use owners information in HubSpot to update data in BigQuery.

Variables

Source Parameters
hubspot_con required

API Key or Access Token to connect to HubSpot.

col_names required

Shared Config containing mappings between BigQuery column names and HubSpot contact property names.


Destination Parameters
gcp_con required

Credentials to use to access the BigQuery Cloud Data Warehouse.

project required

Name of the project with the dataset where the data will be updated.

dataset required

Name of the dataset with the table where the data will be updated.

table required

Name of the table where the data will be updated.

truncate_table required

Enable to DELETE ALL EXISTING DATA from the BigQuery table prior to adding new data.

process_increment required

This Task will process data in increments. Set a value in this field to determine the size of each increment.


Update Form Submissions

Use form submissions in HubSpot to update data in BigQuery.

Variables

Source Parameters
hubspot_con required

API Key or Access Token to connect to HubSpot.

col_names required

Shared Config containing mappings between BigQuery column names and HubSpot contact property names.

hubspot_form required

Unique guid of the HubSpot form used to create the submissions.


Destination Parameters
gcp_con required

Credentials to use to access the BigQuery Cloud Data Warehouse.

project required

Name of the project with the dataset where the data will be updated.

dataset required

Name of the dataset with the table where the data will be updated.

table required

Name of the table where the data will be updated.

truncate_table required

Enable to DELETE ALL EXISTING DATA from the BigQuery table prior to adding new data.

process_increment required

This Task will process data in increments. Set a value in this field to determine the size of each increment.


List Available Object Properties

Displays the available properties, both custom and default, for the specified HubSpot object.

Variables

Source Parameters
hubspot_con required

API Key or Access Token to connect to HubSpot.

hubspot_objects required

Select the type of objects for which available properties should be displayed.


Update Data using Export Request

Submit an asynchronous data export request to HubSpot and load the results to the BigQuery database after the request has completed.

Variables

Source Parameters
hubspot_con required

API Key or Access Token to connect to HubSpot.

data_type required

Select the type of data to download.

bq_config required

Shared Config that contains the load options and column definitions.

filtering_field required

HubSpot property to use for date based filtering.

wait_until required

How long a task execution is allowed to wait an export request to complete before failing.

sleep_time required

How long to wait between each check of the export request status.

last_run required

Datetime stamp indicating the last run time. Formatted as YYYY-MM-DD HH:MM:SS in UTC timezone.


Destination Parameters
gcp_con required

Credentials to use to access the BigQuery Cloud Data Warehouse.

project required

Name of the project with the dataset where the data will be updated.

dataset required

Name of the dataset with the table where the data will be updated.

table required

Name of the table where the data will be updated.

create_table_if_dne required

Enable to create the table if it does not exist.


Update CRM Objects

Use CRM object information in HubSpot to update data in BigQuery.

Variables

Source Parameters
hubspot_con required

API Key or Access Token to connect to HubSpot.

data_type required

Select the type of data to download.

bq_config required

Shared Config that contains the load options and column definitions.

filtering_field required

HubSpot property to use for date based filtering.

wait_until required

How long a task execution is allowed to wait an export request to complete before failing.

sleep_time required

How long to wait between each check of the export request status.

last_run

Datetime stamp indicating the starting point of data to download. Formatted as YYYY-MM-DD HH:MM:SS in UTC timezone. Leave this field blank to download all data.

update_pointer required

Update the Next Run Start Point field to the Task execution start time, if the execution completes successfully.


Destination Parameters
gcp_con required

Credentials to use to access the BigQuery Cloud Data Warehouse.

project required

Name of the project with the dataset where the data will be updated.

dataset required

Name of the dataset with the table where the data will be updated.

table required

Name of the table where the data will be updated.

create_table_if_dne required

Enable to create the table if it does not exist.

process_increment required

This Task will process data in increments. Set a value in this field to determine the size of each increment.