Redirects
Returns storefront URL redirects, including source path, destination type, and destination URL details.
Table-Specific Information
Select
The connector uses the BigCommerce API to process WHERE clause conditions built with the following columns and operators:
- Id supports the =, IN, >, <, >=, and <= operators.
- SiteId supports the = operator.
- ToType supports the = operator.
The rest of the filter is executed client-side within the connector.
For example, the following query is processed server-side:
SELECT * FROM Redirects WHERE Id = 1
Insert
To insert a redirect, specify at least the following columns: SiteId and FromPath.
Note: If a redirect with the specified FromPath already exists for the given SiteId, the remaining fields will be updated instead of creating a new record.
INSERT INTO Redirects (FromPath, SiteId, ToType, ToURL) VALUES ('/demo-page-new-bigcommerce', 1042, 'url', '/demo-page-url-test')
Delete
The following is an example of how to delete from the Redirects table:
DELETE FROM Redirects WHERE Id = 158
DELETE FROM Redirects WHERE Id IN (89, 88)
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | Integer | True |
The unique identifier of the redirect. |
| SiteId | Integer | False |
The Id of the site associated with this redirect. |
| FromPath | String | False |
The path from which to redirect. |
| ToType | String | False |
The type of redirect. Possible values are: product, brand, category, page, post, or url. |
| ToEntityId | Integer | False |
The entity Id of the redirect destination. |
| ToURL | String | False |
The URL of the redirect destination. |
| URL | String | True |
The full destination URL for the redirect. Must be explicitly included via URL parameter. |