DeliveryProfileLocationGroupCountries
Lists countries assigned to location groups within a specific delivery profile.
View-Specific Information
Select
The connector processes all filters client-side within the connector. The following query is the only one processed server-side:
SELECT * FROM DeliveryProfileLocationGroupCountries
Columns
| Name | Type | References | Description |
| CountryId [KEY] | String | A unique identifier for the country associated with this delivery profile location group. | |
| LocationGroupId [KEY] | String | The unique identifier of the location group that this country belongs to within the delivery profile. | |
| DeliveryProfileId | String | The unique identifier of the delivery profile that defines shipping rates and zones for this country. | |
| Zone | String | The name of the shipping zone that includes this country. | |
| CountryName | String | The full name of the country included in the location group. | |
| CountryTranslatedName | String | The localized translation of the country name, returned based on the system's active locale. | |
| CountryCodeCountryCode | String | The two-letter ISO 3166-1 alpha-2 country code representing the country. | |
| CountryCodeRestOfWorld | Bool | Indicates whether the country belongs to the 'Rest of World' shipping zone, which includes all countries not explicitly assigned to another zone. |