Images
Returns all uploaded images in the account, including metadata such as URLs, file size, and upload timestamps.
Select
The connector uses the Klaviyo API to process WHERE clause conditions with the following columns and operators. Remaining filters are evaluated client-side within the connector.
- Id supports the operator: =, IN
- IsHidden supports the operator: =, IN
- Name supports the operator: =, IN, CONTAINS, LIKE
For example, the following queries are processed server-side:
SELECT * FROM Images
WHERE Id = 'image-id'
SELECT * FROM Images
WHERE IsHidden = false
SELECT * FROM Images
WHERE Name LIKE 'cdata%'
Insert
This table does not support INSERT statements. To add a new image, use the UploadImage stored procedure.
Update
You can update images. The fields that can be updated are Name and IsHidden.
UPDATE Images
SET Name = 'My Image New Name'
WHERE Id = 'image-id'
Columns
| Name | Type | ReadOnly | References | Description | |
| Id [KEY] | String | True |
The unique identifier for the image stored in Klaviyo. | ||
| Format | String | False |
Specifies the image file format. Supported formats include jpeg, png, and gif. | ||
| IsHidden | Bool | False |
Indicates whether the image is hidden from the asset library. The default value is false. | ||
| ImageUrl | String | False |
Specifies an existing image URL used to import the image into the account. | ||
| Name | String | False |
The display name assigned to the image. If not provided, the name defaults to the original filename. If the name matches an existing image, a suffix is automatically added. | ||
| Size | Int | False |
The file size of the image in bytes. The maximum supported file size is 5 MB. | ||
| UpdatedAt | Datetime | True |
The date and time when the image was last updated, in ISO 8601 format (YYYY-MM-DDTHH:MM:SS.mmmmmm). |