CustomerAddresses
Lists addresses linked to customer accounts, including default shipping and billing details.
View-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the following column and operators. The connector processes other filters client-side within the connector.
- CustomerId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM CustomerAddresses WHERE CustomerId = 'Val1'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A unique identifier for the customer address record. | |
| CustomerId | String | The unique identifier of the customer to whom this address belongs. | |
| CustomerName | String | The full name of the customer, derived from their first and last name fields. | |
| Phone | String | The customer's contact phone number, formatted according to international standards where possible. | |
| Address1 | String | The first line of the address, typically containing the street address or PO Box number. | |
| Address2 | String | The second line of the address, often used for apartment, suite, or unit numbers. | |
| CountryCode | String | The two-letter ISO country code representing the country of the address (for example, US). | |
| Country | String | The full country name for the address. | |
| ProvinceCode | String | The alphanumeric code identifying the state, province, or region (for example, ON). | |
| Province | String | The administrative region for the address, such as the state, province, or district. | |
| City | String | The name of the city, town, or local area for the address. | |
| Company | String | The name of the company or organization associated with the customer address, if applicable. | |
| FormattedArea | String | A comma-separated formatted list combining the city, province, and country for display purposes. | |
| Zip | String | The postal or ZIP code of the address. | |
| Latitude | Double | The latitude coordinate corresponding to the customer's address location. | |
| Longitude | Double | The longitude coordinate corresponding to the customer's address location. | |
| TimeZone | String | The time zone associated with the address location. | |
| CoordinatesValidated | Bool | Indicates whether the address's latitude and longitude have been verified against known geographic data. | |
| ValidationResultSummary | String | A summary of the address validation outcome, as used by Shopify's address validation feature in the Admin interface. |