Views

Generate View Table Data

Generate paginated table data for a view. This endpoint executes the view's query against transformations from the specified functions, applies the defined filters, and returns matching rows with their column values. The request includes the view configuration (columns, filters, function IDs), a time window to filter transformations by creation date, and optional pagination parameters (limit and offset). The response contains an array of rows, where each row contains column values extracted from a transformation, and the total count of matching rows (before pagination). Note: The functions field in the view configuration is required. At least one function ID or name must be specified.

POST
/v2/views/table-data
x-api-key<token>

Authenticate using API Key in request header

In: header

Request Body

application/json

TypeScript Definitions

Use the request body type in TypeScript.

Response Body

application/json

application/json

curl -X POST "https://api.bem.ai/v2/views/table-data" \  -H "Content-Type: application/json" \  -d '{    "name": "string",    "columns": [      {        "name": "string",        "valueSchemaPath": [          "string"        ],        "displayOrderIndex": 0      }    ],    "filters": [      {        "columnName": "string",        "filterType": "equals_string"      }    ],    "aggregations": [      {        "name": "string",        "function": "count"      }    ],    "functions": [      {}    ],    "timeWindow": {      "start": "2019-08-24T14:15:22Z",      "end": "2019-08-24T14:15:22Z"    }  }'
{
  "rows": [
    {
      "columns": [
        {
          "columnName": "string",
          "value": "string"
        }
      ],
      "transformationID": 0
    }
  ],
  "totalCount": 0
}
{
  "message": "string",
  "code": 0,
  "details": {}
}