NMCContacts
Query New Marketing Campaign Contacts in SendGrid.
View-Specific Information
New Marketing Campaign contacts are recepients that are managed by the user. NMC prefix stands for New Marketing Campaign.
Select
You can retrieve all the NMCContacts or filter them by Id, ListId or 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
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| 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. |