JDBC Driver for BigCommerce

Build 22.0.8462

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462