Cmdlets for WooCommerce

Build 20.0.7587

CustomerBillings

Retrieve and billing addresses for the specified customer.

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

SELECT * FROM CustomerBillings WHERE CustomerId = 421

Columns

Name Type Description
FirstName String First name.
LastName String Last name.
Company String Company name.
Address1 String Address line 1
Address2 String Address line 2
City String City name.
State String ISO code or name of the state, province or district.
Postcode String Postal code.
Country String ISO code of the country.
Email String Email address.
Phone String Phone number.
CustomerId String Id of the customer.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587