Power BI Connector for Adobe Commerce

Build 23.0.8839


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

Table Specific Information


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

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

SELECT * FROM [BundleProductOption] WHERE Sku = '123'

SELECT * FROM [BundleProductOption] WHERE Sku = '123' AND OptionId = '1'


Bundle options can be deleted by providing the Sku and OptionId columns.

DELETE FROM BundleProductOption WHERE Sku = 'sjl-1999' AND OptionId = '1'


Name Type ReadOnly Description
ExtensionAttributes String False

This is an auto-generated column

OptionId [KEY] Int False

Option id

Position Int False

Option position

ProductLinks String False

Product links

Required Bool False

Is required option

Sku [KEY] String False

Product sku

Title String False

Option title

Type String False

Input type

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