Web Integrated Connector Kit

The Web Integrated Connector Kit (WICK) is a cloud-hosted database service. The WICK solution includes access to the web-based WICK Management Studio, which provides a clean and intuitive interface to setup and manage your databases in just a few clicks. In addition, the WICK API provides developers with REST API functions to manage every aspect of their databases. With WICK, you spend more time developing and innovating rather than dealing with complicated and expensive hosting requirements.

Postman Integration

If you have Postman installed, clicking the button below will allow you to import the MySafeInfo collection into Postman.

General

Version
GET
https://mysafeinfo.com/wick/version
This method allows you to get the current version of the WICK API.
Response Body:
1.9.1.1

Account Info
GET
https://mysafeinfo.com/wick/{designerkey}/info
This method allows you to access various information about your account, quotas, whitelists, and more.
Note: The {designerkey} provides access to create, rename, and delete databases, tables, columns, and more. You are responsible for taking all reasonable steps to protect your keys.
Response Body:
{
  "Success": true,
  "Message": "",
  "DatabaseName": "default",
  "DeveloperName": "Matt",
  "IsDefault": true,
  "DatabasesCount": "2",
  "DatabasesMax": "5",
  "TablesCount": "2",
  "TablesMax": "5",
  "ColumnsMax": "15",
  "RowsMax": "1000",
  "Expires": "Never",
  "DesignerKey": "ABC123",
  "ReaderKey": "ABC234",
  "InsertKey": "ABC345",
  "UpdateKey": "ABC456",
  "DeleteKey": "ABC567",
  "DesignerReferers": "*",
  "ReaderReferers": "*",
  "InsertReferers": "*",
  "UpdateReferers": "*",
  "DeleteReferers": "*",
  "DesignerIPAddresses": "*",
  "ReaderIPAddresses": "*",
  "InsertIPAddresses": "*",
  "UpdateIPAddresses": "*",
  "DeleteIPAddresses": "*"
}

Whois
GET
https://mysafeinfo.com/wick/{designerkey}/whois
This method allows you to access the IP address and referrer when testing and setting up whitelists.
Note: The {designerkey} provides access to create, rename, and delete databases, tables, columns, and more. You are responsible for taking all reasonable steps to protect your keys.
Response Body:
{
  "Success": true,
  "Message": "",
  "IP": "127.0.0.1",
  "Referrer": "test.com"
}

Authenticate
GET
https://mysafeinfo.com/wick/authenticate/{masterkey|designerkey|readerkey|insertkey|updatekey|deletekey}
This method allows you to authenticate any of your WICK API keys.
Note: The {masterkey} provides access to create and rename databases, and access to all database keys. You are responsible for taking all reasonable steps to protect your keys.
Note: The {designerkey} provides access to create, rename, and delete databases, tables, columns, and more. You are responsible for taking all reasonable steps to protect your keys.
Note: The {readerkey} allows you to read data from your table. You are responsible for taking all reasonable steps to protect your keys.
Note: The {insertkey} allows you to add data to your table. You are responsible for taking all reasonable steps to protect your keys.
Note: The {updatekey} allows you to edit data in your table. You are responsible for taking all reasonable steps to protect your keys.
Note: The {deletekey} allows you to delete data from your table. You are responsible for taking all reasonable steps to protect your keys.
Response Body:
{
    "Success": true,
    "Message": "",
    "UserID": 9999,
    "CanUseManagementStudio": true,
    "KeyType": "Designer",
    "Schema": "ZZZ0009999",
    "DatabaseName": "Demo",
    "DeveloperName": "Matt",
    "IsDefault": false,
    "DatabasesCount": 2,
    "DatabasesMax": 5,
    "DatabasesMaxDisplay": "5",
    "TablesCount": 0,
    "TablesMax": 5,
    "TablesMaxDisplay": "5",
    "ColumnsMax": 10,
    "ColumnsMaxDisplay": "10",
    "RowsMax": 100,
    "RowsMaxDisplay": "100",
    "Expires": "2020-06-26T00:00:00",
    "ExpiresDisplay": "6/26/2020",
    "DesignerKey": "DesignerKeyIfSpeciifedKeyHasAccess",
    "ReaderKey": "ReaderKeyIfSpeciifedKeyHasAccess",
    "InsertKey": "InsertKeyIfSpeciifedKeyHasAccess",
    "UpdateKey": "UpdateKeyIfSpeciifedKeyHasAccess",
    "DeleteKey": "DeleteKeyIfSpeciifedKeyHasAccess",
    "DesignerReferers": "*",
    "ReaderReferers": "*",
    "InsertReferers": "*",
    "UpdateReferers": "*",
    "DeleteReferers": "*",
    "DesignerIPAddresses": "*",
    "ReaderIPAddresses": "*",
    "InsertIPAddresses": "*",
    "UpdateIPAddresses": "*",
    "DeleteIPAddresses": "*",
    "CanManageDatabases": false,
    "CanManageTables": true,
    "CanViewTableData": true,
    "CanInsertTableData": true,
    "CanUpdateTableData": true,
    "CanDeleteTableData": true
}

Data Types

DataTypes (all)
GET
https://mysafeinfo.com/wick/datatypes
This method allows you to get a list of all the data types that are supported.
Response Body:
[
  "bigint",
  "bit",
  "char",
  "date",
  "datetime",
  "datetime2",
  "datetimeoffset",
  "decimal",
  "float",
  "int",
  "money",
  "nchar",
  "nvarchar",
  "smalldatetime",
  "smallint",
  "smallmoney",
  "time",
  "timestamp",
  "tinyint",
  "varchar",
  "varbinary"
]

DataTypes (simple)
GET
https://mysafeinfo.com/wick/datatypes/simple
This method allows you to get a condensed list of the data types that are supported and most commonly used.
Response Body:
[
  "string",
  "number",
  "boolean",
  "date",
  "datetime",
  "decimal",
  "money"
]

DataTypes - Templates (specific)
GET
https://mysafeinfo.com/wick/datatypes/template/{datatype}
This method allows you to get the schema necessary to create or alter a column in your table, for a specific data type.


https://mysafeinfo.com/wick/datatypes/template/string 
{
  "DataType": "string",
  "AllowNulls": "No",
  "DefaultValue": "''",
  "Length": "50",
  "Unique": "No"
}

