Excel Add-In for Shopify

Build 24.0.9062

ProductMediaImages

Returns the media images associated with the product.

Table-Specific Information

Select

The 本製品 uses the Shopify API to process WHERE clause conditions built with the following columns and operators. 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 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.

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