TDV Adapter for Shopify

Build 22.0.8462

CollectionListings

Query and delete information regarding different collects.

Table-Specific Information

Select

The adapter processes all filters client-side within the adapter. The following queries are the only ones processed server side:

SELECT * FROM CollectionListings

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

CustomCollections.Id

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462