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. |
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. |