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 = '[email protected]'
Columns
Name | Type | ReadOnly | References | 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. |