CancelScheduledSends
Update, delete, and query Cancel Scheduled Sends in SendGrid.
Table-Specific Information
Select
This table only supports filtering by BatchId. The following are the only possible SELECT queries:
SELECT * FROM CancelScheduledSends SELECT * FROM CancelScheduledSends WHERE BatchId = 148825
Update
You can update CancelScheduledSends by specifying an BatchId.
Allowed Values : cancel, pause
UPDATE CancelScheduledSends SET Status = 'cancel' WHERE BatchId = 1310789
Delete
You can only delete from CancelScheduledSends by specifying an BatchId.
DELETE FROM CancelScheduledSends WHERE BatchId = 1310789
Columns
| Name | Type | ReadOnly | References | Description |
| BatchId [KEY] | String | False |
The Id of the batch. | |
| Status | String | False |
The status of the scheduled send.Allowed Values: cancel, pause |
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. |