Question

15.10.1. List of tables

GET management/tables

Table 214. List of tables - Response codes

Response code	Description
200	Indicates the request was successful.

Success response body:

[
   {
    "name":"ACT_RU_VARIABLE",
    "url":"http://localhost:8182/management/tables/ACT_RU_VARIABLE",
    "count":4528
   },
   {
    "name":"ACT_RU_EVENT_SUBSCR",
    "url":"http://localhost:8182/management/tables/ACT_RU_EVENT_SUBSCR",
    "count":3
   }

]

15.10.2. Get a single table

GET management/tables/{tableName}

Table 215. Get a single table - URL parameters

Parameter	Required	Value	Description
tableName	Yes	String	The name of the table to get.

Success response body:

{
    "name":"ACT_RE_PROCDEF",
    "url":"http://localhost:8182/management/tables/ACT_RE_PROCDEF",
    "count":60
}

Table 216. Get a single table - Response codes

Response code	Description
200	Indicates the table exists and the table count is returned.
404	Indicates the requested table does not exist.

15.10.3. Get column info for a single table

GET management/tables/{tableName}/columns

Table 217. Get column info for a single table - URL parameters

Parameter	Required	Value	Description
tableName	Yes	String	The name of the table to get.

Success response body:

{
   "tableName":"ACT_RU_VARIABLE",
   "columnNames":[
    "ID_",
    "REV_",
    "TYPE_",
    "NAME_"


   ],
   "columnTypes":[
    "VARCHAR",
    "INTEGER",
    "VARCHAR",
    "VARCHAR"


   ]
}

Table 218. Get column info for a single table - Response codes

Response code	Description
200	Indicates the table exists and the table column info is returned.
404	Indicates the requested table does not exist.

15.10.4. Get row data for a single table

GET management/tables/{tableName}/data

Table 219. Get row data for a single table - URL parameters

Parameter	Required	Value	Description
tableName	Yes	String	The name of the table to get.

Table 220. Get row data for a single table - URL query parameters

Parameter	Required	Value	Description
start	No	Integer	Index of the first row to fetch. Defaults to 0.
size	No	Integer	Number of rows to fetch, starting from start. Defaults to 10.
orderAscendingColumn	No	String	Name of the column to sort the resulting rows on, ascending.
orderDescendingColumn	No	String	Name of the column to sort the resulting rows on, descending.

Success response body:

{
  "total":3,
   "start":0,
   "sort":null,
   "order":null,
   "size":3,

   "data":[
    {
     "TASK_ID_":"2",
     "NAME_":"var1",
     "REV_":1,
     "TEXT_":"123",
     "LONG_":123,
     "ID_":"3",
     "TYPE_":"integer"
    }



   ]

}

Table 221. Get row data for a single table - Response codes

Response code	Description
200	Indicates the table exists and the table row data is returned.
404	Indicates the requested table does not exist.