ProspectAccounts
Query the available prospect accounts.
テーブル固有の情報
Select
本製品 はSalesforce Marketing Cloud Account Engagement API を使用して、以下のカラムと演算子で構築されたWHERE 句条件を処理します。その他のフィルタはクライアントサイドで本製品 内部で処理されます。
- Id は '='、'<'、'<='、'>'、'>=' をサポートしています。
例えば、次のクエリはサーバーサイドで処理されます。
SELECT * FROM ProspectAccounts WHERE Id > 31
Get Deleted
削除されたプロスペクトのアカウントを取得するには、GETDELETED 文を実行します。
GETDELETED FROM ProspectAccounts
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Int64 | True |
ID of the object. | |
| Name | String | True |
Name of the object. | |
| SalesforceId | String | True |
ID of the Salesforce object representing this object. | |
| IsDeleted | Boolean | True |
True if the object is in the recycle bin in Pardot. | |
| AnnualRevenue | String | True |
Annual Revenue of the object. | |
| BillingAddressOne | String | True |
Billing Address of the object. | |
| BillingAddressTwo | String | True |
Second Billing Address of the object. | |
| BillingCity | String | True |
City of the object. | |
| BillingCountry | String | True |
County of the object. | |
| BillingState | String | True |
State of the object. | |
| BillingZip | String | True |
Zip of the object. | |
| Description | String | True |
Description of the object. | |
| Employees | String | True |
Employees of the object. | |
| Fax | String | True |
Fax of the object. | |
| Industry | String | True |
Industry of the object. | |
| Number | String | True |
Number of the object. | |
| Ownership | String | True |
Ownership of the object. | |
| Phone | String | True |
Phone Number of the object. | |
| Rating | String | True |
Rating of the object. | |
| ShippingAddressOne | String | True |
Shipping Address of the object. | |
| ShippingAddressTwo | String | True |
Second Shipping Address of the object. | |
| ShippingCity | String | True |
Shipping Address city of the object. | |
| ShippingCountry | String | True |
Shipping Address country of the object. | |
| ShippingState | String | True |
Shipping Address state of the object. | |
| ShippingZip | String | True |
Shipping Address zip of the object. | |
| Sic | String | True |
SIC of the object. | |
| Site | String | True |
Site of the object. | |
| TickerSymbol | String | True |
Ticker Symbol of the object. | |
| Type | String | True |
Type of the object. | |
| Website | String | True |
Website of the object. | |
| CreatedAt | Datetime | True |
Creation time of the object. | |
| UpdatedAt | Datetime | True |
Last update time of the object. | |
| AssignedToId | Int64 | True |
ID of the user who the object record is assigned to. | |
| CreatedById | Int64 | True |
ID of the individual who created this object. | |
| UpdatedById | Int64 | True |
ID of the individual who last updated this object. |