ODBC Driver for Shopify

Build 24.0.9060

ProductImages

Returns the images associated with the product.

Table-Specific Information

Select

The driver uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The driver processes other filters client-side within the driver.

  • ProductId supports the '=,IN' comparison operators.

For example, the following queries are processed server side:

  SELECT * FROM ProductImages
  SELECT * FROM ProductImages WHERE ProductId = 'Val1'

Insert

The following columns can be used to create a new record:

ProductId, AltText, Url

Update

The following columns can be updated:

AltText, Url

Delete

You can delete entries by specifying the following columns:

Id, ProductId

Columns

Name Type ReadOnly References Description
Id [KEY] String True

A unique identifier for the image.

ProductId [KEY] String True

Products.Id

A globally-unique identifier.

AltText String False

A word or phrase to share the nature or contents of an image.

Height Int True

The original height of the image in pixels. Returns 'null' if the image is not hosted by Shopify.

Width Int True

The original width of the image in pixels. Returns 'null' if the image is not hosted by Shopify.

Url String False

The location of the image as a URL.

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