JDBC Driver for Shopify

Build 23.0.8839

ProductImages

Returns the images associated with the product.

Select

The 本製品 uses the Shopify API to process WHERE clause conditions built with the following column and operator. The 本製品 processes other filters client-side within the 本製品.

  • 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

Insert statements are mapped to the 'productAppendImages' GraphQL mutation.

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

ProductId, AltText, Url

Update

Update statements are mapped to the 'productImageUpdate' GraphQL mutation.

The following columns can be updated:

Id, ProductId, AltText, Url

Delete

Delete statements are mapped to the 'productDeleteImages' GraphQL mutation.

You can delete entries by specifying the Id and 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 23.0.8839