DataTypes - Templates (all)
GET
https://mysafeinfo.com/wick/datatypes/templates
This method allows you to get a list of all the data types that are supported and includes the template necessary for adding and altering columns.
Response Body:
{
   "Advanced":[
      {
         "DataType":"bigint",
         "Template":{
            "DataType":"bigint",
            "AllowNulls":"No",
            "DefaultValue":"0"
         }
      },
      {
         "DataType":"bit",
         "Template":{
            "DataType":"bit",
            "AllowNulls":"No",
            "DefaultValue":"0"
         }
      },
      {
         "DataType":"char",
         "Template":{
            "DataType":"char",
            "AllowNulls":"No",
            "DefaultValue":"''",
            "Length":"50",
            "Unique":"No"
         }
      },
      {
         "DataType":"date",
         "Template":{
            "DataType":"date",
            "AllowNulls":"No",
            "DefaultValue":""
         }
      },
      {
         "DataType":"datetime",
         "Template":{
            "DataType":"datetime",
            "AllowNulls":"No",
            "DefaultValue":""
         }
      },
      {
         "DataType":"datetime2",
         "Template":{
            "DataType":"datetime2",
            "AllowNulls":"No",
            "DefaultValue":""
         }
      },
      {
         "DataType":"datetimeoffset",
         "Template":{
            "DataType":"datetimeoffset",
            "AllowNulls":"No",
            "DefaultValue":""
         }
      },
      {
         "DataType":"decimal",
         "Template":{
            "DataType":"decimal",
            "AllowNulls":"No",
            "DefaultValue":"0",
            "Precision":"8",
            "Scale":"2"
         }
      },
      {
         "DataType":"float",
         "Template":{
            "DataType":"float",
            "AllowNulls":"No",
            "DefaultValue":"0",
            "Precision":"8",
            "Scale":"2"
         }
      },
      {
         "DataType":"int",
         "Template":{
            "DataType":"int",
            "AllowNulls":"No",
            "DefaultValue":"0"
         }
      },
      {
         "DataType":"money",
         "Template":{
            "DataType":"money",
            "AllowNulls":"No",
            "DefaultValue":"0",
            "Precision":"8",
            "Scale":"2"
         }
      },
      {
         "DataType":"nchar",
         "Template":{
            "DataType":"nchar",
            "AllowNulls":"No",
            "DefaultValue":"''",
            "Length":"50",
            "Unique":"No"
         }
      },
      {
         "DataType":"nvarchar",
         "Template":{
            "DataType":"nvarchar",
            "AllowNulls":"No",
            "DefaultValue":"''",
            "Length":"50",
            "Unique":"No"
         }
      },
      {
         "DataType":"smalldatetime",
         "Template":{
            "DataType":"smalldatetime",
            "AllowNulls":"No",
            "DefaultValue":""
         }
      },
      {
         "DataType":"smallint",
         "Template":{
            "DataType":"smallint",
            "AllowNulls":"No",
            "DefaultValue":"0"
         }
      },
      {
         "DataType":"smallmoney",
         "Template":{
            "DataType":"smallmoney",
            "AllowNulls":"No",
            "DefaultValue":"0",
            "Precision":"8",
            "Scale":"2"
         }
      },
      {
         "DataType":"time",
         "Template":{
            "DataType":"time",
            "AllowNulls":"No",
            "DefaultValue":""
         }
      },
      {
         "DataType":"timestamp",
         "Template":{
            "DataType":"timestamp",
            "AllowNulls":"No",
            "DefaultValue":""
         }
      },
      {
         "DataType":"tinyint",
         "Template":{
            "DataType":"tinyint",
            "AllowNulls":"No",
            "DefaultValue":"0"
         }
      },
      {
         "DataType":"varchar",
         "Template":{
            "DataType":"varchar",
            "AllowNulls":"No",
            "DefaultValue":"''",
            "Length":"50",
            "Unique":"No"
         }
      },
      {
         "DataType":"varbinary",
         "Template":{
            "DataType":"varbinary",
            "AllowNulls": "Yes"
         }
      }
   ],
   "Simple":[
      {
         "DataType":"string",
         "Template":{
            "DataType":"string",
            "AllowNulls":"No",
            "DefaultValue":"''",
            "Length":"50",
            "Unique":"No"
         }
      },
      {
         "DataType":"number",
         "Template":{
            "DataType":"number",
            "AllowNulls":"No",
            "DefaultValue":"0"
         }
      },
      {
         "DataType":"boolean",
         "Template":{
            "DataType":"boolean",
            "AllowNulls":"No",
            "DefaultValue":"0"
         }
      },
      {
         "DataType":"date",
         "Template":{
            "DataType":"date",
            "AllowNulls":"No",
            "DefaultValue":""
         }
      },
      {
         "DataType":"datetime",
         "Template":{
            "DataType":"datetime",
            "AllowNulls":"No",
            "DefaultValue":""
         }
      },
      {
         "DataType":"decimal",
         "Template":{
            "DataType":"decimal",
            "AllowNulls":"No",
            "DefaultValue":"0",
            "Precision":"8",
            "Scale":"2"
         }
      },
      {
         "DataType":"money",
         "Template":{
            "DataType":"money",
            "AllowNulls":"No",
            "DefaultValue":"0",
            "Precision":"8",
            "Scale":"2"
         }
      }
   ]
}

DataTypes - Suggestions
GET
https://mysafeinfo.com/wick/datatypes/suggestions
This method allows you to get a list of data type suggestions based on common keywords found in column names.
Response Body:
[
    {
        "Keyword": "active",
        "DataType": "bit"
    },
    {
        "Keyword": "amount",
        "DataType": "money"
    },
    {
        "Keyword": "amt",
        "DataType": "money"
    },
    {
        "Keyword": "date",
        "DataType": "date"
    },
    {
        "Keyword": "disabled",
        "DataType": "bit"
    },
    {
        "Keyword": "enabled",
        "DataType": "bit"
    },
    {
        "Keyword": "frequency",
        "DataType": "int"
    },
    {
        "Keyword": "id",
        "DataType": "int"
    },
    {
        "Keyword": "level",
        "DataType": "int"
    },
    {
        "Keyword": "max",
        "DataType": "int"
    },
    {
        "Keyword": "name",
        "DataType": "varchar"
    },
    {
        "Keyword": "nbr",
        "DataType": "int"
    },
    {
        "Keyword": "number",
        "DataType": "int"
    },
    {
        "Keyword": "pct",
        "DataType": "decimal"
    },
    {
        "Keyword": "percent",
        "DataType": "decimal"
    },
    {
        "Keyword": "pk",
        "DataType": "int"
    },
    {
        "Keyword": "qty",
        "DataType": "int"
    },
    {
        "Keyword": "quantity",
        "DataType": "int"
    },
    {
        "Keyword": "seq",
        "DataType": "int"
    },
    {
        "Keyword": "time",
        "DataType": "datetime"
    }
]

