CData BizTalk Adapter for HubSpot 2019 - Online Help
Questions / Feedback?

CompanyProperties

CData BizTalk Adapter for HubSpot 2019 - Build 19.0.7424

Company properties are the standard and custom pieces of field data that appear in HubSpot.

Table Specific Information

Company properties are a number of custom properties that are available to store data about the companies in your HubSpot Hub. Some of these properties are added by HubSpot and cannot be deleted. They will be automatically added to the Companies on a new connection.

Select

Company properties can only be filtered by the unique company property name. For example:

SELECT * FROM CompanyProperties WHERE Name = 'property_name'

Columns

Name Type ReadOnly References Description
Name [KEY] String False

The name of the contact property. The name must contain only lowercase alphabetical characters and numbers and must start with a lowercase alphabetical character.

Label String False

The human readable label for the company property that will display in the HubSpot UI.

FieldType String False

The type of field that will display on the screen for the company property.

The allowed values are textarea, select, text, date, file, number, radio, booleancheckbox, checkbox.

Type String False

The stored machine type for the company property.

The allowed values are string, number, bool, datetime, enumeration.

GroupName String False

ContactPropertyGroups.Name

The group the company property is a part of.

Description String False

A description of what the property is for.

DisplayMode String False

How the property will be displayed.

DisplayOrder Integer False

The order in which the property should be displayed in relation to other properties in the same group.

ExternalOptions Boolean False

Boolean indicating if there are external options associate with the company property.

IsFormField Boolean False

Boolean indicating if the property is a field that is part of a form.

IsCalculated Boolean False

Boolean indicating if the property is calculated.

IsHidden Boolean False

Boolean indicating if the property is hidden.

IsHubspotDefined Boolean False

Boolean indicating if the property is defined by HubSpot.

MutableDefinitionNotDeletable Boolean False

Boolean indicating if the property can be modified but not deleted.

ReadOnlyDefinition Boolean False

Boolean indicating if the definition for the property is read only.

ReadOnlyValue Boolean False

Boolean indicating if the value of the property is read only.

OptionsAggregate String False

An aggregate of additional options for the property. Will have a value if the FieldType is radio, checkbox, or booleancheckbox.

ExtraUrlParameters String True

An input only property for specifying additional parameters when selecting data from HubSpot. Specify the parameters as name=value pairs in a comma separated list. For instance, 'param1=value1,param2=value2,param3=value3'.

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7424.0