JDBC Driver for SendGrid

Build 22.0.8462

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
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.
Facebook 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.
WhatsApp String This column is dynamic and maps to the corresponding field in the API.
Email 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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462