Provinces
Query and update information regarding different provinces.
Table-Specific Information
Select
The adapter uses the Shopify API to process search criteria that refer to the ProductId, UpdatedAt, and Handle columns. The supported SQL operators are '=' and 'IN' for ProductId, '=' for Handle, and '>' for the CreatedAt column. The adapter processes other filters client-side within the adapter.
For example, the following queries are processed server side:
SELECT * FROM Provinces
SELECT * FROM Provinces WHERE CountryId='123'
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 |
The ID for the shipping zone that the province belongs to. |