Files

Contains metadata for media files uploaded to Shopify, including file name, MIME type, and storage URL.

Table-Specific Information

Select

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

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		A globally unique identifier assigned to the file record within Shopify.
Description	String	True		A descriptive text explaining the file's content or intended purpose.
Status	String	True		Indicates the current state of the file, such as uploaded, processing, failed, or completed.
FileErrors	String	True		Details any errors encountered during file upload, processing, or validation.
CreatedAt	Datetime	True		The timestamp representing when the file was first uploaded or created in Shopify.
UpdatedAt	Datetime	True		The timestamp representing when the file record or its associated data was most recently updated.

Power BI Connector for Shopify

Files

Table-Specific Information

Select

Delete

Columns