table_info (get)
The command allows to retrieve the characteristics and properties of a specific table within the requested database. In addition to the characteristics of the table, all the fields that make it up with their characteristics will also be available.
Parameters
tablename
Name of the table to retrieve.
db
Name of the database to retrieve the table from.
token
User identification token.
Example
https://web.nios4.com/ws/?action=table_info&db=db&tablename=customer&token=00000000
Errors
notfound
The requested table does not exist
unauthorized
You do not have viewing permissions for the requested table
Reply
{
"error": false, Error identifier
"table": {
"gguid": "guid", Global id
"tid": "20190923135015", Time identifier
"eli": "0", If the table is deleted
"arc": "0", Archive index
"ut": "user", Last user
"ind": "0", Sorting index
"displayable": "1", Permission to view
"eliminable": "1", Permission to delete
"editable": "1", Permission to editing
"tablename": "customer", Actual name of the table
"syncyes": "1", Sync permission
"syncsel": "1", Selective sync permission
"syncno": "0", Optional sync permission
"param": {}", Table parameters
"tablelabel": "Customer", Table label
"newlabel":"New Customer", Label on new record
"expressions": "", Calculation expressions
"lgroup": "" Membership group
},
"fields": [
{
"gguid": "g", Global id field
"tid": "20190923135015", Time identifier
"eli": "0", If the field is deleted
"arc": "0", Archive index
"ut":"user", Last user
"ind": "1001", Sorting index
"displayable": "1", Permission to view
"eliminable": "1", Permission to delete
"editable": "1", Permission to editing
"tablename": "customer", Membership table
"fieldname": "name", Actual name of the field
"fieldlabel": "Name", Field label
"fieldtype": "11", Field type
"viewcolumn": "1", If the column is visible
"columnwidth": "200", Column width
"obligatory": "0", If the field is mandatory
"param": "{}", Field parameters
"ofsystem": "1", If the field is system
"expression": "{}", Field expressions (not used)
"style":"{}", Field style
"panel": "", Panel containing the field
"panelindex": "0", Panel index
"fieldlabel2": "C Name", Label on the column
"columnindex": "1" Column index
},...],
"record": { Reference template for the record
"gguid": "", usable in other calls
"tid": 0, to add and edit values
"eli": 0, in the table
"arc": 0,
"ut": "",
"ind": 0,
"exp": "",
"gguidp": "",
"uta": "",
"tap": "",
"dsp": "",
"dsc": "",
"dsq1": 0,
"dsq2": 0,
"utc": "",
"tidc": 0,
"name": "",
},
"archives": [ List of archives
{ available for the table
"gguid": "g",
"tid": "20200323110641",
"eli": "0",
"arc": "0",
"ut":"user",
"ind": "2",
"gguidp": "",
"exp": "",
"uta": "1050",
"tap": "",
"dsp": "",
"dsc": "",
"dsq1": "0",
"dsq2": "0",
"utc":"user",
"tidc": "20191023132749",
"tablename": "customer",
"arcindex": "2",
"archivename": "old"
}
],
"scripts": [ List of scripts associated
{ with the table
"gguid": "g",
"ind": 7,
"tablename": "customer",
"scriptname":"script",
"scripttype": 3
}
],
"preferences": [ Standard page layout
{ preferences
"NC": "ind",
"IN": 0,
"VS": 0,
"WD": 40,
"SO": 0
},...]
}