JDBC Driver for HubSpot

Build 22.0.8462

EcommerceSettings

Retrieve the current ecommerce settings for your portal or app.

Table Specific Information

The Ecommerce Settings table is where you set up the property mappings for your use of the Ecommerce Bridge API.

Select

When selecting settings, they can only be filtered by the AppId and only one AppId at a time. Otherwise they can be selected without a filter, which will cause all settings in your HubSpot account to be listed. For example:

SELECT * FROM EcommerceSettings

SELECT * FROM EcommerceSettings WHERE AppId = '123456'

Columns

Name Type ReadOnly References Description
PropertyName String True

Name of the property.

DataType String True

Data type of the property.

The allowed values are STRING, NUMBER, DATETIME, AVATAR_IMAGE.

TargetHubspotProperty String True

Name of the target property on Hubspot that this property represents.

Enabled Boolean True

Boolean value that shows if this representation of this property is enabled or not.

ImportOnInstall Boolean True

Boolean value that shows if this property should be imported during installation procedure.

SettingType String True

The type of the property. It can be: Product, Deal, LineItem or Contact

The allowed values are PRODUCT, DEAL, CONTACT, LINE_ITEM.

AppId String True

The app ID in which the property is or will be imported.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462