Assets
Create, read, update or delete assets
Table-Specific Information
Select
The driver processes all filters client-side within the driver. The following queries are the only ones processed server side:
SELECT * FROM Assets
SELECT * FROM Assets WHERE Key='assets/abc.gif'
You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.
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 | 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 | Integer | 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. |