Redirects
Lists all redirect URLs.
Table Specific Information
Select
The server uses the BigCommerce API to process WHERE clause conditions built with the Id column, which supports the = comparison.
The rest of the filter is executed client-side within the server.
For example, the following query is processed server-side:
SELECT * FROM Redirects WHERE Id = 1
Columns
| Name | Type | Description |
| Id [KEY] | Integer | Numeric Id of the redirect. |
| SiteId | Integer | Site Id of the redirect. |
| FromPath | String | The path from which to redirect. |
| ToType | String | The type of redirect. Possible values are: product, brand, category, page, post, or url. |
| ToEntityId | Integer | EntityId of the redirect. |
| ToURL | String | URL of the redirect. |
| URL | String | Full destination URL for the redirect. Must be explicitly included via URL parameter. |