ProductMediaImages
Lists image media attached to products with alt text and ordering.
Table-Specific Information
Select
The driver uses the Shopify API to process WHERE clause conditions built with the following column and operators. The driver processes other filters client-side within the driver.
- ProductId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM ProductMediaImages WHERE ProductId = 'Val1'
Insert
The following columns can be used to create a new record:
ProductId, AltText, MediaContentType, 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 globally unique Id for the media image. | |
| ProductId [KEY] | String | True |
Products.Id |
A globally unique Id for the product associated with the media image. |
| AltText | String | False |
Alternative text that describes the nature or contents of the media image. | |
| MediaContentType | String | True |
The type of media content (for example, image or video). | |
| Height | Int | True |
The original height of the image in pixels. Contains null if the image isn't hosted by Shopify. | |
| Width | Int | True |
The original width of the image in pixels. Contains null if the image isn't hosted by Shopify. | |
| Url | String | False |
The URL location of the media image. |