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

Table Specific Information

Select

The connector uses the BigCommerce API to process WHERE clause conditions built with the following columns and operators:

• Id supports the = and IN comparisons.
• CustomerId supports the = and IN comparisons.

The rest of the filter is executed client-side within the connector.

For example, the following queries are processed server-side:

SELECT * FROM CustomerAddresses WHERE Id = 1 

SELECT * FROM CustomerAddresses WHERE CustomerId = 5

Insert

To insert a customer address, specify at least the following columns: CustomerId, FirstName, LastName, City, CountryCode, Address1, StateOrProvince, and PostalCode.

INSERT INTO CustomerAddresses (CustomerId, FirstName, LastName, City, CountryCode, Address1, StateOrProvince, PostalCode) VALUES ('1', 'FirstName', 'LastName', 'Chapel Hill', 'US', '101 Europa Dr', 'NC', '27517')

Update

UPDATE CustomerAddresses SET FirstName = 'Testing123' WHERE Id = 14

Delete

DELETE FROM CustomerAddresses WHERE Id = 3

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Integer	False		ID of this customer address.
CustomerId	Integer	False	Customers.Id	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.