TrackerDomains
Query the available tracker domains.
テーブル固有の情報
Select
connector はSalesforce Marketing Cloud Account Engagement API を使用して、以下のカラムと演算子で構築されたWHERE 句条件を処理します。その他のフィルタはクライアントサイドでconnector 内部で処理されます。
- 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. |