Databases

Databases - List
GET
https://mysafeinfo.com/wick/{masterkey}/databases
This method allows you to see a list of all of your databases.
Note: The {masterkey} provides access to create and rename databases, and access to all database keys. You are responsible for taking all reasonable steps to protect your keys.
Response Body:
[
  {
    "Success": true,
    "Message": "",
    "DatabaseName": "default",
    "DeveloperName": "Matt",
    "IsDefault": true,
    "DatabasesCount": "2",
    "DatabasesMax": "5",
    "TablesCount": "2",
    "TablesMax": "5",
    "ColumnsMax": "15",
    "RowsMax": "1000",
    "Expires": "Never",
    "DesignerKey": "ABC123",
    "ReaderKey": "ABC234",
    "InsertKey": "ABC345",
    "UpdateKey": "ABC456",
    "DeleteKey": "ABC567",
    "DesignerReferers": "*",
    "ReaderReferers": "*",
    "InsertReferers": "*",
    "UpdateReferers": "*",
    "DeleteReferers": "*",
    "DesignerIPAddresses": "*",
    "ReaderIPAddresses": "*",
    "InsertIPAddresses": "*",
    "UpdateIPAddresses": "*",
    "DeleteIPAddresses": "*"
  },
  {
    "Success": true,
    "Message": "",
    "DatabaseName": "sandbox",
    "DeveloperName": "Matt",
    "IsDefault": false,
    "DatabasesCount": "2",
    "DatabasesMax": "5",
    "TablesCount": "1",
    "TablesMax": "5",
    "ColumnsMax": "15",
    "RowsMax": "1000",
    "Expires": "Never",
    "DesignerKey": "XYZC123",
    "ReaderKey": "XYZ234",
    "InsertKey": "XYZ345",
    "UpdateKey": "XYZ456",
    "DeleteKey": "XYZ567",
    "DesignerReferers": "*",
    "ReaderReferers": "*",
    "InsertReferers": "*",
    "UpdateReferers": "*",
    "DeleteReferers": "*",
    "DesignerIPAddresses": "*",
    "ReaderIPAddresses": "*",
    "InsertIPAddresses": "*",
    "UpdateIPAddresses": "*",
    "DeleteIPAddresses": "*"
  }
]

Databases - Info
GET
https://mysafeinfo.com/wick/{masterkey}/databases/info
This method allows you to validate your master key and see your database count and maximum number of allowed databases.
Note: The {masterkey} provides access to create and rename databases, and access to all database keys. You are responsible for taking all reasonable steps to protect your keys.
Response Body:
{
  "Success": true,
  "Message": "",
  "DeveloperName": "Matt",
  "DatabasesCount": "2",
  "DatabasesMax": "5",
  "CanUseManagementStudio": true
}

Databases - Count
GET
https://mysafeinfo.com/wick/{masterkey}/databases/count
This method allows you to get the number of databases in your account.
Note: The {masterkey} provides access to create and rename databases, and access to all database keys. You are responsible for taking all reasonable steps to protect your keys.
Response Body:
{
  "ID": 2,
  "Success": true,
  "Message": ""
}

Databases - Create
GET
https://mysafeinfo.com/wick/{masterkey}/databases/create/{name}
This method allows you to create a new database, with a specific name, in your account if your quota has not been reached.
Note: The {masterkey} provides access to create and rename databases, and access to all database keys. You are responsible for taking all reasonable steps to protect your keys.
Response Body:
{
  "ID": 0,
  "Success": true,
  "Message": "Database created successfully"
}

Databases - Rename
GET
https://mysafeinfo.com/wick/{masterkey}/databases/{sourcedatabase}/rename/{targetdatabase}
This method allows you to rename a database. The database name is a friendly name used to help you manage your databases.
Note: The {masterkey} provides access to create and rename databases, and access to all database keys. You are responsible for taking all reasonable steps to protect your keys.
Response Body:
{
  "ID": 0,
  "Success": true,
  "Message": "Database renamed successfully"
}

Databases - Delete
DELETE
https://mysafeinfo.com/wick/{masterkey}/databases/{name}
This method allows you to delete a database in your account. Deleting a database will delete all the tables and data in the database.
Note: The {masterkey} provides access to create and rename databases, and access to all database keys. You are responsible for taking all reasonable steps to protect your keys.
Response Body:
{
  "ID": 0,
  "Success": true,
  "Message": "Database deleted successfully"
}

Databases - Set Default
GET
https://mysafeinfo.com/wick/{masterkey}/databases/default/{database}
This method allows you to set the default database in your account.
Note: The {masterkey} provides access to create and rename databases, and access to all database keys. You are responsible for taking all reasonable steps to protect your keys.
Response Body:
{
    "ID": 0,
    "Success": true,
    "Message": "Database default saved successfully",
    "Messages": []
}

Databases - Clone (schema only)
GET
https://mysafeinfo.com/wick/{masterkey}/databases/{sourcedatabase}/clone/{targetdatabase}
This method allows you to clone an existing database in your account. The target database must be alphanumeric and unique within your account. This will clone the schema but not the data.
Note: The {masterkey} provides access to create and rename databases, and access to all database keys. You are responsible for taking all reasonable steps to protect your keys.
Response Body:
{
  "ID": 0,
  "Success": true,
  "Message": "Database cloned successfully"
}

Databases - Clone (schema and data)
GET
https://mysafeinfo.com/wick/{masterkey}/databases/{sourcedatabase}/clone/{targetdatabase}/true
This method allows you to clone an existing database in your account. The target database must be alphanumeric and unique within your account. This will clone the schema and the data.
Note: The {masterkey} provides access to create and rename databases, and access to all database keys. You are responsible for taking all reasonable steps to protect your keys.
Response Body:
{
  "ID": 0,
  "Success": true,
  "Message": "Database cloned successfully"
}

Tables

Tables - Create
GET
https://mysafeinfo.com/wick/{designerkey}/tables/{table}/create
This method allows you to create a new table in your database. The table name must be alphanumeric and unique within your database. All tables are created with a primary key identity column named ID. The ID column can be renamed, but not deleted.
Note: The {designerkey} provides access to create, rename, and delete databases, tables, columns, and more. You are responsible for taking all reasonable steps to protect your keys.
Response Body:
{
  "ID": 0,
  "Success": true,
  "Message": "Table created successfully"
}

