CData Python Connector for Shopify

Build 23.0.8839

Provinces

Query and update information regarding different provinces.

Table-Specific Information

Select

The connector uses the Shopify API to process search criteria that refer to the CountryId and Id columns. The supported SQL operator is '=' for ProductId and Id columns. The connector processes other filters client-side within the connector.

For example, the following queries are processed server-side:

SELECT * FROM Provinces WHERE CountryId = '123'

SELECT * FROM Provinces WHERE CountryId = '123' and Id = '456'

Update

You must specify the CountryId and Id to update a province. For example:

UPDATE Provinces SET Tax = '3.4' WHERE CountryId = '123' AND Id = '456'

Columns

Name Type ReadOnly References Description
Id [KEY] Long True

The ID for the province.

CountryId [KEY] Long True

Countries.Id

The ID for the country that the province belongs to.

Name String False

The full name of the province.

Code String False

The standard abbreviation for the province.

Tax Decimal False

The sales tax rate to be applied to orders made by customers from this province..

TaxPercentage Double False

The province's tax in percent format.

TaxName String False

The name of the tax for this province.

TaxType String False

The tax type. Valid values: normal, null, or harmonized. If the value is harmonized, then the tax is compounded of the provincial and federal sales taxes.

ShippingZoneId Long True

ShippingZones.Id

The ID for the shipping zone that the province belongs to.

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