JDBC Driver for SendGrid

Build 20.0.7587

GlobalUnsubscribes

Query Global Unsubscribes in SendGrid.

Table-Specific Information

Select

You need to specify a time span to select from this table. However this filter is optional. The CreatedAt column supports the >, <, =, <=, and >= operators.

SELECT * FROM GlobalUnsubscribes WHERE CreatedAt > '2016-01-01' AND CreatedAt < '2016-01-30'

INSERT

Performing an Insert operation in this table you need to specify an email which will be added to the GlobalUnsubscribes list. For example:

INSERT INTO GlobalUnsubscribes (Email) VALUES ('test@test.com')

DELETE

Performing a Delete operation in this table you need to specify an email which will be removed from the GlobalUnsubscribes list. For example:

DELETE FROM GlobalUnsubscribes WHERE Email = 'test@test.com'

Columns

Name Type ReadOnly Description
Email [KEY] String False

Email of the unsubscriber.

CreatedAt Datetime True

The time the unsubscriber was created.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587