Blocks
Query and Delete the available Blocks 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 Blocks WHERE CreatedAt > '2016-01-01' AND CreatedAt < '2016-01-30'
Delete
You can only delete from Blocks by specifying an Email.
DELETE FROM Blocks WHERE Email = '[email protected]'
Columns
| Name | Type | ReadOnly | References | Description |
| CreatedAt | Datetime | True |
The time the block was created. | |
| Reason | String | False |
The reason for the block. | |
| Email [KEY] | String | False |
The email that blocked. | |
| Status | String | False |
The enhanced SMTP block response. |