JDBC Driver for SendGrid

Build 20.0.7587

Bounces

Query and Delete the available Bounces in SendGrid.

Table-Specific Information

Select

You need to specify a time span to select from this table. If you do not specify one, a default span of the past 120 days is used. The CreatedAt column supports the >, <, =, <=, and >= operators.

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

Delete

You can only delete from Bounces by specifying an Email.

Delete FROM Bounces WHERE Email='test@test.com'

Columns

Name Type ReadOnly Description
CreatedAt Datetime True

The time the bounce was created.

Reason String False

The reason for the bounce.

Email [KEY] String False

The email that bounced.

Status String False

The enhanced SMTP bounce response.

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