Power BI Connector for WooCommerce

Build 24.0.9060

States

Retrieve shipping states.

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: Country. All other columns are processed client side. If the 'Country' filter is not specified, the connector will fetch a list of all the countries and perform a request for each country in the list.

SELECT * FROM States WHERE Country = 'Germany'

Columns

Name Type References Description
Country String State code.
Code String State code.
Name String Full name of the state.

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