Card

/api/card endpoints.

Delete the publicly-accessible link to this Card.

PARAMS:

  • card-id

DELETE /api/card/:id

Delete a Card. (DEPRECATED – don’t delete a Card anymore – archive it instead.).

PARAMS:

  • id

GET /api/card/

Get all the Cards. Option filter param f can be used to change the set of Cards that are returned; default is all, but other options include mine, bookmarked, database, table, recent, popular, :using_model and archived. See corresponding implementation functions above for the specific behavior of each filter option. :card_index.

PARAMS:

  • f value may be nil, or if non-nil, value must be one of: all, archived, bookmarked, database, mine, popular, recent, table, using_model.

  • model_id value may be nil, or if non-nil, value must be an integer greater than zero.

GET /api/card/:card-id/params/:param-key/search/:query

Fetch possible values of the parameter whose ID is :param-key that contain :query.

;; fetch values for Card 1 parameter 'abc' that contain 'Orange';
 GET /api/card/1/params/abc/search/Orange

Currently limited to first 1000 results.

PARAMS:

  • card-id value must be an integer greater than zero.

  • param-key value must be a non-blank string.

  • query value must be a non-blank string.

GET /api/card/:card-id/params/:param-key/values

Fetch possible values of the parameter whose ID is :param-key.

;; fetch values for Card 1 parameter 'abc' that are possible
GET /api/card/1/params/abc/values.

PARAMS:

  • card-id value must be an integer greater than zero.

  • param-key value must be a non-blank string.

GET /api/card/:id

Get Card with ID.

PARAMS:

  • id

  • ignore_view

GET /api/card/:id/related

Return related entities.

PARAMS:

  • id

GET /api/card/:id/timelines

Get the timelines for card with ID. Looks up the collection the card is in and uses that.

PARAMS:

  • id

  • include value may be nil, or if non-nil, value must be one of: events.

  • start value may be nil, or if non-nil, value must be a valid date string

  • end value may be nil, or if non-nil, value must be a valid date string

GET /api/card/embeddable

Fetch a list of Cards where enable_embedding is true. The cards can be embedded using the embedding endpoints and a signed JWT.

GET /api/card/public

Fetch a list of Cards with public UUIDs. These cards are publicly-accessible if public sharing is enabled.

POST /api/card/

Create a new Card.

PARAMS:

  • visualization_settings value must be a map.

  • parameters value may be nil, or if non-nil, value must be an array. Each parameter must be a map with :id and :type keys

  • description value may be nil, or if non-nil, value must be a non-blank string.

  • collection_position value may be nil, or if non-nil, value must be an integer greater than zero.

  • result_metadata value may be nil, or if non-nil, value must be an array of valid results column metadata maps.

  • collection_id value may be nil, or if non-nil, value must be an integer greater than zero.

  • name value must be a non-blank string.

  • cache_ttl value may be nil, or if non-nil, value must be an integer greater than zero.

  • dataset_query value must be a map.

  • parameter_mappings value may be nil, or if non-nil, value must be an array. Each parameter_mapping must be a map with :parameter_id and :target keys

  • display value must be a non-blank string.

POST /api/card/:card-id/persist

Mark the model (card) as persisted. Runs the query and saves it to the database backing the card and hot swaps this query in place of the model’s query.

PARAMS:

  • card-id value must be an integer greater than zero.

POST /api/card/:card-id/public_link

Generate publicly-accessible links for this Card. Returns UUID to be used in public links. (If this Card has already been shared, it will return the existing public link rather than creating a new one.) Public sharing must be enabled.

PARAMS:

  • card-id

POST /api/card/:card-id/query

Run the query associated with a Card.

PARAMS:

  • card-id

  • parameters

  • ignore_cache value may be nil, or if non-nil, value must be a boolean.

  • dashboard_id value may be nil, or if non-nil, value must be an integer greater than zero.

  • collection_preview value may be nil, or if non-nil, value must be a boolean.

POST /api/card/:card-id/query/:export-format

Run the query associated with a Card, and return its results as a file in the specified format.

parameters should be passed as query parameter encoded as a serialized JSON string (this is because this endpoint is normally used to power ‘Download Results’ buttons that use HTML form actions).

PARAMS:

  • card-id

  • export-format value must be one of: api, csv, json, xlsx.

  • parameters value may be nil, or if non-nil, value must be a valid JSON string.

POST /api/card/:card-id/refresh

Refresh the persisted model caching card-id.

PARAMS:

  • card-id value must be an integer greater than zero.

POST /api/card/:card-id/unpersist

Unpersist this model. Deletes the persisted table backing the model and all queries after this will use the card’s query rather than the saved version of the query.

PARAMS:

  • card-id value must be an integer greater than zero.

POST /api/card/:id/copy

Copy a Card, with the new name ‘Copy of name’.

PARAMS:

  • id value may be nil, or if non-nil, value must be an integer greater than zero.

POST /api/card/collections

Bulk update endpoint for Card Collections. Move a set of Cards with CARD_IDS into a Collection with COLLECTION_ID, or remove them from any Collections by passing a null COLLECTION_ID.

PARAMS:

  • card_ids value must be an array. Each value must be an integer greater than zero.

  • collection_id value may be nil, or if non-nil, value must be an integer greater than zero.

POST /api/card/pivot/:card-id/query

Run the query associated with a Card.

PARAMS:

  • card-id

  • parameters

  • ignore_cache value may be nil, or if non-nil, value must be a boolean.

POST /api/card/related

Return related entities for an ad-hoc query.

PARAMS:

  • query

PUT /api/card/:id

Update a Card.

PARAMS:

  • collection_preview value may be nil, or if non-nil, value must be a boolean.

  • visualization_settings value may be nil, or if non-nil, value must be a map.

  • parameters value may be nil, or if non-nil, value must be an array. Each parameter must be a map with :id and :type keys

  • dataset value may be nil, or if non-nil, value must be a boolean.

  • description value may be nil, or if non-nil, value must be a string.

  • archived value may be nil, or if non-nil, value must be a boolean.

  • collection_position value may be nil, or if non-nil, value must be an integer greater than zero.

  • result_metadata value may be nil, or if non-nil, value must be an array of valid results column metadata maps.

  • enable_embedding value may be nil, or if non-nil, value must be a boolean.

  • collection_id value may be nil, or if non-nil, value must be an integer greater than zero.

  • card-updates

  • name value may be nil, or if non-nil, value must be a non-blank string.

  • embedding_params value may be nil, or if non-nil, value must be a valid embedding params map.

  • cache_ttl value may be nil, or if non-nil, value must be an integer greater than zero.

  • dataset_query value may be nil, or if non-nil, value must be a map.

  • id

  • display value may be nil, or if non-nil, value must be a non-blank string.


« Back to API index

Read docs for other versions of Metabase.

Thanks for your feedback!

See something that needs fixing? Propose a change.