Tables - Create with columns
POST
https://mysafeinfo.com/wick/{designerkey}/tables/{table}/create
This method allows you to create a new table in your database and optionally create the columns in bulk. The table name must be alphanumeric and unique within your database. All tables are created with a primary key identity column named ID. The ID column can be renamed, but not deleted.
Note: The {designerkey} provides access to create, rename, and delete databases, tables, columns, and more. You are responsible for taking all reasonable steps to protect your keys.
Content-Type:
application/json; charset=utf-8
Request Body:
[
  {
    "Name": "Column1",
    "DataType": "varchar",
    "AllowNulls": "No",
    "DefaultValue": "''",
    "Length": "50",
    "Unique": "No"
  },
  {
    "Name": "Column2",
    "DataType": "int",
    "AllowNulls": "No",
    "DefaultValue": "0"
  },
  {
    "Name": "Column3",
    "DataType": "decimal",
    "AllowNulls": "No",
    "DefaultValue": "0",
    "Precision": "8",
    "Scale": "2"
  }
]
Response Body:
{
  "ID": 0,
  "Success": true,
  "Message": "Table created successfully"
}

Tables - Delete
DELETE
https://mysafeinfo.com/wick/{designerkey}/tables/{table}
This method allows you to delete a table in your database.
Note: The {designerkey} provides access to create, rename, and delete databases, tables, columns, and more. You are responsible for taking all reasonable steps to protect your keys.
Response Body:
{
  "ID": 0,
  "Success": true,
  "Message": "Table deleted successfully"
}

Tables - Rename
GET
https://mysafeinfo.com/wick/{designerkey}/tables/{sourcetable}/rename/{targettable}
This method allows you to rename an existing table in your database. The target table must be alphanumeric and unique within your database.
Note: The {designerkey} provides access to create, rename, and delete databases, tables, columns, and more. You are responsible for taking all reasonable steps to protect your keys.
Response Body:
{
  "ID": 0,
  "Success": true,
  "Message": "Table renamed successfully"
}

Tables - Clone (schema only)
GET
https://mysafeinfo.com/wick/{designerkey}/tables/{sourcetable}/clone/{targettable}
This method allows you to clone an existing table in your database. The target table must be alphanumeric and unique within your database. This will clone the schema but not the data.
Note: The {designerkey} provides access to create, rename, and delete databases, tables, columns, and more. You are responsible for taking all reasonable steps to protect your keys.
Response Body:
{
  "ID": 0,
  "Success": true,
  "Message": "Table cloned successfully"
}

Tables - Clone (schema and data)
GET
https://mysafeinfo.com/wick/{designerkey}/tables/{sourcetable}/clone/{targettable}/true
This method allows you to clone an existing table in your database. The target table must be alphanumeric and unique within your database. This will clone the schema and the data.
Note: The {designerkey} provides access to create, rename, and delete databases, tables, columns, and more. You are responsible for taking all reasonable steps to protect your keys.
Response Body:
{
  "ID": 0,
  "Success": true,
  "Message": "Table cloned successfully"
}

Tables - List
GET
https://mysafeinfo.com/wick/{designerkey|readerkey|insertkey|updatekey|deletekey}/tables
This method allows you to get the list of tables in your database.
Note: The {designerkey} provides access to create, rename, and delete databases, tables, columns, and more. You are responsible for taking all reasonable steps to protect your keys.
Note: The {readerkey} allows you to read data from your table. You are responsible for taking all reasonable steps to protect your keys.
Note: The {insertkey} allows you to add data to your table. You are responsible for taking all reasonable steps to protect your keys.
Note: The {updatekey} allows you to edit data in your table. You are responsible for taking all reasonable steps to protect your keys.
Note: The {deletekey} allows you to delete data from your table. You are responsible for taking all reasonable steps to protect your keys.
Response Body:
[
  {
    "Name": "table1",
    "CreateDate": "2015-05-17T17:49:44.23",
    "ModifyDate": "2015-05-20T12:35:16.187",
    "RowCount": 1176,
    "ColumnCount": 11
  },
  {
    "Name": "table2",
    "CreateDate": "2015-05-28T17:58:20.39",
    "ModifyDate": "2015-05-28T17:58:36.79",
    "RowCount": 59,
    "ColumnCount": 5
  },
  {
    "Name": "table3",
    "CreateDate": "2015-05-28T17:59:20.31",
    "ModifyDate": "2015-05-28T17:59:20.343",
    "RowCount": 27,
    "ColumnCount": 7
  }
]

Tables - Count
GET
https://mysafeinfo.com/wick/{designerkey}/tables/count
This method allows you to get the number of tables in your database.
Note: The {designerkey} provides access to create, rename, and delete databases, tables, columns, and more. You are responsible for taking all reasonable steps to protect your keys.
Response Body:
{
  "ID": 4,
  "Success": true,
  "Message": ""
}

Tables - Record Count
GET
https://mysafeinfo.com/wick/{designerkey}/tables/{table}/records/count
This method allows you to get the number of records in your table.
Note: The {designerkey} provides access to create, rename, and delete databases, tables, columns, and more. You are responsible for taking all reasonable steps to protect your keys.
Response Body:
{
  "ID": 11,
  "Success": true,
  "Message": ""
}

Tables - Template
GET
https://mysafeinfo.com/wick/{designerkey|readerkey|insertkey|updatekey|deletekey}/tables/{table}/template
This method allows you to get the template of your table in JSON format to use for the for the POST/PUT when inserting/editing table data.
Note: The {designerkey} provides access to create, rename, and delete databases, tables, columns, and more. You are responsible for taking all reasonable steps to protect your keys.
Note: The {readerkey} allows you to read data from your table. You are responsible for taking all reasonable steps to protect your keys.
Note: The {insertkey} allows you to add data to your table. You are responsible for taking all reasonable steps to protect your keys.
Note: The {updatekey} allows you to edit data in your table. You are responsible for taking all reasonable steps to protect your keys.
Note: The {deletekey} allows you to delete data from your table. You are responsible for taking all reasonable steps to protect your keys.
Response Body:
{
  "customerid": "",
  "customername": "",
  "customertype": "",
  "address1": "",
  "address2": "",
  "city": "",
  "statecode": "",
  "postalcode": "",
  "countrycode": "",
  "phonenumber": "",
  "emailaddress": ""
}

Tables - Export
GET
https://mysafeinfo.com/wick/{designerkey}/tables/export

