Skip to main content
GET
/
v1
/
factTables
List FactTable
curl --request GET \
  --url https://metrics.eu.confidence.dev/v1/factTables \
  --header 'Authorization: Bearer <token>'
{
  "factTables": [
    {
      "sql": "<string>",
      "displayName": "<string>",
      "timestampColumn": {},
      "entities": [
        {}
      ],
      "state": {},
      "schemaValidationJob": "<string>",
      "createTime": {},
      "updateTime": {},
      "creator": "<string>",
      "updater": "<string>",
      "name": "<string>",
      "description": "<string>",
      "measures": [
        {}
      ],
      "partitionedUpdateStrategyState": {},
      "dimensions": [
        {}
      ],
      "error": {},
      "factDataDeliveredUntilTime": {},
      "dataDeliveredUntilUpdateStrategyConfig": {},
      "deleteTime": {},
      "labels": [
        {}
      ],
      "owner": "<string>",
      "systemCreated": true,
      "skipSqlPreview": true
    }
  ],
  "nextPageToken": "<string>"
}

Authorizations

Authorization
string
header
required

Bearer authentication header of the form Bearer <token>, where <token> is your auth token.

Query Parameters

pageSize
object

The maximum number of fact tables to fetch.

pageToken
string

Token used for pagination.

filter
string

Filtering for fact tables, follows the lucene query string format for example 'name: "factTables/abc"', see FactTable type for available fields.

showDeleted
boolean

If deleted fact tables should be included.

orderBy
string

Provide fields and direction to sort by. Will always tiebreak on name. Format: {"<"}field_0{">"}:{"<"}direction{">"}, {"<"}field_1{">"}:{"<"}direction{">"} Example: displayName:desc,createTime:asc

Response

200 - application/json

OK

factTables
object[]
required

List of matching fact tables.

nextPageToken
string

Token to fetch the next page, empty if no more pages.