Assets
Create, read, update or delete assets. CUD support is no longer accessible for public apps.
Table-Specific Information
Select
The component processes all filters client-side within the component. The following queries are the only ones processed server-side:SELECT * FROM Assets WHERE Key = 'assets/abc.gif'
Insert
You must specify the Theme Id and Key to insert an Asset. For example:
INSERT INTO Assets(Key, Value, ThemeId) VALUES('assets/abc.gif', '
![](img/image1.png)
', '282977')
Update
You must specify the Theme Id and Key to update an Asset. For example:
UPDATE Assets SET value = 'pqrs' WHERE Key = 'assets/abc.gif' AND ThemeId = '282977'
Delete
You must specify the Id and the Theme Id of the Asset to delete it.
DELETE FROM Assets WHERE Key = 'assets/abc.gif' AND ThemeId = '282977'
Columns
Name | Type | ReadOnly | References | Description |
Key [KEY] | String | False |
The path to the asset within a theme. | |
ThemeId [KEY] | Long | True |
Themes.Id |
The ID for the theme that an asset belongs to. |
Attachment | String | False |
A base64-encoded image. | |
Checksum | String | True |
The MD5 representation of the content, consisting of a string of 32 hexadecimal digits. May be null if an asset has not been updated recently. | |
ContentType | String | True |
The MIME representation of the content, consisting of the type and subtype of the asset. | |
CreatedAt | Datetime | True |
The date and time (ISO 8601 format) when the asset was created. | |
PublicUrl | String | True |
The public-facing URL of the asset. | |
Size | Int | True |
The asset size in bytes. | |
UpdatedAt | Datetime | True |
The date and time (ISO 8601 format) when an asset was last updated. | |
Value | String | False |
The text content of the asset, such as the HTML and Liquid markup of a template file. |