ProductMediaImages

Returns the media images associated with the product.

Table-Specific Information

Select

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

ProductId supports the '=,IN' comparison operators.

For example, the following queries are processed server side:

  SELECT * FROM ProductMediaImages
  SELECT * FROM ProductMediaImages 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 media image.
ProductId [KEY]	String	True	Products.Id	A globally-unique identifier for the product.
AltText	String	False		A word or phrase to share the nature or contents of a media 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.