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