ODBC Driver for Shopify

Build 24.0.9060

DeliveryProfileLocationGroupZones

Lists the applicable zones associated to the specified location group.

View-Specific Information

Select

The driver uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The driver processes other filters client-side within the driver.

  • DeliveryProfileId supports the '=,IN' comparison operators.

For example, the following queries are processed server side:

  SELECT * FROM DeliveryProfileLocationGroupZones
  SELECT * FROM DeliveryProfileLocationGroupZones WHERE DeliveryProfileId = 'Val1'

Columns

Name Type References Description
Id [KEY] String A globally-unique ID.
LocationGroupId [KEY] String Filter the location groups of the profile by location group ID.
DeliveryProfileId String

DeliveryProfiles.Id

The ID of the DeliveryProfile to return.
Name String The name of the zone.
MethodDefinitionCountsParticipantDefinitionsCount Int The number of participant method definitions for the specified zone.
MethodDefinitionCountsRateDefinitionsCount Int The number of merchant-defined method definitions for the specified zone.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060