Query, insert, or 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 Collects WHERE Id = '123'

Insert

You must specify the ProductId and CollectionId to create a collect.

INSERT INTO Collects (ProductId, CollectionId) VALUES ('512433520663', '22892937239')

Delete

You must specify the Id of the collect to delete it.

DELETE FROM Collects WHERE id = '123'

Columns

Name	Type	References	Description
Id [KEY]	Long		A unique numeric identifier for the collect.
CollectionId	Long	CustomCollections.Id	The Id of the collection this collection is linked with.
ProductId	Long		The Id of the product this collection is linked with.
Position	Int		The position of this product in a manually sorted custom collection. The first position is 1. This value is applied only when the custom collection is sorted manually.
SortValue	String		This is the same value as position but padded with leading zeroes to make it alphanumeric-sortable.
CreatedAt	Datetime		The date and time when the collect was created.
UpdatedAt	Datetime		The date and time when the collect was last modified.