Lists
Lists all subscriber lists in the account, including list names, Ids, and subscription settings.
Select
The add-in uses the Klaviyo API to process WHERE clause conditions with the following columns and operators. Remaining filters are evaluated client-side within the add-in.
- Id supports the operator: =, IN
- Name supports the operator: =, IN
For example, the following queries are processed server-side:
SELECT * FROM Lists
WHERE Id = 'list-id'
SELECT * FROM Lists
WHERE Name = 'list-name'
Insert
You can create new lists.
INSERT INTO Lists (Name)
VALUES ('My List')
Update
You can update lists. The field that can be updated is Name.
UPDATE Lists
SET Name = 'My New List Name'
WHERE Id = 'list-id'
Delete
You can delete a list by specifying its Id.
DELETE FROM Lists
WHERE Id = 'list-id'
Columns
| Name | Type | ReadOnly | References | Description | |
| Id [KEY] | String | True |
The unique identifier for the list, automatically generated by Klaviyo. | ||
| Created | Datetime | True |
The date and time when the list was created, in ISO 8601 format (YYYY-MM-DDTHH:MM:SS.mmmmmm). | ||
| Name | String | False |
The display name assigned to the list, used to identify it within the account. | ||
| OptInProcess | String | True |
Specifies the opt-in method used for the list. Supported values include single_opt_in and double_opt_in. | ||
| Updated | Datetime | True |
The date and time when the list was last updated, in ISO 8601 format (YYYY-MM-DDTHH:MM:SS.mmmmmm). |