Power BI Connector for Shopify

Build 24.0.9060

UrlRedirects

Returns a list of redirects for a shop.

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 '=,IN' comparison operators.
  • Path supports the '=,!=' comparison operators.
  • Target supports the '=,!=' comparison operators.

For example, the following queries are processed server side:

  SELECT * FROM UrlRedirects
  SELECT * FROM UrlRedirects WHERE Id = 'Val1'
  SELECT * FROM UrlRedirects WHERE Path = 'Val1'
  SELECT * FROM UrlRedirects WHERE Target = 'Val1'

Insert

The following columns can be used to create a new record:

Path, Target

Update

The following columns can be updated:

Path, Target

Delete

You can delete entries by specifying the following column:

Id

Columns

Name Type ReadOnly References Description
Id [KEY] String True

The ID of the URL redirect.

Path String False

The old path to be redirected from. When the user visits this path, they will be redirected to the target location.

Target String False

The target location where the user will be redirected to.

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