CData Python Connector for Shopify

Build 23.0.8839

Collects

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 ReadOnly References Description
Id [KEY] Long True

A unique numeric identifier for the collect.

CollectionId Long False

CustomCollections.Id

The Id of the collection this collection is linked with.

ProductId Long False

Products.Id

The Id of the product this collection is linked with.

Position Int True

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 True

This is the same value as position but padded with leading zeroes to make it alphanumeric-sortable.

CreatedAt Datetime True

The date and time when the collect was created.

UpdatedAt Datetime True

The date and time when the collect was last modified.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839