Assets

Create, read, update or delete assets

Table-Specific Information

The adapter processes all filters client-side within the adapter. The following queries are the only ones processed server side:

SELECT * FROM Assets

SELECT * FROM Assets WHERE Key='assets/abc.gif'

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'

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'

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.