HubSpot to SQL Server Loader

Obtain data from HubSpot and load it into SQL Server.

Load CRM Objects

Use CRM object information in HubSpot to load data into SQL Server.

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.

download_all_properties

Enable to store all object properties in a JSON column. If enabled, do not select a Column Mappings Shared Config.

col_names

Shared Config containing mappings between SQL Server 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.

pointer

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

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 SQL Server Database.

target_table required

Name of the table where the data will be loaded.

create_table_if_dne required

Enable to create the Target Table if it does not exist.

process_increment required

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

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