Files

Lists files uploaded to Shopify (images, PDFs, media) with metadata and URLs.

Table-Specific Information

Select

The driver uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The driver processes other filters client-side within the driver.

Id supports the '=' comparison operator.
Status supports the '=' comparison operator.
CreatedAt supports the '=, <, >, >=, <=' comparison operators.
UpdatedAt supports the '=, <, >, >=, <=' comparison operators.

For example, the following queries are processed server-side:

  SELECT * FROM Files WHERE Id = 'Val1'
  SELECT * FROM Files WHERE Status = 'Val1'
  SELECT * FROM Files WHERE CreatedAt = '2023-01-01 11:10:00'
  SELECT * FROM Files WHERE UpdatedAt = '2023-01-01 11:10:00'

Delete

You can delete entries by specifying the following column:

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		The globally unique identifier of the file.
Description	String	True		The descriptive text or alternative information associated with the file.
Status	String	True		The current processing or availability status of the file.
FileErrors	String	True		Details about any errors that occurred during file upload, processing, or use.
CreatedAt	Datetime	True		The date and time when the file was first created in Shopify.
UpdatedAt	Datetime	True		The date and time when the file was most recently updated in Shopify.

JDBC Driver for Shopify

Files

Table-Specific Information

Select

Delete

Columns