ProductImages
Returns the 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 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
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. |