CollectionListings
Query and delete information regarding different collects.
Table-Specific Information
Select
The connector processes all filters client-side within the connector. The following queries are the only ones processed server-side:SELECT * FROM CollectionListings WHERE Id = '123'
Delete
You must specify the Id of the collection listing to delete it.
DELETE FROM CollectionListings WHERE id = '123'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Long | False |
The Id of the collection this listing belongs to. | |
| Title | String | True |
The titke of the collection listing. | |
| BodyHtml | String | True |
The HTML body/description for this listing. | |
| DefaultProductImage | String | True |
The default product image in this listing. | |
| ImageCreatedAt | String | True |
The date and time the image for this listing was created at. | |
| ImageSource | String | True |
The source/link of the image for this listing. | |
| Handle | String | True |
The handle of this listing. | |
| UpdatedAt | Datetime | True |
The date and time when the collection listing was last modified. | |
| PublishedAt | Datetime | True |
The date and time when the collection listing was created. |