Table Data

POST https://api.supportbench.com/datatable/data

Return the Datatables associated to a company or contact. This will return all tables, and data including sub tables on child data items.

Main Datatable Object

Name	Description
id	The root table id that you can reference.
name	The name of the table
name_friendly	The display friendly name of the table.
description	The description of the table.
location	The location of the table which will either be "Company" or "Contact".
user_roles	List of user roles that are allowed to view the datatable.
customer_roles	List of customer user roles that this data table will be visible on.
data	Returns a list of data items and all related tables and their data of the root table.
active	The status of the table.
modifiedby	Who last modified the data table.
modified	When was this table last updated.
createdby	Who created the table.
created	When was the table created.

User and Customer Role Object

Name	Description
id	The id of the role.
name	The name of the role.

Main Table Data Object

Name	Description
items	A list of root data table items.

Items Object

Name	Description
id	A list of root data table items.
fields	A list of fields and their values related to the data table.
related_tables	A list of all related child data tables and their data items.

Field Object

Name	Description
field_id	The field id.
name	The name of the field.
value	The value of the field.

Related Table Object

Name	Description
table	A table object of all the table details.
items	A list of data items linked to the data table.