CollectionListings
Query and delete information regarding different collects.
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 CollectionListings
SELECT * FROM CollectionListings 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.
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. |