CustomerAccountShippingAddress
CustomerAccountShippingAddress is an auto generated table. The supported operations are Querying data from this table.
Table Specific Information
Select
The connector uses the AdobeCommerce API to filter the results by CustomerId while the rest of the filter is executed client side within the connector.
You must specify the CustomerId column in the WHERE clause to retrieve results from CustomerAccountShippingAddress. CustomerId can be used only with the equals (=) operator.
For example:
SELECT * FROM [CustomerAccountShippingAddress] WHERE CustomerId = '123'
Columns
| Name | Type | Description |
| Id [KEY] | Int | ID |
| City | String | City name |
| Company | String | Company |
| CountryId | String | Country code in ISO_3166-2 format |
| CustomerId | Int | Customer ID |
| DefaultBilling | Bool | If this address is default billing address |
| DefaultShipping | Bool | If this address is default shipping address. |
| ExtensionAttributes | String | This is an auto-generated column |
| Fax | String | Fax number |
| Firstname | String | First name |
| Lastname | String | Last name |
| Middlename | String | Middle name |
| Postcode | String | Postcode |
| Prefix | String | Prefix |
| Region | String | This is an auto-generated column |
| RegionId | Int | Region ID |
| Street | String | Street |
| Suffix | String | Suffix |
| Telephone | String | Telephone number |
| VatId | String | Vat id |