Method UserTableCreateTable

UserTableCreateTable(String, String, List<String>, Boolean, String)

Creates a user table

Declaration

void UserTableCreateTable(string connectionId, string userTable, List<string> columnHeaders, bool addAutoIncrementColumn, string protectionDomainId)

Parameters

Type	Name	Description
System.String	connectionId	The connection id to identify your connection. See also ConnectionId
System.String	userTable	Name of the user table
System.Collections.Generic.List<System.String>	columnHeaders	A list of column headers
System.Boolean	addAutoIncrementColumn	Defines whether to add an autoincrement column. Default: false
System.String	protectionDomainId	Set the protectionDomainId.

Remarks

• If addAutoIncrementColumn is true, the user table is created with a primary key identity column named "ID" at the first ordinal position
• columnHeaders elements with the value "ID" (case is neglected) are ignored

Examples

POST https://YourServerName/InfoShare/Json/UserTable/UserTableCreateTable

This example creates a user table with four columns.

{ 
 "connectionId": "5950defc-254f-4972-a5c2-04c2353b5f7f",
 "userTable": "UserTable_Test1",
 "columnHeaders": [
   "column1", "column2", "column3", "column4"
  ],
 "addAutoIncrementColumn": false
}

Response:

{}

Exceptions

Type	Condition
ServiceException	The connection id {connectionId} isn't valid or has expired (10008)
ServiceException	Verification code is needed: Verification code not yet verified (10152)
ServiceException	At least one column header must be supplied to create a user table (10183)
ServiceException	Table name '{userTable}' is invalid. Allowed characters are: {allowedCharacters} (10184)
ServiceException	Column header {columnHeader} is invalid. Allowed characters are: {allowedCharacters} (10185)
ServiceException	Table name '{userTable}' already exists (10215)
ServiceException	Column header '{columnName}' is more than once specified. Column headers in each table must be unique (10218)
ServiceException	Column header '{0}' is invalid because it is used as an internal column header (10235)
ServiceException	Not enough rights ({accessOperationName}, {accessOperationId}) (10071)