ODBC Driver for Salesforce Marketing Cloud Account Engagement

Build 23.0.8839

TrackerDomains

Query the available tracker domains.

Table Specific Information

Select

The 本製品 will use the Salesforce Marketing Cloud Account Engagement API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the 本製品.

  • Id supports '=', '<', '<=', '>', '>='.
  • IsDeleted supports '='.

For example, the following queries are processed server side:

SELECT * FROM TrackerDomains WHERE Id = 50

GetDeleted

To retrieve deleted records, a GETDELETED statement can be executed.

GETDELETED FROM TrackerDomains 

Columns

Name Type ReadOnly References Description
Id [KEY] Int64 True

Pardot ID for this object.

Domain String True

Hostname to which links using this tracker domain are resolved.

IsPrimary Boolean True

True if the tracker domain is primary tracker domain for the account. Only one tracker domain can be designated as the primary and must be unique across all Pardot accounts.

IsDeleted Boolean True

True if the object is in the recycle bin in Pardot.

DefaultCampaignId Int64 True

The ID of the default campaign for this tracker domain.

HttpsStatus String True

Identify if this tracker domain is using http or https.

SslStatus String True

Status of SSL for this vanity tracker domain.

SslStatusDetails String True

Extra information for the status of SSL for this vanity tracker domain.

SslRequestedById Int64 True

ID of the User who manually requested enabling SSL for this tracker domain.

ValidationStatus String True

The status can be default, validated or not validated

ValidatedAt Datetime True

Time when this tracker domain validation became validated.

VanityUrlStatus String True

Indicates whether this tracker domain can serve vanity urls.

TrackingCode String True

The tracking code for this object encoded as JSON string. A default campaign is required before generating tracking codes as well as enabling first party tracking in account settings.

CreatedAt Datetime True

The timestamp of when this object was created.

UpdatedAt Datetime True

The timestamp of when this object was last updated.

CreatedById Int64 True

ID of the individual who created this object.

UpdatedById Int64 True

ID of the individual who last updated this object.

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