ADO.NET Provider for BigCommerce

Build 23.0.8770

CustomerAddresses

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

Table Specific Information

Select

The 本製品 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 本製品.

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8770