Cmdlets for HubSpot

Build 24.0.9032

LeadPropertiesFile Parameter (Connect-HubSpot Cmdlet)

A file or a CSV string for the columns to select from HubSpot for the Leads table.

Syntax

Connect-HubSpot -LeadPropertiesFile string

Data Type

cstr

Default Value

""

Remarks

In HubSpot, you can potentially have so many custom fields that attempting to select all of them at a time will cause HubSpot to return an error. In a situation where you do not have direct control over the SQL Statement but still need to get custom field data back or override the query projection, you set the LeadPropertiesFile to either the full location of a file containing a CSV string that lists which custom fields to select or pass that CSV string directly in the property. For example, LeadPropertiesFile='C:\users\public\documents\customfields.txt' or LeadPropertiesFile='hs_object_id,hs_lead_name,hs_lead_type'.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9032