ODBC Driver for Salesforce Marketing Cloud Account Engagement

Build 24.0.9062

TrackerDomains

Query the available tracker domains.

テーブル固有の情報

Select

本製品 はSalesforce Marketing Cloud Account Engagement API を使用して、以下のカラムと演算子で構築されたWHERE 句条件を処理します。その他のフィルタはクライアントサイドで本製品 内部で処理されます。

  • Id は '='、'<'、'<='、'>'、'>=' をサポートしています。
  • IsDeleted は'=' をサポートしています。

例えば、次のクエリはサーバーサイドで処理されます。

SELECT * FROM TrackerDomains WHERE Id = 50

GetDeleted

削除されたレコードを取得するには、GETDELETED 文を実行します。

GETDELETED FROM TrackerDomains 

Columns

Name Type References Description
Id [KEY] Int64 Pardot ID for this object.
Domain String Hostname to which links using this tracker domain are resolved.
IsPrimary Boolean 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 if the object is in the recycle bin in Pardot.
DefaultCampaignId Int64 The ID of the default campaign for this tracker domain.
HttpsStatus String Identify if this tracker domain is using http or https.
SslStatus String Status of SSL for this vanity tracker domain.
SslStatusDetails String Extra information for the status of SSL for this vanity tracker domain.
SslRequestedById Int64 ID of the User who manually requested enabling SSL for this tracker domain.
ValidationStatus String The status can be default, validated or not validated
ValidatedAt Datetime Time when this tracker domain validation became validated.
VanityUrlStatus String Indicates whether this tracker domain can serve vanity urls.
TrackingCode String 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 The timestamp of when this object was created.
UpdatedAt Datetime The timestamp of when this object was last updated.
CreatedById Int64 ID of the individual who created this object.
UpdatedById Int64 ID of the individual who last updated this object.

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