Power BI Connector for Adobe Commerce

Build 23.0.8839


ProductMedia is an auto generated table. The supported operations are Insert, Update, Delete, and Querying data from this table.

Table Specific Information


The 本製品 will use the AdobeCommerce API to filter the results by Sku while the rest of the filter is executed client side within the 本製品.

The Sku column must be specified in the WHERE clause to retrieve results from ProductMedia. Sku can be used only with the equals (=) operator. For example:

SELECT * FROM [ProductMedia] WHERE Sku = 'sjl-8082'


To update a ProductMedia record, you must set Sku and EntryId (refers to the Id column).

UPDATE ProductMedia SET Label = 'lbl new' WHERE EntryId = '1' AND Sku = 'sjl-8082'


Product media can be deleted by providing Sku and EntryId (refers to the Id column).

DELETE FROM ProductMedia WHERE EntryId = 1 AND Sky = 'sjl-8082'


Name Type ReadOnly Description
Id [KEY] Int False

Gallery entry ID

Sku String False


Content String False

This is an auto-generated column

Disabled Bool False

If gallery entry is hidden from product page

ExtensionAttributes String False

This is an auto-generated column

File String False

File path

Label String False

Gallery entry alternative text

MediaType String False

Media type

Position Int False

Gallery entry position (sort order)

Types String False

Gallery entry image types (thumbnail, image, small_image etc)

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