This method allows you to download a zip file containing all of your tables exported in the specified format.

You can optionally specify which format you want your data exported as using the following querystring parameter:
  • format=json (default)
  • format=xml
  • format=csv
  • format=excel
Note: The {designerkey} provides access to create, rename, and delete databases, tables, columns, and more. You are responsible for taking all reasonable steps to protect your keys.
Response Body:
Compressed zip file

Tables - Import
POST
https://mysafeinfo.com/wick/{designerkey}/tables/{table}/import
This method allows you to create a new table in your database with the schema and data from a Base64 encoded file containing JSON, XML, CSV, or Excel (xlsx) data. This example uses the JSON data for the U.S. Original 13 Colonies. Whether you are using JSON, XML, CSV, or Excel data, you simply need to Base64 encode the data to POST in the request body. The table name must be alphanumeric and unique within your database. All tables are created with a primary key identity column named ID. The ID column can be renamed, but not deleted.
Note: The {designerkey} provides access to create, rename, and delete databases, tables, columns, and more. You are responsible for taking all reasonable steps to protect your keys.
Request Body:
Wwp7CiJZZWFyIjogMTYwNywKIlN0YXRlTmFtZSI6ICJWaXJnaW5pYSIsCiJTdGF0ZUNvZGUiOiAiVkEiCn0sCnsKIlllYXIiOiAxNjI2LAoiU3RhdGVOYW1lIjogIkNvbm5lY3RpY3V0IiwKIlN0YXRlQ29kZSI6ICJDVCIKfSwKewoiWWVhciI6IDE2MjYsCiJTdGF0ZU5hbWUiOiAiTmV3IFlvcmsiLAoiU3RhdGVDb2RlIjogIk5ZIgp9LAp7CiJZZWFyIjogMTYzMCwKIlN0YXRlTmFtZSI6ICJNYXNzYWNodXNldHRzIiwKIlN0YXRlQ29kZSI6ICJNQSIKfSwKewoiWWVhciI6IDE2MzMsCiJTdGF0ZU5hbWUiOiAiTWFyeWxhbmQiLAoiU3RhdGVDb2RlIjogIk1EIgp9LAp7CiJZZWFyIjogMTYzNiwKIlN0YXRlTmFtZSI6ICJSaG9kZSBJc2xhbmQiLAoiU3RhdGVDb2RlIjogIlJJIgp9LAp7CiJZZWFyIjogMTYzOCwKIlN0YXRlTmFtZSI6ICJOZXcgSGFtcHNoaXJlIiwKIlN0YXRlQ29kZSI6ICJOSCIKfSwKewoiWWVhciI6IDE2MzgsCiJTdGF0ZU5hbWUiOiAiRGVsYXdhcmUiLAoiU3RhdGVDb2RlIjogIkRFIgp9LAp7CiJZZWFyIjogMTY1MywKIlN0YXRlTmFtZSI6ICJOb3J0aCBDYXJvbGluYSIsCiJTdGF0ZUNvZGUiOiAiTkMiCn0sCnsKIlllYXIiOiAxNjYzLAoiU3RhdGVOYW1lIjogIlNvdXRoIENhcm9saW5hIiwKIlN0YXRlQ29kZSI6ICJTQyIKfSwKewoiWWVhciI6IDE2NjQsCiJTdGF0ZU5hbWUiOiAiTmV3IEplcnNleSIsCiJTdGF0ZUNvZGUiOiAiTkoiCn0sCnsKIlllYXIiOiAxNjgyLAoiU3RhdGVOYW1lIjogIlBlbm5zeWx2YW5pYSIsCiJTdGF0ZUNvZGUiOiAiUEEiCn0sCnsKIlllYXIiOiAxNzMyLAoiU3RhdGVOYW1lIjogIkdlb3JnaWEiLAoiU3RhdGVDb2RlIjogIkdBIgp9Cl0=
Response Body:
{
  "ID": 0,
  "Success": true,
  "Message": "Table imported successfully"
}

Columns

Columns - Create
GET
https://mysafeinfo.com/wick/{designerkey}/tables/{table}/columns/{column}/create?datatype={datatype}&allownulls={allownulls}&defaultvalue={defaultvalue}&length={length}&precision={precision}&scale={scale}&unique={unique}
This method allows you to create a new column in your table. The column name must be alphanumeric and unique within your table.
Note: The {designerkey} provides access to create, rename, and delete databases, tables, columns, and more. You are responsible for taking all reasonable steps to protect your keys.
Response Body:
{
  "ID": 0,
  "Success": true,
  "Message": "Column created successfully"
}

Columns - Create
POST
https://mysafeinfo.com/wick/{designerkey}/tables/{table}/columns/{column}/create
This method allows you to create a new column in your table. The column name must be alphanumeric and unique within your table. The request body for this API call expects a datatype template to be passed in.
Note: The {designerkey} provides access to create, rename, and delete databases, tables, columns, and more. You are responsible for taking all reasonable steps to protect your keys.
Content-Type:
application/json; charset=utf-8
Request Body:
{
    "DataType": "varchar",
    "AllowNulls": "No",
    "DefaultValue": "''",
    "Length": "50",
    "Precision": "8",
    "Scale": "2",
    "Unique": "No"
}
Response Body:
{
  "ID": 0,
  "Success": true,
  "Message": "Column created successfully"
}

Columns - Create (Bulk)
POST
https://mysafeinfo.com/wick/{designerkey}/tables/{table}/columns
This method allows you to add, alter, rename, and delete columns in your table in bulk. Column names must be alphanumeric and unique within your table.
Note: The {designerkey} provides access to create, rename, and delete databases, tables, columns, and more. You are responsible for taking all reasonable steps to protect your keys.
Actions:
add
alter
rename
delete
rename,alter
Content-Type:
application/json; charset=utf-8
Request Body:
[
  {
    "Action": "add",
    "SourceColumn": "Column1",
    "DataType": "varchar",
    "AllowNulls": "No",
    "DefaultValue": "''",
    "Length": "50",
    "Unique": "No"
  },
  {
    "Action": "alter",
    "SourceColumn": "Column1",
    "DataType": "varchar",
    "AllowNulls": "No",
    "DefaultValue": "''",
    "Length": "100",
    "Unique": "No"
  },
  {
    "Action": "rename",
    "SourceColumn": "Column1",
    "TargetColumn": "Column2"
  },
  {
    "Action": "delete",
    "SourceColumn": "Column1"
  },
  {
    "Action": "add",
    "SourceColumn": "Column1",
    "DataType": "int",
    "AllowNulls": "No",
    "DefaultValue": "0"
  },
  {
    "Action": "rename,alter",
    "SourceColumn": "Column1",
    "TargetColumn": "Column2",
    "DataType": "decimal",
    "AllowNulls": "No",
    "DefaultValue": "0",
    "Precision": "8",
    "Scale": "2"
  }
]
Response Body:
{
  "ID": 0,
  "Success": true,
  "Message": "Columns processed successfully"
}

