Countries
Create, select, update, and delete information regarding countries.
Table-Specific Information
Select
The driver processes all filters client-side within the driver. The following queries are the only ones processed server side:
SELECT * FROM Countries
SELECT * FROM Countries WHERE Id='123'
You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.
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 |