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

Description

Use information in HubSpot to update data in MySQL.

Purchasing Options

HubSpot to MySQL Loader - $99.99 / month

Available Actions

Update Contacts

Use contact information in HubSpot to update data in MySQL.

Variables

Source Parameters
hubspot_connection required

API Key or Access Token to connect to HubSpot.

col_names required

Shared Config containing mappings between MySQL column names and HubSpot property names.

last_run required

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


Destination Parameters
target_db required

Credentials to use to access the MySQL Database.

table_name required

Name of the table where the data will be updated.

process_increment

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


Update All Contacts

Use contact information in HubSpot to update data in MySQL.

Variables

Source Parameters
hubspot_connection required

API Key or Access Token to connect to HubSpot.

col_names required

Shared Config containing mappings between MySQL column names and HubSpot property names.


Destination Parameters
target_db required

Credentials to use to access the MySQL Database.

table_name required

Name of the table where the data will be updated.

process_increment

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


Update All Owners

Use owner information in HubSpot to update data in MySQL.

Variables

Source Parameters
hubspot_connection required

API Key or Access Token to connect to HubSpot.

col_names required

Shared Config containing mappings between MySQL column names and HubSpot property names.


Destination Parameters
target_db required

Credentials to use to access the MySQL Database.

table_name required

Name of the table where the data will be updated.

process_increment

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


Update Data using Export Request

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

Variables

Source Parameters
hubspot_connection required

API Key or Access Token to connect to HubSpot.

data_type required

Select the type of data to download.

col_names required

Shared Config containing mappings between MySQL column names and HubSpot property names.

filtering_field required

HubSpot property to use for date based filtering.

default_datetime_format

Format for datetime values in HubSpot.

wait_until

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

sleep_time

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

last_run required

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


Destination Parameters
target_db required

Credentials to use to access the MySQL Database.

table_name 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 MySQL.

Variables

Source Parameters
hubspot_connection required

API Key or Access Token to connect to HubSpot.

data_type required

Select the type of data to download.

col_names required

Shared Config containing mappings between MySQL column names and HubSpot property names.

filtering_field required

HubSpot property to use for date based filtering.

default_datetime_format

Format for datetime values in HubSpot.

wait_until

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

sleep_time

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

Credentials to use to access the MySQL Database.

table_name 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

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