Columns - Delete
DELETE
https://mysafeinfo.com/wick/{designerkey}/tables/{table}/columns/{column}
This method allows you to delete a column in your table.
Note: The {designerkey} provides access to create, rename, and delete databases, tables, columns, and more. You are responsible for taking all reasonable steps to protect your keys.
Response Body:
{
  "ID": 0,
  "Success": true,
  "Message": "Column deleted successfully"
}

Columns - Rename
GET
https://mysafeinfo.com/wick/{designerkey}/tables/{table}/columns/{sourcecolumn}/rename/{targetcolumn}
This method allows you to rename an existing column in your table. The target column must be alphanumeric and unique within your table.
Note: The {designerkey} provides access to create, rename, and delete databases, tables, columns, and more. You are responsible for taking all reasonable steps to protect your keys.
Response Body:
{
  "ID": 0,
  "Success": true,
  "Message": "Column renamed successfully"
}

Columns - Alter
POST
https://mysafeinfo.com/wick/{designerkey}/tables/{table}/columns/{column}/alter
This method allows you to alter an existing column in your table. The request body for this API call expects a datatype template to be passed in.
Note: The {designerkey} provides access to create, rename, and delete databases, tables, columns, and more. You are responsible for taking all reasonable steps to protect your keys.
Content-Type:
application/json; charset=utf-8
Request Body:
{
    "DataType": "varchar",
    "AllowNulls": "No",
    "DefaultValue": "''",
    "Length": "50",
    "Precision": "8",
    "Scale": "2",
    "Unique": "No"
}
Response Body:
{
  "ID": 0,
  "Success": true,
  "Message": "Column altered successfully"
}

Columns - List
GET
https://mysafeinfo.com/wick/{designerkey|readerkey|insertkey|updatekey|deletekey}/tables/{table}/columns
This method allows you to get the list of columns in your table.
Note: The {designerkey} provides access to create, rename, and delete databases, tables, columns, and more. You are responsible for taking all reasonable steps to protect your keys.
Note: The {readerkey} allows you to read data from your table. You are responsible for taking all reasonable steps to protect your keys.
Note: The {insertkey} allows you to add data to your table. You are responsible for taking all reasonable steps to protect your keys.
Note: The {updatekey} allows you to edit data in your table. You are responsible for taking all reasonable steps to protect your keys.
Note: The {deletekey} allows you to delete data from your table. You are responsible for taking all reasonable steps to protect your keys.
Response Body:
[
  {
    "Name": "customerid",
    "Type": "int",
    "Length": 4,
    "Precision": 10,
    "Scale": 0,
    "Collation": "",
    "Nullable": false,
    "Identity": true,
    "Default": "",
    "Sequence": 1
  },
  {
    "Name": "customername",
    "Type": "varchar",
    "Length": 80,
    "Precision": 0,
    "Scale": 0,
    "Collation": "SQL_Latin1_General_CP1_CI_AS",
    "Nullable": false,
    "Identity": false,
    "Default": "('')",
    "Sequence": 2
  },
  {
    "Name": "customertype",
    "Type": "varchar",
    "Length": 20,
    "Precision": 0,
    "Scale": 0,
    "Collation": "SQL_Latin1_General_CP1_CI_AS",
    "Nullable": false,
    "Identity": false,
    "Default": "('')",
    "Sequence": 3
  },
  {
    "Name": "address1",
    "Type": "varchar",
    "Length": 80,
    "Precision": 0,
    "Scale": 0,
    "Collation": "SQL_Latin1_General_CP1_CI_AS",
    "Nullable": false,
    "Identity": false,
    "Default": "('')",
    "Sequence": 4
  },
  {
    "Name": "address2",
    "Type": "varchar",
    "Length": 80,
    "Precision": 0,
    "Scale": 0,
    "Collation": "SQL_Latin1_General_CP1_CI_AS",
    "Nullable": false,
    "Identity": false,
    "Default": "('')",
    "Sequence": 5
  },
  {
    "Name": "city",
    "Type": "varchar",
    "Length": 40,
    "Precision": 0,
    "Scale": 0,
    "Collation": "SQL_Latin1_General_CP1_CI_AS",
    "Nullable": false,
    "Identity": false,
    "Default": "('')",
    "Sequence": 6
  },
  {
    "Name": "statecode",
    "Type": "char",
    "Length": 2,
    "Precision": 0,
    "Scale": 0,
    "Collation": "SQL_Latin1_General_CP1_CI_AS",
    "Nullable": false,
    "Identity": false,
    "Default": "('')",
    "Sequence": 7
  },
  {
    "Name": "postalcode",
    "Type": "varchar",
    "Length": 10,
    "Precision": 0,
    "Scale": 0,
    "Collation": "SQL_Latin1_General_CP1_CI_AS",
    "Nullable": false,
    "Identity": false,
    "Default": "('')",
    "Sequence": 8
  },
  {
    "Name": "countrycode",
    "Type": "varchar",
    "Length": 3,
    "Precision": 0,
    "Scale": 0,
    "Collation": "SQL_Latin1_General_CP1_CI_AS",
    "Nullable": false,
    "Identity": false,
    "Default": "('')",
    "Sequence": 9
  },
  {
    "Name": "phonenumber",
    "Type": "varchar",
    "Length": 10,
    "Precision": 0,
    "Scale": 0,
    "Collation": "SQL_Latin1_General_CP1_CI_AS",
    "Nullable": false,
    "Identity": false,
    "Default": "('')",
    "Sequence": 10
  },
  {
    "Name": "emailaddress",
    "Type": "varchar",
    "Length": 80,
    "Precision": 0,
    "Scale": 0,
    "Collation": "SQL_Latin1_General_CP1_CI_AS",
    "Nullable": false,
    "Identity": false,
    "Default": "('')",
    "Sequence": 11
  }
]

Columns - Count
GET
https://mysafeinfo.com/wick/{designerkey}/tables/{table}/columns/count
This method allows you to get the number of columns in your table.
Note: The {designerkey} provides access to create, rename, and delete databases, tables, columns, and more. You are responsible for taking all reasonable steps to protect your keys.
Response Body:
{
  "ID": 11,
  "Success": true,
  "Message": ""
}

