MuleSoft Connector for WooCommerce

Build 21.0.7930


Retrieve and billing addresses for the specified customer.

Table Specific Information


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 connector will fetch a list of all the customers and perform a request for each customer in the list.

SELECT * FROM CustomerBillings WHERE CustomerId = 421


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) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930