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' comparison.
• CustomerId supports the '=' and 'IN' comparison.

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 new CustomerAddresses, you need to specify at least the following columns: FirstName,LastName,Phone,City,PostalCode,Country,Address1,AddressType,and StateOrProvince.

INSERT INTO CustomerAddresses (FirstName,LastName,Phone,City,PostalCode,Country,Address1,AddressType,StateOrProvince) VALUES ('test','test', '3000','test','12345','test','test','residential','Washington')

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		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.