CustomerAddresses

Returns a list of Customer Addresses. Returns the addresses belonging to a customer.

Table Specific Information

Select

The driver will use the BigCommerce API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the driver.

Id supports the '=' comparison.
CustomerId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM CustomerAddresses

SELECT * FROM CustomerAddresses WHERE Id = 1 

SELECT * FROM CustomerAddresses WHERE CustomerId = 5

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Integer	False	ID of this customer address.
CustomerId	Integer	False	ID of the associated customer.
FirstName	String	False	The customers first name.
LastName	String	False	The customers last name.
Company	String	False	The customers company name.
Address1	String	False	The customers street address, line 1.
Address2	String	False	The customers street address, line 2.
City	String	False	The customers city/town/suburb.
StateOrProvince	String	False	The customers state/province.
PostalCode	String	False	The customers ZIP or postal code.
Country	String	False	The customers country. Must be the full country name.
CountryCode	String	False	2-letter ISO Alpha-2 code for the customers country.
Phone	String	False	The customers phone number.
AddressType	String	False	The type of the address.

JDBC Driver for BigCommerce

CustomerAddresses

Table Specific Information

Select

Columns