CData Python Connector for Shopify

Build 23.0.8839

Assets

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839