Writer

Writer - Insert
POST
https://mysafeinfo.com/wick/{insertkey}/tables/{table}
This method allows you to create a new record in your table. The request body for this API call expects a table template to be passed in.
Note: The {insertkey} allows you to add data to your table. You are responsible for taking all reasonable steps to protect your keys.
Note: Not all columns are required to be specified; however, any column not specified must either allow nulls or have a default value.
Content-Type:
application/json; charset=utf-8
Request Body:
{
    "Column1": "",
    "Column2": "",
    "Column3": ""
}
Response Body:
{
  "ID": 1,
  "Success": true,
  "Message": "Record added successfully"
}

Writer - Update
PUT
https://mysafeinfo.com/wick/{updatekey}/tables/{table}/{id}
This method allows you to update an existing record in your table. The request body for this API call expects a table template to be passed in.
Note: The {updatekey} allows you to edit data in your table. You are responsible for taking all reasonable steps to protect your keys.
Note: This performs a delta update on the existing record. If you pass in Column1=ABC it would update the record to have a value of ABC for Column1 and would leave any other columns unchanged.
Content-Type:
application/json; charset=utf-8
Request Body:
{
    "Column1": "",
    "Column2": "",
    "Column3": ""
}
Response Body:
{
  "ID": 0,
  "Success": true,
  "Message": "Record updated successfully"
}

Writer - Delete
DELETE
https://mysafeinfo.com/wick/{deletekey}/tables/{table}/{id}
This method allows you to delete a record from your table.
Note: The {deletekey} allows you to delete data from your table. You are responsible for taking all reasonable steps to protect your keys.
Response Body:
{
  "ID": 0,
  "Success": true,
  "Message": "Record deleted successfully"
}

Writer - Truncate
GET
https://mysafeinfo.com/wick/{deletekey}/tables/{table}/truncate
This method allows you to truncate your table.
Note: The {deletekey} allows you to delete data from your table. You are responsible for taking all reasonable steps to protect your keys.
Response Body:
{
  "ID": 0,
  "Success": true,
  "Message": "Table truncated successfully"
}

Writer - Add/Update/Delete (Bulk)
PATCH
https://mysafeinfo.com/wick/{designerkey}/tables/{table}
This method allows you to add, update, or delete records in your table in bulk.
Note: The {designerkey} provides access to create, rename, and delete databases, tables, columns, and more. You are responsible for taking all reasonable steps to protect your keys.
Identity column values:
 0 = add
 N = update
-N = delete
Content-Type:
application/json; charset=utf-8
Request Body:
[
  {
    "ID": "0",
    "Email": "bill@test.com",
    "Name": "Bill Smith"
  },
  {
    "ID": "0",
    "Email": "sally@test.com",
    "Name": "Sally Jones"
  },
  {
    "ID": "-2"
  },
  {
    "ID": "-4"
  },
  {
    "ID": "5",
    "Name": "Bob"
  }
]
Response Body:
{
  "ID": 0,
  "Success": true,
  "Message": "Records processed successfully"
}

Reader

Reader - List
GET
https://mysafeinfo.com/wick/{designerkey|readerkey|insertkey|updatekey|deletekey}/tables/{table}
This method allows you to get all data from your table.
Note: The {designerkey} provides access to create, rename, and delete databases, tables, columns, and more. You are responsible for taking all reasonable steps to protect your keys.
Note: The {readerkey} allows you to read data from your table. You are responsible for taking all reasonable steps to protect your keys.
Note: The {insertkey} allows you to add data to your table. You are responsible for taking all reasonable steps to protect your keys.
Note: The {updatekey} allows you to edit data in your table. You are responsible for taking all reasonable steps to protect your keys.
Note: The {deletekey} allows you to delete data from your table. You are responsible for taking all reasonable steps to protect your keys.
Response Body:
[
  {
    "customerid": 45,
    "customername": "Stunkard Brokers Services",
    "customertype": "",
    "address1": "",
    "address2": "",
    "city": "Kaufman",
    "statecode": "TX",
    "postalcode": "58145",
    "countrycode": "",
    "phonenumber": "555144816",
    "emailaddress": ""
  },
  {
    "customerid": 46,
    "customername": "Jovic Delivery  LLC",
    "customertype": "",
    "address1": "",
    "address2": "",
    "city": "Waynesburg",
    "statecode": "PA",
    "postalcode": "62982",
    "countrycode": "",
    "phonenumber": "555139639",
    "emailaddress": ""
  },
  {
    "customerid": 47,
    "customername": "Juntilla Packaging",
    "customertype": "",
    "address1": "",
    "address2": "",
    "city": "Waynesburg",
    "statecode": "PA",
    "postalcode": "106368",
    "countrycode": "",
    "phonenumber": "555127017",
    "emailaddress": ""
  }
]

Reader - Get
GET
https://mysafeinfo.com/wick/{designerkey|readerkey|insertkey|updatekey|deletekey}/tables/{table}/{id}
This method allows you to get a specific record from your table.
Note: The {designerkey} provides access to create, rename, and delete databases, tables, columns, and more. You are responsible for taking all reasonable steps to protect your keys.
Note: The {readerkey} allows you to read data from your table. You are responsible for taking all reasonable steps to protect your keys.
Note: The {insertkey} allows you to add data to your table. You are responsible for taking all reasonable steps to protect your keys.
Note: The {updatekey} allows you to edit data in your table. You are responsible for taking all reasonable steps to protect your keys.
Note: The {deletekey} allows you to delete data from your table. You are responsible for taking all reasonable steps to protect your keys.
Response Body:
{
  "customerid": 45,
  "customername": "Stunkard Brokers Services",
  "customertype": "",
  "address1": "",
  "address2": "",
  "city": "Kaufman",
  "statecode": "TX",
  "postalcode": "58145",
  "countrycode": "",
  "phonenumber": "555144816",
  "emailaddress": ""
}

