UnsubscribeGroups
Create, update, delete, and query Unsubscribe Groups in SendGrid.
Table-Specific Information
Select
UnsubscribeGroups can only be filtered by Id.
SELECT * FROM UnsubscribeGroups WHERE Id = '1'
Insert
Provide a Name and a Description to insert into UnsubscribeGroups:
INSERT INTO UnsubscribeGroups(Name, Description, IsDefault) VALUES ('Unsubscribe1', 'General Unsubscribe', true)
Update
You can only update UnsubscribeGroups by specifying an Id.
Update UnsubscribeGroups SET Name = 'New Name', Description = 'New Description' WHERE Id = '1'
Delete
You can only delete from UnsubscribeGroups by specifying an Id.
DELETE FROM UnsubscribeGroups WHERE Id = '1'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | Integer | True |
Id of the unsubscribe group. | |
Name | String | False |
The name of the unsubscribe group. | |
Description | String | False |
The description of the unsubscribe group. | |
LastEmailSentAt | Datetime | True |
The last time an email was sent to the unsubscribe group. | |
IsDefault | Boolean | False |
If the unsubscribe group is the default group or not. | |
Unsubscribes | Integer | True |
The number of unsubscribes from this group. |