Spam
Query and delete Spam reports in SendGrid.
Table-Specific Information
Select
This table only supports filtering by Email. The following are the only possible SELECT queries:
SELECT * FROM Spam SELECT * FROM Spam WHERE Email = '[email protected]'
Delete
Delete from Spam
You can delete from Spam by specifying an Email.
DELETE FROM Spam WHERE Email = '[email protected]'
Columns
| Name | Type | ReadOnly | References | Description |
| CreatedAt | Datetime | True |
The time when the spam report was made. | |
| Email [KEY] | String | False |
The email address of the recipient who marked your message as spam. | |
| Ip | String | False |
The IP address that the message was sent on. |
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 |
| AccountId | String |
The ID of the account. |
| SubuserUsername | String |
The username of the subuser. |