NMCContacts
Query New Marketing Campaign Contacts in SendGrid.
ビュー固有の情報
新しいMarketing Campaign の連絡先はユーザーが管理する受信者です。NMC プレフィックスは、New Marketing Campaign の略です。
Select
すべてのNMCContacts の取得、またはId、ListId、SegmentId でのフィルタが可能です。
SELECT * FROM NMCCustomFields WHERE Id = '1'
SELECT * FROM NMCCustomFields WHERE Id IN ('1', '2', '3')
SELECT * FROM NMCCustomFields WHERE ListId = '1'
SELECT * FROM NMCCustomFields WHERE ListId IN ('1', '2', '3')
SELECT * FROM NMCCustomFields WHERE SegmentId = '1'
SELECT * FROM NMCCustomFields WHERE SegmentId IN ('1', '2', '3')
Columns
| Name | Type | References | Description |
| Id [KEY] | String | This column is dynamic and maps to the corresponding field in the API. | |
| AddressLine1 | String | This column is dynamic and maps to the corresponding field in the API. | |
| AddressLine2 | String | This column is dynamic and maps to the corresponding field in the API. | |
| City | String | This column is dynamic and maps to the corresponding field in the API. | |
| Country | String | This column is dynamic and maps to the corresponding field in the API. | |
| PostalCode | String | This column is dynamic and maps to the corresponding field in the API. | |
| StateProvinceRegion | String | This column is dynamic and maps to the corresponding field in the API. | |
| Line | String | This column is dynamic and maps to the corresponding field in the API. | |
| String | This column is dynamic and maps to the corresponding field in the API. | ||
| PhoneNumber | String | This column is dynamic and maps to the corresponding field in the API. | |
| UniqueName | String | This column is dynamic and maps to the corresponding field in the API. | |
| String | This column is dynamic and maps to the corresponding field in the API. | ||
| String | This column is dynamic and maps to the corresponding field in the API. | ||
| FirstName | String | This column is dynamic and maps to the corresponding field in the API. | |
| LastName | String | This column is dynamic and maps to the corresponding field in the API. | |
| CreatedAt | Datetime | This column is dynamic and maps to the corresponding field in the API. | |
| UpdatedAt | Datetime | This column is dynamic and maps to the corresponding field in the API. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| SegmentId | String | This column is dynamic and maps to the corresponding field in the API. | |
| ListId | String | This column is dynamic and maps to the corresponding field in the API. |