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




Description

Use information in HubSpot to update data in BigQuery.


Purchasing Options



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.


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.


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.


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.


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.


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.


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.


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.