JDBC Driver for Shopify

Build 24.0.9060

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'

SELECT * FROM Redirects WHERE Target = '/pqr.jsp'

SELECT * FROM Redirects WHERE Path = '/abc.php'

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) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060