Power BI Connector for WooCommerce

Build 24.0.9060

Attributes

Retrieve and modify product attributes.

Table Specific Information

Select

WooCommerce allows only a small subset of columns to be used in the WHERE clause of a SELECT query. These columns support only the = comparison, unless stated otherwise. The available column for this table is: Id. All other columns are processed client side.

SELECT * FROM Attributes WHERE Id = 4

Insert

The following attribute is required when performing an insert: Name.

INSERT INTO Attributes (Name) VALUES ('attribute_name')

Columns

Name Type ReadOnly References Description
Id [KEY] Long False

Attribute ID.

Name String False

Attribute name.

Slug String False

An alphanumeric identifier for the resource unique to its type.

Type String False

Type of attribute. By default only select is supported.

OrderBy String False

Default sort order. Options: menu_order, name, name_num and id. Defaults to menu_order.

HasArchives Boolean False

Enable/Disable attribute archives. Defaults to false.

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