ODBC Driver for Shopify

Build 25.0.9539

UrlRedirects

Defines URL redirects for the shop, mapping legacy or custom URLs to new destinations to maintain navigation and SEO integrity.

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 '=, 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 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

A globally unique identifier for the URL redirect.

Path String False

The original path on the store that will be redirected. When a user visits this path, Shopify automatically redirects them to the target location.

Target String False

The destination URL or path where the user will be redirected. This can be an internal page, collection, product, or an external URL.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 25.0.9539