NMCContacts
Query New Marketing Campaign Contacts in SendGrid.
ビュー固有の情報
新しいMarketing Campaign の連絡先はユーザーが管理する受信者です。NMC プレフィックスは、New Marketing Campaign の略です。
Select
すべてのNMCContacts の取得、またはId、ListId、SegmentId でのフィルタが可能です。
SELECT * FROM NMCCustomFields WHERE Id = 'pe37d765-ba38-46d9-be55-1e45a1ee8c84'
SELECT * FROM NMCCustomFields WHERE Id IN ('pe37d765-ba38-46d9-be55-1e45a1ee8c84', 'fe37d765-ba38-46d9-be55-1e45a1ee8c84')
SELECT * FROM NMCCustomFields WHERE ListId = 't6d51a34-3981-4fa6-bd3f-abdd4de8ff9f'
SELECT * FROM NMCCustomFields WHERE ListId IN ('j6d51a34-3981-4fa6-bd3f-abdd4de8ff9f', 'f6d51b34-3981-4fa6-bd3f-abdd4de8ff9f')
SELECT * FROM NMCCustomFields WHERE SegmentId = '82aeee2d-2870-41e4-b43c-0dcf63481589'
SELECT * FROM NMCCustomFields WHERE SegmentId IN ('82aeee2d-2870-41e4-b43c-0dcf63481589', 'j9d51a34-3981-4fa6-bd3f-abdd4de8ff9f')
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. | |
| ItemUrl | String | 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 | Uuid | This column is dynamic and maps to the corresponding field in the API. |