Method UserTableExportData

UserTableExportData(String, String, Boolean)

Exports the whole content from a user table

Declaration

List<List<string>> UserTableExportData(string connectionId, string userTable, bool addColumnHeaders)

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.Boolean	addColumnHeaders	Adds column headers as first row

Returns

Type	Description
System.Collections.Generic.List<System.Collections.Generic.List<System.String>>	All columns and rows of the defined table

Examples

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

This example exports all rows including the column headers from a user table.

{ 
 "connectionId": "35facddf-34ca-443e-9c85-cef9f6fa503f",
 "userTable": "UserTable_Test1",
 "addColumnHeaders": true
}

Response:

{
 "UserTableExportDataResult":
  [
   ["column1", "column2", "column3", "column4"],
   ["row1_col1", "row1_col2", "row1_col3", ""],
   ["row2_col1", "row2_col2", "", "row2_col4"],
   ["row3_col1", "row3_col2", "row3_col3", null]
  ]
}

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	Table name '{userTable}' is invalid. Allowed characters are: {allowedCharacters} (10184)
ServiceException	Table name '{userTable}' does not exist (10219)
ServiceException	Not enough rights ({accessOperationName}, {accessOperationId}) (10071)