Lists
Lists all subscriber lists in the account, including list names, Ids, and subscription settings.
Select
The component uses the Klaviyo API to process WHERE clause conditions with the following columns and operators. Remaining filters are evaluated client-side within the component.
- 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). |