CData Python Connector for WooCommerce

Build 25.0.9440

CustomerMetadata

Retrieve the metadata for each customer.

Table Specific Information

Select

WooCommerce allows only a small subset of columns to be used in the WHERE clause of a SELECT query. Following columns are supported server side, all other columns are processed client side.

  • CustomerId supports the '=,IN,NOT IN,ORDER BY' operators.

SELECT * FROM Categories WHERE CustomerId = 294
SELECT * FROM Categories WHERE CustomerId IN (294,295)
SELECT * FROM Categories WHERE CustomerId NOT IN (294,295)
SELECT * FROM Categories ORDER BY CustomerId

Columns

Name Type References Description
Id [KEY] String Metadata ID.
Key String Metadata key.
Value String Metadata value.
CustomerId String

Customers.Id

Id of the customer.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9440