Create table by selection

Method

POST

Path

/qrs/selection/{id}/[type]/table?filter={filter}&skip={skip}&take={take}&sortColumn={sortColumn}&orderAscending={orderAscending}

Description

Add a new table definition from the selection set identified by {id}.

Optionally, include an empty GUID in the API call. Optionally, filter the columns in the table.

Tables are used to list specific properties for entities.

The Name property must not include spaces.

Use [columnType] in the following way:

• When [columnType] is set to Property, the Definition property must contain the property name.
• When [columnType] is set to Function, the Definition property must contain the function that produces the column values. Initially, the supported functions only include count([type1], [type2],…).
• When [columnType] is set to List, the Definition property must contain the list item type and the list property must be specified as a list of columns.

Body

TableDefinition:

{
   "id": "00000000-0000-0000-0000-000000000000",
   "type": "...",
   "columns":
      [
         {
            "name": "...",
            "columnType": Property/Function/List,
            "definition": "[property name]/[function name]/[list item type]",
            "list":
               [
                  { <columns> }
               ]
         },
            ...
      ]
}

Return value

ITable:

{
   "id": "00000000-0000-0000-0000-000000000000",
   "type": "...",
   "columnNames":
      [
         "name1",
         "name2",
         ...
      ],
   "rows":
      [
         {
            [
               "item1.1",
               "item1.2",
               ...
            ]
         },
         {
            [
               "item2.1",
               "item2.2",
               ...
            ]
         },
         ...
      ]
}

Optional parameters

• {filter}: See Filtering.
• {skip}: See Table pagination.
• {take}: See Table pagination.
• {sortColumn}: See Table pagination.
• {orderAscending}: See Table pagination.