Power BI Connector for Shopify

Build 25.0.9454

Files

Returns the list of files that have been uploaded to Shopify.

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:

Id

Columns

Name Type ReadOnly References Description
Id [KEY] String True

A globally-unique ID.

Description String True

The description of the file.

Status String True

The status of the file.

FileErrors String True

Any errors that have occurred on the file.

CreatedAt Datetime True

The date and time at which the file was created in Shopify.

UpdatedAt Datetime True

The date and time at which the file was last modified.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454