CustomerAddresses
List addresses associated with customers.
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 globally-unique ID. | |
| CustomerId | String | A globally-unique ID. | |
| CustomerName | String | The full name of the customer, based on firstName and lastName. | |
| Phone | String | A unique phone number for the customer. | |
| Address1 | String | The first line of the address. Typically the street address or PO Box number. | |
| Address2 | String | The second line of the address. Typically the number of the apartment, suite, or unit. | |
| CountryCode | String | The two-letter code for the country of the address. For example, US. | |
| Country | String | The name of the country. | |
| ProvinceCode | String | The alphanumeric code for the region. For example, ON. | |
| Province | String | The region of the address, such as the province, state, or district. | |
| City | String | The name of the city, district, village, or town. | |
| Company | String | The name of the customer's company or organization. | |
| FormattedArea | String | A comma-separated list of the values for city, province, and country. | |
| Zip | String | The zip or postal code of the address. | |
| Latitude | Double | The latitude coordinate of the customer address. | |
| Longitude | Double | The longitude coordinate of the customer address. | |
| TimeZone | String | The time zone of the address. | |
| CoordinatesValidated | Bool | Whether the address corresponds to recognized latitude and longitude values. | |
| ValidationResultSummary | String | The validation status that is leveraged by the address validation feature in the Shopify Admin. |