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 associated with the HubSpot account to use.

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 associated with the HubSpot account to use.

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 associated with the HubSpot account to use.

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 associated with the HubSpot account to use.

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 associated with the HubSpot account to use.

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 associated with the HubSpot account to use.

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.