Images
Returns all uploaded images in the account, including metadata such as URLs, file size, and upload timestamps.
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
- 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). |