Power BI Connector for Adobe Commerce

Build 23.0.8839


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

Table Specific Information


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

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

SELECT * FROM [ProductAttributeOptions] WHERE AttributeCode = '123'


To create a new ProductAttributeOption, AttributeCode, and Label are required.

INSERT INTO ProductAttributeOptions(AttributeCode, Label) VALUES(83,'asdw')


Name Type ReadOnly Description
IsDefault Bool False


AttributeCode String False


Label [KEY] String False

Option label

SortOrder Int False

Option order

StoreLabels String False

Option label for store scopes

Value String False

Option value

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