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

Description

Use data from a MySQL database to create or update objects in HubSpot.

Purchasing Options

MySQL to HubSpot Loader - $99.99 /

Available Actions

Update Contacts using Date Parameters

Execute an SQL Query with Date Parameters against a MySQL database and use the results to create or update contacts in HubSpot.

Variables

Source Parameters
db required

Credentials to access the MySQL Database.

table_name required

Table name, in schema.table format, where the data is stored.

sql_query required

SQL query to find new and updated data in MySQL.

end_point_query

SQL Query to use to determine the end point of the data to process.

hubspot_id required

Column that holds the id associated with the data in HubSpot.

errors_table_name

Optional table name, in schema.table format, to use to store errors. If specified, invalid items will be skipped. Otherwise, invalid items will trigger an execution failure.

process_increment required

This Task will process data in increments. Set a value in this field to determine the size of each increment. Supported units are w (weeks), d (days), h (hours), m (minutes) and s (seconds), for example 1W, 1D or 12H.

pointer required

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

user_params

Optional JSON object with custom parameters for SQL query template substitution.

post_sql_query

Optional SQL query to execute after the load completes (e.g., for cleanup or aggregation).


Destination Parameters
hubspot_credentials required

API Key or Access Token to connect to HubSpot.


Update Contacts using Integer Parameters

Execute an SQL Query with Integer Parameters against a MySQL database and use the results to create or update contacts in HubSpot.

Variables

Source Parameters
db required

Credentials to access the MySQL Database.

table_name required

Table name, in schema.table format, where the data is stored.

sql_query required

SQL query to find new and updated data in MySQL.

end_point_query required

SQL Query to use to determine the end point of the data to process.

hubspot_id required

Column that holds the id associated with the data in HubSpot.

errors_table_name

Optional table name, in schema.table format, to use to store errors. If specified, invalid items will be skipped. Otherwise, invalid items will trigger an execution failure.

process_increment required

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

pointer required

Integer value corresponding to the last previously processed row.

user_params

Optional JSON object with custom parameters for SQL query template substitution.

post_sql_query

Optional SQL query to execute after the load completes (e.g., for cleanup or aggregation).


Destination Parameters
hubspot_credentials required

API Key or Access Token to connect to HubSpot.


Update Deals using Date Parameters

Execute an SQL Query with Date Parameters against a MySQL database and use the results to create or update deals in HubSpot.

Variables

Source Parameters
db required

Credentials to access the MySQL Database.

table_name required

Table name, in schema.table format, where the data is stored.

sql_query required

SQL query to find new and updated data in MySQL.

end_point_query

SQL Query to use to determine the end point of the data to process.

hubspot_id required

Column that holds the id associated with the data in HubSpot.

errors_table_name

Optional table name, in schema.table format, to use to store errors. If specified, invalid items will be skipped. Otherwise, invalid items will trigger an execution failure.

process_increment required

This Task will process data in increments. Set a value in this field to determine the size of each increment. Supported units are w (weeks), d (days), h (hours), m (minutes) and s (seconds), for example 1W, 1D or 12H.

pointer required

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

user_params

Optional JSON object with custom parameters for SQL query template substitution.

post_sql_query

Optional SQL query to execute after the load completes (e.g., for cleanup or aggregation).


Destination Parameters
hubspot_credentials required

API Key or Access Token to connect to HubSpot.


Update Deals using Integer Parameters

Execute an SQL Query with Integer Parameters against a MySQL database and use the results to create or update deals in HubSpot.

Variables

Source Parameters
db required

Credentials to access the MySQL Database.

table_name required

Table name, in schema.table format, where the data is stored.

sql_query required

SQL query to find new and updated data in MySQL.

end_point_query required

SQL Query to use to determine the end point of the data to process.

hubspot_id required

Column that holds the id associated with the data in HubSpot.

errors_table_name

Optional table name, in schema.table format, to use to store errors. If specified, invalid items will be skipped. Otherwise, invalid items will trigger an execution failure.

process_increment required

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

pointer required

Integer value corresponding to the last previously processed row.

user_params

Optional JSON object with custom parameters for SQL query template substitution.

post_sql_query

Optional SQL query to execute after the load completes (e.g., for cleanup or aggregation).


Destination Parameters
hubspot_credentials required

API Key or Access Token to connect to HubSpot.