Breadcrumbs

Hubspot - CSV Header Validator

Overview

Preparation:

Have your Hubspot Access Token ready. This token is essential for accessing the list of available Hubspot properties. Prepare the CSV file you want to validate. Make sure it's accessible and you know its path. Using the Blueprint:

Launch the "Hubspot - CSV Header Validator" blueprint. Input the Hubspot Access Token into the corresponding field. Provide the path to your CSV file. If you don't provide a CSV file, the blueprint will default to logging available Hubspot properties. Initiate the blueprint. Depending on your input, it will either validate the CSV headers or provide a detailed log of available Hubspot properties. Post-Validation:

Review the logs. If you provided a CSV, it would indicate whether all headers are valid Hubspot properties or list any discrepancies. If no CSV was provided, you'd see a detailed log of all available Hubspot contact properties.

Variables

Name

Reference

Type

Required

Default

Options

Description

Access Token

HUBSPOT_ACCESS_TOKEN

Password

✅

-

-

Token for authenticating with Hubspot. This ensures secure access to the Hubspot account for exporting data.

CSV File Path (Optional)

HUBSPOT_CSV_FILE

Alphanumeric

➖

-

-

Path to the CSV file you want to validate. If not provided, the blueprint will log available Hubspot properties.

Hubspot Data Type

HUBSPOT_OBJECT_TYPE

Select

✅

contacts

Contacts: contacts

Companies: companies

Deals: deals

YAML

Below is the YAML template

YAML

source:
  template: Hubspot - CSV Header Validator
  inputs:
    HUBSPOT_ACCESS_TOKEN:
    HUBSPOT_CSV_FILE:
    HUBSPOT_OBJECT_TYPE: contacts
  type: TEMPLATE
guardrails:
  retry_count: 1
  retry_wait: 0h0m0s
  runtime_cutoff: 1h0m0s
  exclude_exit_code_ranges:
    - 102
    - 201
    - 202
    - 206