Alerts
Create, update, delete, and query Alerts in SendGrid.
Table-Specific Information
Select
This table only supports filtering by Id. The following are the only possible SELECT queries:
SELECT * FROM Alerts WHERE Id = '148825'
Insert
The following columns are required in an insert for Stats Notification: Type, EmailTo, Frequency.
INSERT INTO Alerts (Type, EmailTo, Frequency) VALUES ('stats_notification', '[email protected]', 'daily')
The following columns are required in an insert for Usage Limit: Type, EmailTo, Percentage.
INSERT INTO Alerts (Type, EmailTo, Percentage) VALUES ('usage_limit', '[email protected]', 20)
Update
You can only update EmailTo by specifying an Id.
UPDATE Alerts SET EmailTo = '[email protected]' WHERE Id = 1310789
Delete
You can only delete from Alerts by specifying an Id.
DELETE FROM Alerts WHERE Id = 1310789
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Integer | True |
The ID of the alert. | |
| CreatedAt | Datetime | True |
Date when the alert was created. | |
| UpdatedAt | Datetime | True |
Date when the alert was updated. | |
| EmailTo | String | False |
The email address that the alert will be sent to. | |
| Percentage | Integer | False |
The email address that the alert will be sent to. | |
| Type | String | False |
The type of alert. Allowed values (usage_limit, stats_notification). | |
| Frequency | String | False |
If the alert is of type stats_notification, this indicates how frequently the stats notifications will be sent.(daily, weekly, monthly). |
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. |