MEmetabase
/api/table

GET /api/table

Changed on

Get all Tables.

Optional filters:

  • can-query=true - filter to only tables the user can execute queries against
  • include-editable-data-model=true - filter to only tables the user can edit the data model of, instead of the tables the user can read
get/api/table

Request

  • Base URL
    (relative, and the document was published on a file host, not at the API’s origin)
  • Auth
    API key in header X-API-Key

Query parameters

visibility-typestring
termstring
data-layer'final' | 'internal' | 'hidden'
published-onlyboolean nullable

value must be a valid boolean string ('true' or 'false').

owner-emailstring
include-transform-targetsboolean nullable

value must be a valid boolean string ('true' or 'false').

owner-user-idinteger nullable
data-source'source-data' | 'transform' | 'unknown' | 'ingested' | 'metabase-transform' | 'upload'
include-editable-data-modelboolean nullable

value must be a valid boolean string ('true' or 'false').

orphan-onlyboolean nullable

value must be a valid boolean string ('true' or 'false').

can-queryboolean nullable

value must be a valid boolean string ('true' or 'false').

unused-onlyboolean nullable

value must be a valid boolean string ('true' or 'false').

Response

Successful response

Changes

  • 2e178f5a7934Revision changes
    • warning

      deleted the query request parameter can-write

    • info

      added the new optional query request parameter include-editable-data-model

    • info

      added the new optional query request parameter published-only

  • b1dc4ea67567Revision changes
    • info

      added the new optional query request parameter include-transform-targets