Lists
Create, update, delete, and query the available Lists in SendGrid.
Table-Specific Information
Select
The Lists table can only filtered by its Id.
SELECT * FROM Lists WHERE Id = '123'
Insert
Only the Name for the List is required to insert into this table.
INSERT INTO Lists (Name) VALUES ('TestList')
Update
You can only update from Lists by specifying an Id.
UPDATE Lists SET Name = 'New Name' WHERE Id = '123'
Delete
You can only delete from Lists by specifying an Id.
DELETE FROM Lists WHERE Id = '123'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Integer | True |
The Id of the list. | |
| Name | String | False |
The name of the list. | |
| RecipientCount | Integer | True |
The recipient count of the list. |
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. |