Create, read, update or delete assets. CUD support is no longer accessible for public apps.

Table-Specific Information

Select

The connector processes all filters client-side within the connector. 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', '
', '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.