ODBC Driver for Shopify

Build 22.0.8462

Redirects

Create, read, update or delete redirects.

Table-Specific Information

Select

The driver processes all filters client-side within the driver. The following queries are the only ones processed server side:

SELECT * FROM Redirects

SELECT * FROM Redirects WHERE Id='123'
You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

Insert

You must specify path and target to create a Redirect.

INSERT INTO Redirects(path,target) VALUES ('/abc.php','/pqr.jsp')

Update

You must specify the id to update a Redirect. For example:

UPDATE Redirects SET Path='/abc.php' WHERE Id = '77171130'

Delete

You must specify the Id of the Redirect to delete it.

DELETE FROM Redirects WHERE Id = '555695'

Columns

Name Type ReadOnly References Description
Id [KEY] Long True

The ID for the redirect.

Path String False

The old path to be redirected.

Target String False

The target location where the user will be redirected.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462