CData Python Connector for Shopify

Build 23.0.8839

Countries

Create, select, update, and delete information regarding countries.

Table-Specific Information

Select

The connector processes all filters client-side within the connector. The following queries are the only ones processed server-side:
SELECT * FROM Countries

SELECT * FROM Countries WHERE Id = '123'

Insert

You must specify the Code to create a country.

INSERT INTO Countries (Code) VALUES ("FR")

Update

You must specify the country Id to update a country. For example:

UPDATE Countries SET Tax = 0.1 WHERE Id = '123'

Delete

You must specify the Id of the country to delete it.

DELETE FROM Countries WHERE id = '123'

Columns

Name Type ReadOnly References Description
Id [KEY] Long True

A unique numeric identifier for the country.

Name String True

The name of the country.

Code String False

The code of the country.

Tax Decimal False

The amount of tax which should be applied for this country.

Provinces String False

The sub-regions of a country, such as its provinces or states. Each sub-region has the following properties: code: The two letter province or state code, country_id: The ID for the country to which this sub-region belongs, id: The ID for the particular sub-region, name: The name of the sub-region, tax: The tax value in decimal format, tax_name: The name of the tax as it is referred to in the applicable sub-region. For example, in Canada, the sales tax in the province Ontario is referred to as HST, tax_type: The tax type. Valid values: null, normal, or harmonized. If the value is harmonized, then the tax is compounded of the provincial and federal sales taxes, tax_percentage: The tax value in percent format

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