CustomerAddresses
List addresses associated with customers.
Table-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'
Insert
The following columns can be used to create a new record:
CustomerId, CustomerFirstName, CustomerLastName, Phone, Address1, Address2, CountryCode, ProvinceCode, City, Company, Zip
The following pseudo-column can be used to create a new record:
SetAsDefault
Update
The following columns can be updated:
CustomerId, CustomerFirstName, CustomerLastName, Phone, Address1, Address2, CountryCode, ProvinceCode, City, Company, Zip
The following pseudo-column can be used to update a record:
SetAsDefault
Delete
You can delete entries by specifying the following columns:
Id, CustomerId
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
The globally unique identifier of the customer address. | |
| CustomerId | String | False |
The globally unique identifier of the customer associated with this address. | |
| CustomerFirstName | String | False |
The first name of the customer. | |
| CustomerLastName | String | False |
The last name of the customer. | |
| CustomerName | String | True |
The full name of the customer, based on the first name and last name. | |
| Phone | String | False |
The customer's phone number associated with the address. | |
| Address1 | String | False |
The first line of the address, typically the street address or PO Box number. | |
| Address2 | String | False |
The second line of the address, typically the number of the apartment, suite, or unit. | |
| CountryCode | String | False |
The two-letter code for the country of the address (for example, US). | |
| Country | String | True |
The name of the country for the address. | |
| ProvinceCode | String | False |
The alphanumeric code for the province, state, or district of the address, such as 'ON', for Ontario. | |
| Province | String | True |
The region of the address, such as the province, state, or district. | |
| City | String | False |
The name of the city, district, village, or town. | |
| Company | String | False |
The name of the customer's company or organization. | |
| FormattedArea | String | True |
A comma-separated list of the values for city, province, and country. | |
| Zip | String | False |
The zip or postal code of the address. | |
| Latitude | Double | True |
The latitude coordinate of the customer address. | |
| Longitude | Double | True |
The longitude coordinate of the customer address. | |
| TimeZone | String | True |
The time zone associated with the customer address. | |
| CoordinatesValidated | Bool | True |
Indicates whether the address corresponds to recognized latitude and longitude values. | |
| ValidationResultSummary | String | True |
The validation status that is leveraged by the address validation feature in the Shopify Admin. |
Pseudo-Columns
Pseudo-columns are fields that can only be used in the types of statements under which they are explicitly listed. They are not standard columns but instead provide additional functionality for specific operations.
| Name | Type | Description |
| SetAsDefault | Bool |
Indicates whether to set the address as the customer's default address. |