Reader - Custom Data API
GET
https://mysafeinfo.com/api/data?list=custom&token={readerkey}&table={table}&format=json
This method allows you to tap into the Data API to retrieve your data. The Data API provides several features to customize your data, including formatting, sorting, paging, filtering, column aliasing, column selection, and much more.
Note: The {readerkey} allows you to read data from your table. You are responsible for taking all reasonable steps to protect your keys.
Response Body:
[
  {
    "customerid": 45,
    "customername": "Stunkard Brokers Services",
    "customertype": "",
    "address1": "",
    "address2": "",
    "city": "Kaufman",
    "statecode": "TX",
    "postalcode": "58145",
    "countrycode": "",
    "phonenumber": "555144816",
    "emailaddress": ""
  },
  {
    "customerid": 46,
    "customername": "Jovic Delivery  LLC",
    "customertype": "",
    "address1": "",
    "address2": "",
    "city": "Waynesburg",
    "statecode": "PA",
    "postalcode": "62982",
    "countrycode": "",
    "phonenumber": "555139639",
    "emailaddress": ""
  },
  {
    "customerid": 47,
    "customername": "Juntilla Packaging",
    "customertype": "",
    "address1": "",
    "address2": "",
    "city": "Waynesburg",
    "statecode": "PA",
    "postalcode": "106368",
    "countrycode": "",
    "phonenumber": "555127017",
    "emailaddress": ""
  }
]

Sample Databases

Sample Databases - List
GET
https://mysafeinfo.com/wick/databases/samples
This method allows you to see a list of sample databases that can be cloned for testing purposes.
Response Body:
[
    {
        "SampleDatabaseID": 4,
        "Key": "sample",
        "Schema": "ZSAMPLE000",
        "Title": "Sample Database",
        "Description": "",
        "Url": "",
        "Enabled": true,
        "Sequence": 0,
        "CreatedBy": "matt",
        "CreatedDate": "2016-11-24T22:24:41.853",
        "UpdatedBy": "matt",
        "UpdatedDate": "2016-11-24T22:24:41.853"
    },
    {
        "SampleDatabaseID": 1,
        "Key": "tasks",
        "Schema": "ZSAMPLE001",
        "Title": "Sample Project Management Database",
        "Description": "",
        "Url": "",
        "Enabled": true,
        "Sequence": 100,
        "CreatedBy": "matt",
        "CreatedDate": "2016-11-24T21:51:17.503",
        "UpdatedBy": "matt",
        "UpdatedDate": "2016-11-24T21:51:17.503"
    },
    {
        "SampleDatabaseID": 2,
        "Key": "products",
        "Schema": "ZSAMPLE002",
        "Title": "Sample Products Database",
        "Description": "",
        "Url": "",
        "Enabled": true,
        "Sequence": 100,
        "CreatedBy": "matt",
        "CreatedDate": "2016-11-24T21:51:29.457",
        "UpdatedBy": "matt",
        "UpdatedDate": "2016-11-24T21:51:29.457"
    },
    {
        "SampleDatabaseID": 3,
        "Key": "bikeshop",
        "Schema": "ZSAMPLE003",
        "Title": "Sample Bike Shop Database",
        "Description": "",
        "Url": "",
        "Enabled": true,
        "Sequence": 100,
        "CreatedBy": "matt",
        "CreatedDate": "2016-11-24T21:51:44.58",
        "UpdatedBy": "matt",
        "UpdatedDate": "2016-11-24T21:51:44.58"
    },
    {
        "SampleDatabaseID": 5,
        "Key": "lawn",
        "Schema": "ZSAMPLE004",
        "Title": "Sample Lawn Service Database",
        "Description": "",
        "Url": "",
        "Enabled": true,
        "Sequence": 100,
        "CreatedBy": "matt",
        "CreatedDate": "2016-11-25T14:00:12.137",
        "UpdatedBy": "matt",
        "UpdatedDate": "2016-11-25T14:00:12.137"
    },
    {
        "SampleDatabaseID": 6,
        "Key": "lessons",
        "Schema": "ZSAMPLE005",
        "Title": "Sample Music Lessons Database",
        "Description": "",
        "Url": "",
        "Enabled": true,
        "Sequence": 100,
        "CreatedBy": "david",
        "CreatedDate": "2016-11-25T18:10:19.517",
        "UpdatedBy": "david",
        "UpdatedDate": "2016-11-25T18:10:19.517"
    }
]

Sample Databases - Create
GET
https://mysafeinfo.com/wick/{masterkey}/databases/sample/{targetdatabase}/{sampledatabasekey}
This method allows you to create a sample database in your account. The target database must be alphanumeric and unique within your account.
Note: The {masterkey} provides access to create and rename databases, and access to all database keys. You are responsible for taking all reasonable steps to protect your keys.
Response Body:
{
    "ID": 0,
    "Success": true,
    "Message": "Database created successfully",
    "Messages": []
}

Code Gen

Code Gen - Web
GET
https://mysafeinfo.com/wick/{designerkey|readerkey|insertkey|updatekey|deletekey}/tables/{table}/codegen/web/{version}
This method allows you to generate the web code necessary to fetch and bind your table data. Use version=1 for a generic web template. Use version=2 for a non-generic web template.
Note: The {designerkey} provides access to create, rename, and delete databases, tables, columns, and more. You are responsible for taking all reasonable steps to protect your keys.
Note: The {readerkey} allows you to read data from your table. You are responsible for taking all reasonable steps to protect your keys.
Note: The {insertkey} allows you to add data to your table. You are responsible for taking all reasonable steps to protect your keys.
Note: The {updatekey} allows you to edit data in your table. You are responsible for taking all reasonable steps to protect your keys.
Note: The {deletekey} allows you to delete data from your table. You are responsible for taking all reasonable steps to protect your keys.

Code Gen - Model
GET
https://mysafeinfo.com/wick/{designerkey|readerkey|insertkey|updatekey|deletekey}/tables/{table}/codegen/model/{language}
This method allows you to generate the C#/VB.Net model class for your table. Use language=cs for C#. Use language=vb for VB.Net.
Note: The {designerkey} provides access to create, rename, and delete databases, tables, columns, and more. You are responsible for taking all reasonable steps to protect your keys.
Note: The {readerkey} allows you to read data from your table. You are responsible for taking all reasonable steps to protect your keys.
Note: The {insertkey} allows you to add data to your table. You are responsible for taking all reasonable steps to protect your keys.
Note: The {updatekey} allows you to edit data in your table. You are responsible for taking all reasonable steps to protect your keys.
Note: The {deletekey} allows you to delete data from your table. You are responsible for taking all reasonable steps to protect your keys.
Response Body:
public class mytable
{
	// constructor
	public mytable()
	{
		ID = 0;
		Name = string.Empty;
		Email = string.Empty;
		DisplayName = string.Empty;
	}

	// public properties
	public int ID { get; set; }
	public string Name { get; set; }
	public string Email { get; set; }
	public string DisplayName { get; set; }
}