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