Get recent activity.
Get the list of 10 things the current user has been viewing most recently.
Delete an Alert. (DEPRECATED -- don't delete a Alert anymore -- archive it instead.)
id
Fetch all alerts
archivedvalue may be nil, or if non-nil, value must be a valid boolean string ('true' or 'false').
Fetch all questions for the given question (Card) id
id
Create a new Alert.
-
alert_conditionvalue must be one of:goal,rows. -
cardvalue must be a map with the keysid,include_csv, andinclude_xls. -
channelsvalue must be an array. Each value must be a map. The array cannot be empty. -
alert_first_onlyvalue must be a boolean. -
alert_above_goalvalue may be nil, or if non-nil, value must be a boolean. -
new-alert-request-body
Update a Alert with ID.
-
id -
alert_conditionvalue may be nil, or if non-nil, value must be one of:goal,rows. -
cardvalue may be nil, or if non-nil, value must be a map with the keysid,include_csv, andinclude_xls. -
channelsvalue may be nil, or if non-nil, value must be an array. Each value must be a map. The array cannot be empty. -
alert_first_onlyvalue may be nil, or if non-nil, value must be a boolean. -
alert_above_goalvalue may be nil, or if non-nil, value must be a boolean. -
archivedvalue may be nil, or if non-nil, value must be a boolean. -
alert-updates
Unsubscribes a user from the given alert
id
Return an automagic dashboard for entity entity with id ìd.
-
entityInvalid entity type -
entity-id-or-query -
showinvalid show value
Return an automagic dashboard analyzing cell in automagic dashboard for entity entity
defined by
query cell-querry.
-
entityInvalid entity type -
entity-id-or-query -
cell-queryvalue couldn't be parsed as base64 encoded JSON -
showinvalid show value
GET /api/automagic-dashboards/:entity/:entity-id-or-query/cell/:cell-query/compare/:comparison-entity/:comparison-entity-id-or-query
Return an automagic comparison dashboard for cell in automagic dashboard for entity entity
with id ìd defined by query cell-querry; compared with entity comparison-entity with id
comparison-entity-id-or-query..
-
entityInvalid entity type -
entity-id-or-query -
cell-queryvalue couldn't be parsed as base64 encoded JSON -
showinvalid show value -
comparison-entityInvalid comparison entity type. Can only be one of "table", "segment", or "adhoc" -
comparison-entity-id-or-query
Return an automagic dashboard analyzing cell in question with id id defined by
query cell-querry using rule rule.
-
entityInvalid entity type -
entity-id-or-query -
cell-queryvalue couldn't be parsed as base64 encoded JSON -
prefixinvalid value for prefix -
ruleinvalid value for rule name -
showinvalid show value
GET /api/automagic-dashboards/:entity/:entity-id-or-query/cell/:cell-query/rule/:prefix/:rule/compare/:comparison-entity/:comparison-entity-id-or-query
Return an automagic comparison dashboard for cell in automagic dashboard for entity entity
with id ìd defined by query cell-querry using rule rule; compared with entity
comparison-entity with id comparison-entity-id-or-query..
-
entityInvalid entity type -
entity-id-or-query -
cell-queryvalue couldn't be parsed as base64 encoded JSON -
prefixinvalid value for prefix -
ruleinvalid value for rule name -
showinvalid show value -
comparison-entityInvalid comparison entity type. Can only be one of "table", "segment", or "adhoc" -
comparison-entity-id-or-query
GET /api/automagic-dashboards/:entity/:entity-id-or-query/compare/:comparison-entity/:comparison-entity-id-or-query
Return an automagic comparison dashboard for entity entity with id ìd compared with entity
comparison-entity with id comparison-entity-id-or-query.
-
entityInvalid entity type -
entity-id-or-query -
showinvalid show value -
comparison-entityInvalid comparison entity type. Can only be one of "table", "segment", or "adhoc" -
comparison-entity-id-or-query
Return an automagic dashboard for entity entity with id ìd using rule rule.
-
entityInvalid entity type -
entity-id-or-query -
prefixinvalid value for prefix -
ruleinvalid value for rule name -
showinvalid show value
GET /api/automagic-dashboards/:entity/:entity-id-or-query/rule/:prefix/:rule/compare/:comparison-entity/:comparison-entity-id-or-query
Return an automagic comparison dashboard for entity entity with id ìd using rule rule;
compared with entity comparison-entity with id comparison-entity-id-or-query..
-
entityInvalid entity type -
entity-id-or-query -
prefixinvalid value for prefix -
ruleinvalid value for rule name -
showinvalid show value -
comparison-entityInvalid comparison entity type. Can only be one of "table", "segment", or "adhoc" -
comparison-entity-id-or-query
Return a list of candidates for automagic dashboards orderd by interestingness.
id
Unfavorite a Card.
card-id
Delete the publicly-accessible link to this Card.
You must be a superuser to do this.
card-id
Delete a Card. (DEPRECATED -- don't delete a Card anymore -- archive it instead.)
id
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, fav, database, table, recent, popular, and archived. See
corresponding implementation functions above for the specific behavior of each filter option. 📇
-
fvalue may be nil, or if non-nil, value must be one of:all,archived,database,fav,mine,popular,recent,table. -
model_idvalue may be nil, or if non-nil, value must be an integer greater than zero.
Get Card with ID.
id
Return related entities.
id
Fetch a list of Cards where enable_embedding is true. The cards can be embedded using the embedding endpoints
and a signed JWT.
You must be a superuser to do this.
Fetch a list of Cards with public UUIDs. These cards are publicly-accessible if public sharing is enabled.
You must be a superuser to do this.
Create a new Card.
-
visualization_settingsvalue must be a map. -
descriptionvalue may be nil, or if non-nil, value must be a non-blank string. -
collection_positionvalue may be nil, or if non-nil, value must be an integer greater than zero. -
result_metadatavalue may be nil, or if non-nil, value must be an array of valid results column metadata maps. -
metadata_checksumvalue may be nil, or if non-nil, value must be a non-blank string. -
collection_idvalue may be nil, or if non-nil, value must be an integer greater than zero. -
namevalue must be a non-blank string. -
dataset_query -
displayvalue must be a non-blank string.
Favorite a Card.
card-id
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.
You must be a superuser to do this.
card-id
Run the query associated with a Card.
-
card-id -
parameters -
ignore_cachevalue may be nil, or if non-nil, value must be a boolean.
Run the query associated with a Card, and return its results as a file in the specified format. Note that this expects the parameters as serialized JSON in the 'parameters' parameter
-
card-id -
export-formatvalue must be one of:csv,json,xlsx. -
parametersvalue may be nil, or if non-nil, value must be a valid JSON string. -
respond -
raise
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.
-
card_idsvalue must be an array. Each value must be an integer greater than zero. -
collection_idvalue may be nil, or if non-nil, value must be an integer greater than zero.
Return related entities for an ad-hoc query.
query
Update a Card.
-
visualization_settingsvalue may be nil, or if non-nil, value must be a map. -
descriptionvalue may be nil, or if non-nil, value must be a string. -
archivedvalue may be nil, or if non-nil, value must be a boolean. -
collection_positionvalue may be nil, or if non-nil, value must be an integer greater than zero. -
result_metadatavalue may be nil, or if non-nil, value must be an array of valid results column metadata maps. -
metadata_checksumvalue may be nil, or if non-nil, value must be a non-blank string. -
enable_embeddingvalue may be nil, or if non-nil, value must be a boolean. -
collection_idvalue may be nil, or if non-nil, value must be an integer greater than zero. -
card-updates -
namevalue may be nil, or if non-nil, value must be a non-blank string. -
embedding_paramsvalue may be nil, or if non-nil, value must be a valid embedding params map. -
dataset_queryvalue may be nil, or if non-nil, value must be a map. -
id -
displayvalue may be nil, or if non-nil, value must be a non-blank string.
Fetch a list of all Collections that the current user has read permissions for (:can_write is returned as an
additional property of each Collection so you can tell which of these you have write permissions for.)
By default, this returns non-archived Collections, but instead you can show archived ones by passing
?archived=true.
archivedvalue may be nil, or if non-nil, value must be a valid boolean string ('true' or 'false').
Fetch a specific Collection with standard details added
id
Fetch a specific Collection's items with the following options:
model- only include objects of a specificmodel. If unspecified, returns objects of all modelsarchived- whentrue, return archived objects instead of unarchived ones. Defaults tofalse.
-
id -
modelvalue may be nil, or if non-nil, value must be one of:card,collection,dashboard,pulse. -
archivedvalue may be nil, or if non-nil, value must be a valid boolean string ('true' or 'false').
Fetch a graph of all Collection Permissions.
You must be a superuser to do this.
Return the 'Root' Collection object with standard details added
Fetch objects that the current user should see at their root level. As mentioned elsewhere, the 'Root' Collection
doesn't actually exist as a row in the application DB: it's simply a virtual Collection where things with no
collection_id exist. It does, however, have its own set of Permissions.
This endpoint will actually show objects with no collection_id for Users that have Root Collection
permissions, but for people without Root Collection perms, we'll just show the objects that have an effective
location of /.
This endpoint is intended to power a 'Root Folder View' for the Current User, so regardless you'll see all the top-level objects you're allowed to access.
-
modelvalue may be nil, or if non-nil, value must be one of:card,collection,dashboard,pulse. -
archivedvalue may be nil, or if non-nil, value must be a valid boolean string ('true' or 'false').
Create a new Collection.
-
namevalue must be a non-blank string. -
colorvalue must be a string that matches the regex^#[0-9A-Fa-f]{6}$. -
descriptionvalue may be nil, or if non-nil, value must be a non-blank string. -
parent_idvalue may be nil, or if non-nil, value must be an integer greater than zero.
Modify an existing Collection, including archiving or unarchiving it, or moving it.
-
id -
namevalue may be nil, or if non-nil, value must be a non-blank string. -
colorvalue may be nil, or if non-nil, value must be a string that matches the regex^#[0-9A-Fa-f]{6}$. -
descriptionvalue may be nil, or if non-nil, value must be a non-blank string. -
archivedvalue may be nil, or if non-nil, value must be a boolean. -
parent_idvalue may be nil, or if non-nil, value must be an integer greater than zero. -
collection-updates
Do a batch update of Collections Permissions by passing in a modified graph.
You must be a superuser to do this.
bodyvalue must be a map.
Delete the publicly-accessible link to this Dashboard.
You must be a superuser to do this.
dashboard-id
Delete a Dashboard.
id
Remove a DashboardCard from a Dashboard.
-
id -
dashcardIdvalue must be a valid integer greater than zero.
Unfavorite a Dashboard.
id
Get Dashboards. With filter option f (default all), restrict results as follows:
all- Return all Dashboards.mine- Return Dashboards created by the current user.archived- Return Dashboards that have been archived. (By default, these are excluded.)
fvalue may be nil, or if non-nil, value must be one of:all,archived,mine.
Get Dashboard with id.
id
Return related entities.
id
Fetch Revisions for Dashboard with id.
id
Fetch a list of Dashboards where enable_embedding is true. The dashboards can be embedded using the embedding
endpoints and a signed JWT.
You must be a superuser to do this.
Fetch a list of Dashboards with public UUIDs. These dashboards are publicly-accessible if public sharing is enabled.
You must be a superuser to do this.
Create a new Dashboard.
-
namevalue must be a non-blank string. -
descriptionvalue may be nil, or if non-nil, value must be a string. -
parametersvalue must be an array. Each value must be a map. -
collection_idvalue may be nil, or if non-nil, value must be an integer greater than zero. -
collection_positionvalue may be nil, or if non-nil, value must be an integer greater than zero. -
dashboard
Generate publicly-accessible links for this Dashboard. Returns UUID to be used in public links. (If this Dashboard has already been shared, it will return the existing public link rather than creating a new one.) Public sharing must be enabled.
You must be a superuser to do this.
dashboard-id
Copy a Dashboard.
-
from-dashboard-id -
namevalue may be nil, or if non-nil, value must be a non-blank string. -
descriptionvalue may be nil, or if non-nil, value must be a string. -
collection_idvalue may be nil, or if non-nil, value must be an integer greater than zero. -
collection_positionvalue may be nil, or if non-nil, value must be an integer greater than zero. -
dashboard
Add a Card to a Dashboard.
-
id -
cardIdvalue may be nil, or if non-nil, value must be an integer greater than zero. -
parameter_mappingsvalue must be an array. Each value must be a map. -
series -
dashboard-card
Favorite a Dashboard.
id
Revert a Dashboard to a prior Revision.
-
id -
revision_idvalue must be an integer greater than zero.
Save a denormalized description of dashboard.
dashboard
Save a denormalized description of dashboard into collection with ID :parent-collection-id.
-
parent-collection-id -
dashboard
Update a Dashboard.
Usually, you just need write permissions for this Dashboard to do this (which means you have appropriate
permissions for the Cards belonging to this Dashboard), but to change the value of enable_embedding you must be a
superuser.
-
parametersvalue may be nil, or if non-nil, value must be an array. Each value must be a map. -
points_of_interestvalue may be nil, or if non-nil, value must be a string. -
descriptionvalue may be nil, or if non-nil, value must be a string. -
archivedvalue may be nil, or if non-nil, value must be a boolean. -
collection_positionvalue may be nil, or if non-nil, value must be an integer greater than zero. -
show_in_getting_startedvalue may be nil, or if non-nil, value must be a boolean. -
enable_embeddingvalue may be nil, or if non-nil, value must be a boolean. -
collection_idvalue may be nil, or if non-nil, value must be an integer greater than zero. -
dash-updates -
namevalue may be nil, or if non-nil, value must be a non-blank string. -
caveatsvalue may be nil, or if non-nil, value must be a string. -
embedding_paramsvalue may be nil, or if non-nil, value must be a valid embedding params map. -
id -
positionvalue may be nil, or if non-nil, value must be an integer greater than zero.
Update Cards on a Dashboard. Request body should have the form:
{:cards [{:id ...
:sizeX ...
:sizeY ...
:row ...
:col ...
:series [{:id 123
...}]} ...]}
-
id -
cards
Delete a Database.
id
Fetch all Databases. include_tables means we should hydrate the Tables belonging to each DB. include_cards here
means we should also include virtual Table entries for saved Questions, e.g. so we can easily use them as source
Tables in queries. Default for both is false.
-
include_tablesvalue may be nil, or if non-nil, value must be a valid boolean string ('true' or 'false'). -
include_cardsvalue may be nil, or if non-nil, value must be a valid boolean string ('true' or 'false').
Get Database with ID.
id
Return a list of autocomplete suggestions for a given PREFIX.
This is intened for use with the ACE Editor when the User is typing raw SQL.
Suggestions include matching Tables and Fields in this Database.
Tables are returned in the format [table_name "Table"];
Fields are returned in the format [field_name "table_name base_type special_type"]
-
id -
prefixvalue must be a non-blank string.
Get a list of all Fields in Database.
id
Get a list of all primary key Fields for Database.
id
Get metadata about a Database, including all of its Tables and Fields.
Returns DB, fields, and field values.
id
Returns a list of tables for the given database id and schema
-
id -
schema
Returns a list of all the schemas found for the database id
id
Endpoint that provides metadata for the Saved Questions 'virtual' database. Used for fooling the frontend and allowing it to treat the Saved Questions virtual DB just like any other database.
Add a new Database.
You must be a superuser to do this.
-
namevalue must be a non-blank string. -
enginevalue must be a valid database engine. -
detailsvalue must be a map. -
is_full_syncvalue may be nil, or if non-nil, value must be a boolean. -
is_on_demandvalue may be nil, or if non-nil, value must be a boolean. -
schedulesvalue may be nil, or if non-nil, value must be a valid map of schedule maps for a DB.
Discards all saved field values for this Database.
You must be a superuser to do this.
id
Trigger a manual scan of the field values for this Database.
You must be a superuser to do this.
id
Update the metadata for this Database. This happens asynchronously.
id
Trigger a manual update of the schema metadata for this Database.
You must be a superuser to do this.
id
Add the sample dataset as a new Database.
You must be a superuser to do this.
Validate that we can connect to a database given a set of details.
You must be a superuser to do this.
-
enginevalue must be a valid database engine. -
detailsvalue must be a map.
Update a Database.
You must be a superuser to do this.
-
enginevalue may be nil, or if non-nil, value must be a valid database engine. -
schedulesvalue may be nil, or if non-nil, value must be a valid map of schedule maps for a DB. -
points_of_interestvalue may be nil, or if non-nil, value must be a string. -
descriptionvalue may be nil, or if non-nil, value must be a string. -
namevalue may be nil, or if non-nil, value must be a non-blank string. -
caveatsvalue may be nil, or if non-nil, value must be a string. -
is_full_sync -
detailsvalue may be nil, or if non-nil, value must be a map. -
id -
is_on_demand
Execute a query and retrieve the results in the usual format.
-
databasevalue must be an integer. -
query
Execute a query and download the result data as a file in the specified format.
-
export-formatvalue must be one of:csv,json,xlsx. -
queryvalue must be a valid JSON string. -
respond -
raise
Get historical query execution duration.
-
database -
query
Clear all email related settings. You must be a superuser to ddo this
You must be a superuser to do this.
Send a test email. You must be a superuser to do this.
You must be a superuser to do this.
Update multiple email Settings. You must be a superuser to do this.
You must be a superuser to do this.
settingsvalue must be a map.
Fetch a Card via a JSON Web Token signed with the embedding-secret-key.
Token should have the following format:
{:resource {:question <card-id>}}
token
Fetch remapped Field values. This is the same as GET /api/field/:id/remapping/:remapped-id, but for use with
embedded Cards.
-
token -
field-id -
remapped-id -
valuevalue must be a non-blank string.
Search for values of a Field that is referenced by an embedded Card.
-
token -
field-id -
search-field-id -
valuevalue must be a non-blank string. -
limitvalue may be nil, or if non-nil, value must be a valid integer greater than zero.
Fetch FieldValues for a Field that is referenced by an embedded Card.
-
token -
field-id
Fetch the results of running a Card using a JSON Web Token signed with the embedding-secret-key.
Token should have the following format:
{:resource {:question <card-id>}
:params <parameters>}
-
token -
& -
query-params
Like GET /api/embed/card/query, but returns the results as a file in the specified format.
-
token -
export-formatvalue must be one of:csv,json,xlsx. -
query-params -
respond -
raise
Fetch a Dashboard via a JSON Web Token signed with the embedding-secret-key.
Token should have the following format:
{:resource {:dashboard <dashboard-id>}}
token
Fetch the results of running a Card belonging to a Dashboard using a JSON Web Token signed with the
embedding-secret-key
-
token -
dashcard-id -
card-id -
& -
query-params
Fetch the results of running a Card belonging to a Dashboard using a JSON Web Token signed with the
embedding-secret-key return the data in one of the export formats
-
token -
export-formatvalue must be one of:csv,json,xlsx. -
dashcard-id -
card-id -
query-params -
respond -
raise
Fetch remapped Field values. This is the same as GET /api/field/:id/remapping/:remapped-id, but for use with
embedded Dashboards.
-
token -
field-id -
remapped-id -
valuevalue must be a non-blank string.
Search for values of a Field that is referenced by a Card in an embedded Dashboard.
-
token -
field-id -
search-field-id -
valuevalue must be a non-blank string. -
limitvalue may be nil, or if non-nil, value must be a valid integer greater than zero.
Fetch FieldValues for a Field that is used as a param in an embedded Dashboard.
-
token -
field-id
Remove the dimension associated to field at ID
id
Get Field with ID.
id
Return related entities.
id
Fetch remapped Field values.
-
id -
remapped-id -
value
Search for values of a Field with search-id that start with value. See docstring for
metabase.api.field/search-values for a more detailed explanation.
-
id -
search-id -
valuevalue must be a non-blank string. -
limitvalue may be nil, or if non-nil, value must be a valid integer greater than zero.
Get the count and distinct count of Field with ID.
id
If a Field's value of has_field_values is list, return a list of all the distinct values of the Field, and (if
defined by a User) a map of human-readable remapped values.
id
Implementation of the field values endpoint for fields in the Saved Questions 'virtual' DB. This endpoint is just a convenience to simplify the frontend code. It just returns the standard 'empty' field values response.
_
Sets the dimension for the given field at ID
-
id -
typevalue must be one of:external,internal. -
namevalue must be a non-blank string. -
human_readable_field_idvalue may be nil, or if non-nil, value must be an integer greater than zero.
Discard the FieldValues belonging to this Field. Only applies to fields that have FieldValues. If this Field's Database is set up to automatically sync FieldValues, they will be recreated during the next cycle.
You must be a superuser to do this.
id
Manually trigger an update for the FieldValues for this Field. Only applies to Fields that are eligible for FieldValues.
You must be a superuser to do this.
id
Update the fields values and human-readable values for a Field whose special type is
category/city/state/country or whose base type is type/Boolean. The human-readable values are optional.
-
id -
value-pairsvalue must be an array. Each value must be an array.
Update Field with ID.
-
visibility_typevalue may be nil, or if non-nil, value must be one of:details-only,hidden,normal,retired,sensitive. -
display_namevalue may be nil, or if non-nil, value must be a non-blank string. -
points_of_interestvalue may be nil, or if non-nil, value must be a non-blank string. -
descriptionvalue may be nil, or if non-nil, value must be a non-blank string. -
special_typevalue may be nil, or if non-nil, value must be a valid field type. -
has_field_valuesvalue may be nil, or if non-nil, value must be one of:auto-list,list,none,search. -
settingsvalue may be nil, or if non-nil, value must be a map. -
caveatsvalue may be nil, or if non-nil, value must be a non-blank string. -
fk_target_field_idvalue may be nil, or if non-nil, value must be an integer greater than zero. -
id
Fetch a custom GeoJSON file as defined in the custom-geojson setting. (This just acts as a simple proxy for the
file specified for KEY).
keyvalue must be a non-blank string.
Update LDAP related settings. You must be a superuser to do this.
You must be a superuser to do this.
settingsvalue must be a map.
Archive a Metric. (DEPRECATED -- Just pass updated value of :archived to the PUT endpoint instead.)
-
id -
revision_messagevalue must be a non-blank string.
Fetch all Metrics.
id
Fetch Metric with ID.
id
Return related entities.
id
Fetch Revisions for Metric with ID.
id
Create a new Metric.
-
namevalue must be a non-blank string. -
descriptionvalue may be nil, or if non-nil, value must be a string. -
table_idvalue must be an integer greater than zero. -
definitionvalue must be a map.
Revert a Metric to a prior Revision.
-
id -
revision_idvalue must be an integer greater than zero.
Update a Metric with ID.
-
points_of_interestvalue may be nil, or if non-nil, value must be a string. -
descriptionvalue may be nil, or if non-nil, value must be a string. -
archivedvalue may be nil, or if non-nil, value must be a boolean. -
definitionvalue may be nil, or if non-nil, value must be a map. -
revision_messagevalue must be a non-blank string. -
show_in_getting_startedvalue may be nil, or if non-nil, value must be a boolean. -
namevalue may be nil, or if non-nil, value must be a non-blank string. -
caveatsvalue may be nil, or if non-nil, value must be a string. -
id -
how_is_this_calculatedvalue may be nil, or if non-nil, value must be a string.
Update the important Fields for a Metric with ID.
(This is used for the Getting Started guide).
You must be a superuser to do this.
-
id -
important_field_idsvalue must be an array. Each value must be an integer greater than zero.
Notification about a potential schema change to one of our Databases.
Caller can optionally specify a :table_id or :table_name in the body to limit updates to a single Table.
-
id -
table_id -
table_name
Delete a specific PermissionsGroup.
You must be a superuser to do this.
group-id
Remove a User from a PermissionsGroup (delete their membership).
You must be a superuser to do this.
id
Fetch a graph of all Permissions.
You must be a superuser to do this.
Fetch all PermissionsGroups, including a count of the number of :members in that group.
You must be a superuser to do this.
Fetch the details for a certain permissions group.
You must be a superuser to do this.
id
Fetch a map describing the group memberships of various users. This map's format is:
{<user-id> [{:membership_id <id>
:group_id <id>}]}
You must be a superuser to do this.
Create a new PermissionsGroup.
You must be a superuser to do this.
namevalue must be a non-blank string.
Add a User to a PermissionsGroup. Returns updated list of members belonging to the group.
You must be a superuser to do this.
-
group_idvalue must be an integer greater than zero. -
user_idvalue must be an integer greater than zero.
Do a batch update of Permissions by passing in a modified graph. This should return the same graph, in the same
format, that you got from GET /api/permissions/graph, with any changes made in the wherever necessary. This
modified graph must correspond to the PermissionsGraph schema. If successful, this endpoint returns the updated
permissions graph; use this as a base for any further modifications.
Revisions to the permissions graph are tracked. If you fetch the permissions graph and some other third-party modifies it before you can submit you revisions, the endpoint will instead make no changes and return a 409 (Conflict) response. In this case, you should fetch the updated graph and make desired changes to that.
You must be a superuser to do this.
bodyvalue must be a map.
Update the name of a PermissionsGroup.
You must be a superuser to do this.
-
group-id -
namevalue must be a non-blank string.
Fetch a Card you're considering embedding by passing a JWT TOKEN.
token
Fetch the query results for a Card you're considering embedding by passing a JWT TOKEN.
-
token -
& -
query-params
Fetch a Dashboard you're considering embedding by passing a JWT TOKEN.
token
Fetch the results of running a Card belonging to a Dashboard you're considering embedding with JWT TOKEN.
-
token -
dashcard-id -
card-id -
& -
query-params
Fetch a publicly-accessible Card an return query results as well as :card information. Does not require auth
credentials. Public sharing must be enabled.
uuid
Fetch remapped Field values. This is the same as GET /api/field/:id/remapping/:remapped-id, but for use with public
Cards.
-
uuid -
field-id -
remapped-id -
valuevalue must be a non-blank string.
Search for values of a Field that is referenced by a public Card.
-
uuid -
field-id -
search-field-id -
valuevalue must be a non-blank string. -
limitvalue may be nil, or if non-nil, value must be a valid integer greater than zero.
Fetch FieldValues for a Field that is referenced by a public Card.
-
uuid -
field-id
Fetch a publicly-accessible Card an return query results as well as :card information. Does not require auth
credentials. Public sharing must be enabled.
-
uuid -
parametersvalue may be nil, or if non-nil, value must be a valid JSON string.
Fetch a publicly-accessible Card and return query results in the specified format. Does not require auth credentials. Public sharing must be enabled.
-
uuid -
export-formatvalue must be one of:csv,json,xlsx. -
parametersvalue may be nil, or if non-nil, value must be a valid JSON string. -
respond -
raise
Fetch a publicly-accessible Dashboard. Does not require auth credentials. Public sharing must be enabled.
uuid
Fetch the results for a Card in a publicly-accessible Dashboard. Does not require auth credentials. Public sharing must be enabled.
-
uuid -
card-id -
parametersvalue may be nil, or if non-nil, value must be a valid JSON string.
Fetch remapped Field values. This is the same as GET /api/field/:id/remapping/:remapped-id, but for use with public
Dashboards.
-
uuid -
field-id -
remapped-id -
valuevalue must be a non-blank string.
Search for values of a Field that is referenced by a Card in a public Dashboard.
-
uuid -
field-id -
search-field-id -
valuevalue must be a non-blank string. -
limitvalue may be nil, or if non-nil, value must be a valid integer greater than zero.
Fetch FieldValues for a Field that is referenced by a Card in a public Dashboard.
-
uuid -
field-id
oEmbed endpoint used to retreive embed code and metadata for a (public) Metabase URL.
-
urlvalue must be a non-blank string. -
formatvalue may be nil, or if non-nil, value must be one of:json. -
maxheightvalue may be nil, or if non-nil, value must be a valid integer. -
maxwidthvalue may be nil, or if non-nil, value must be a valid integer.
Delete a Pulse. (DEPRECATED -- don't delete a Pulse anymore -- archive it instead.)
id
Fetch all Pulses
archivedvalue may be nil, or if non-nil, value must be a valid boolean string ('true' or 'false').
Fetch Pulse with ID.
id
Provides relevant configuration information and user choices for creating/updating Pulses.
Get HTML rendering of a Card with id.
id
Get JSON object containing HTML rendering of a Card with id and other information.
id
Get PNG rendering of a Card with id.
id
Create a new Pulse.
-
namevalue must be a non-blank string. -
cardsvalue must be an array. Each value must satisfy one of the following requirements: 1) value must be a map with the following keys(collection_id, description, display, id, include_csv, include_xls, name)2) value must be a map with the keysid,include_csv, andinclude_xls. The array cannot be empty. -
channelsvalue must be an array. Each value must be a map. The array cannot be empty. -
skip_if_emptyvalue may be nil, or if non-nil, value must be a boolean. -
collection_idvalue may be nil, or if non-nil, value must be an integer greater than zero. -
collection_positionvalue may be nil, or if non-nil, value must be an integer greater than zero.
Test send an unsaved pulse.
-
namevalue must be a non-blank string. -
cardsvalue must be an array. Each value must satisfy one of the following requirements: 1) value must be a map with the following keys(collection_id, description, display, id, include_csv, include_xls, name)2) value must be a map with the keysid,include_csv, andinclude_xls. The array cannot be empty. -
channelsvalue must be an array. Each value must be a map. The array cannot be empty. -
skip_if_emptyvalue may be nil, or if non-nil, value must be a boolean. -
collection_idvalue may be nil, or if non-nil, value must be an integer greater than zero. -
collection_positionvalue may be nil, or if non-nil, value must be an integer greater than zero.
Update a Pulse with id.
-
id -
namevalue may be nil, or if non-nil, value must be a non-blank string. -
cardsvalue may be nil, or if non-nil, value must be an array. Each value must satisfy one of the following requirements: 1) value must be a map with the following keys(collection_id, description, display, id, include_csv, include_xls, name)2) value must be a map with the keysid,include_csv, andinclude_xls. The array cannot be empty. -
channelsvalue may be nil, or if non-nil, value must be an array. Each value must be a map. The array cannot be empty. -
skip_if_emptyvalue may be nil, or if non-nil, value must be a boolean. -
collection_idvalue may be nil, or if non-nil, value must be an integer greater than zero. -
archivedvalue may be nil, or if non-nil, value must be a boolean. -
pulse-updates
Get revisions of an object.
-
entityvalue must be one of:card,dashboard. -
idvalue must be an integer.
Revert an object to a prior revision.
-
entityvalue must be one of:card,dashboard. -
idvalue must be an integer. -
revision_idvalue must be an integer.
Search Cards, Dashboards, Collections and Pulses for the substring q.
-
qvalue may be nil, or if non-nil, value must be a non-blank string. -
archivedvalue may be nil, or if non-nil, value must be a valid boolean string ('true' or 'false').
Archive a Segment. (DEPRECATED -- Just pass updated value of :archived to the PUT endpoint instead.)
-
id -
revision_messagevalue must be a non-blank string.
Fetch all Segments.
Fetch Segment with ID.
id
Return related entities.
id
Fetch Revisions for Segment with ID.
id
Create a new Segment.
-
namevalue must be a non-blank string. -
descriptionvalue may be nil, or if non-nil, value must be a string. -
table_idvalue must be an integer greater than zero. -
definitionvalue must be a map.
Revert a Segement to a prior Revision.
-
id -
revision_idvalue must be an integer greater than zero.
Update a Segment with ID.
-
points_of_interestvalue may be nil, or if non-nil, value must be a string. -
descriptionvalue may be nil, or if non-nil, value must be a string. -
archivedvalue may be nil, or if non-nil, value must be a boolean. -
definitionvalue may be nil, or if non-nil, value must be a map. -
revision_messagevalue must be a non-blank string. -
show_in_getting_startedvalue may be nil, or if non-nil, value must be a boolean. -
namevalue may be nil, or if non-nil, value must be a non-blank string. -
caveatsvalue may be nil, or if non-nil, value must be a string. -
id
Logout.
metabase-session-id
Check is a password reset token is valid and isn't expired.
tokenvalue must be a string.
Get all global properties and their values. These are the specific Settings which are meant to be public.
Login.
-
usernamevalue must be a non-blank string. -
passwordvalue must be a non-blank string. -
remote-address -
request
Send a reset email when user has forgotten their password.
-
server-name -
emailvalue must be a valid email address. -
remote-address
Login with Google Auth.
-
tokenvalue must be a non-blank string. -
remote-address -
request
Reset password with a reset token.
-
tokenvalue must be a non-blank string. -
passwordInsufficient password strength -
request
Get all Settings and their values. You must be a superuser to do this.
You must be a superuser to do this.
Fetch a single Setting. You must be a superuser to do this.
You must be a superuser to do this.
keyvalue must be a non-blank string.
Update multiple Settings values. You must be a superuser to do this.
You must be a superuser to do this.
settings
Create/update a Setting. You must be a superuser to do this.
This endpoint can also be used to delete Settings by passing nil for :value.
You must be a superuser to do this.
-
keyvalue must be a non-blank string. -
value
Return various "admin checklist" steps and whether they've been completed. You must be a superuser to see this!
You must be a superuser to do this.
Special endpoint for creating the first user during setup. This endpoint both creates the user AND logs them in and returns a session ID.
-
engine -
schedulesvalue may be nil, or if non-nil, value must be a valid map of schedule maps for a DB. -
allow_trackingvalue may be nil, or if non-nil, value must satisfy one of the following requirements: 1) value must be a boolean. 2) value must be a valid boolean string ('true' or 'false'). -
emailvalue must be a valid email address. -
first_namevalue must be a non-blank string. -
request -
passwordInsufficient password strength -
name -
is_full_sync -
site_namevalue must be a non-blank string. -
tokenToken does not match the setup token. -
details -
is_on_demand -
last_namevalue must be a non-blank string.
Validate that we can connect to a database given a set of details.
-
enginevalue must be a valid database engine. -
details -
tokenToken does not match the setup token.
Update Slack related settings. You must be a superuser to do this.
You must be a superuser to do this.
-
slack-tokenvalue may be nil, or if non-nil, value must be a non-blank string. -
metabot-enabledvalue must be a boolean. -
slack-settings
Get all Tables.
Get Table with ID.
id
Get all foreign keys whose destination is a Field that belongs to this Table.
id
Get metadata about a Table useful for running queries.
Returns DB, fields, field FKs, and field values.
By passing include_sensitive_fields=true, information about sensitive Fields will be returned; in no case will
any of its corresponding values be returned. (This option is provided for use in the Admin Edit Metadata page).
-
id -
include_sensitive_fieldsvalue may be nil, or if non-nil, value must be a valid boolean string ('true' or 'false').
Return related entities.
id
Return FK info for the 'virtual' table for a Card. This is always empty, so this endpoint serves mainly as a placeholder to avoid having to change anything on the frontend.
Return metadata for the 'virtual' table for a Card.
id
Discard the FieldValues belonging to the Fields in this Table. Only applies to fields that have FieldValues. If this Table's Database is set up to automatically sync FieldValues, they will be recreated during the next cycle.
You must be a superuser to do this.
id
Manually trigger an update for the FieldValues for the Fields belonging to this Table. Only applies to Fields that are eligible for FieldValues.
You must be a superuser to do this.
id
Update Table with ID.
-
id -
display_namevalue may be nil, or if non-nil, value must be a non-blank string. -
entity_typevalue may be nil, or if non-nil, value must be a valid entity type (keyword or string). -
visibility_typevalue may be nil, or if non-nil, value must be one of:cruft,hidden,technical. -
descriptionvalue may be nil, or if non-nil, value must be a non-blank string. -
caveatsvalue may be nil, or if non-nil, value must be a non-blank string. -
points_of_interestvalue may be nil, or if non-nil, value must be a non-blank string. -
show_in_getting_startedvalue may be nil, or if non-nil, value must be a boolean.
Fetch a list of recent tasks stored as Task History
You must be a superuser to do this.
-
limitvalue may be nil, or if non-nil, value must be a valid integer greater than zero. -
offsetvalue may be nil, or if non-nil, value must be a valid integer greater than or equal to zero.
Get TaskHistory entry with ID.
id
Return raw data about all scheduled tasks (i.e., Quartz Jobs and Triggers).
You must be a superuser to do this.
This endpoints provides an image with the appropriate pins rendered given a MBQL QUERY (passed as a GET query string param). We evaluate the query and find the set of lat/lon pairs which are relevant and then render the appropriate ones. It's expected that to render a full map view several calls will be made to this endpoint in parallel.
-
zoomvalue must be a valid integer. -
xvalue must be a valid integer. -
yvalue must be a valid integer. -
lat-field-idvalue must be an integer greater than zero. -
lon-field-idvalue must be an integer greater than zero. -
lat-col-idxvalue must be a valid integer. -
lon-col-idxvalue must be a valid integer. -
queryvalue must be a valid JSON string.
Disable a User. This does not remove the User from the DB, but instead disables their account.
You must be a superuser to do this.
id
Fetch a list of Users for the admin People page or for Pulses. By default returns only active users. If
include_deactivated is true, return all Users (active and inactive). (Using include_deactivated requires
superuser permissions.)
include_deactivatedvalue may be nil, or if non-nil, value must be a valid boolean string ('true' or 'false').
Fetch a User. You must be fetching yourself or be a superuser.
id
Fetch the current User.
Create a new User, return a 400 if the email address is already taken
You must be a superuser to do this.
-
first_namevalue must be a non-blank string. -
last_namevalue must be a non-blank string. -
emailvalue must be a valid email address. -
password -
group_idsvalue may be nil, or if non-nil, value must be an array. Each value must be an integer greater than zero. -
login_attributesvalue may be nil, or if non-nil, value must be a map with each value either a string or number.
Resend the user invite email for a given user.
You must be a superuser to do this.
id
Update an existing, active User.
-
id -
emailvalue may be nil, or if non-nil, value must be a valid email address. -
first_namevalue may be nil, or if non-nil, value must be a non-blank string. -
last_namevalue may be nil, or if non-nil, value must be a non-blank string. -
group_idsvalue may be nil, or if non-nil, value must be an array. Each value must be an integer greater than zero. -
is_superuservalue may be nil, or if non-nil, value must be a boolean. -
login_attributesvalue may be nil, or if non-nil, value must be a map with each value either a string or number.
Update a user's password.
-
id -
passwordInsufficient password strength -
old_password
Indicate that a user has been informed about the vast intricacies of 'the' Query Builder.
id
Reactivate user at :id
You must be a superuser to do this.
id
Logs.
You must be a superuser to do this.
Return a cryptographically secure random 32-byte token, encoded as a hexadecimal string.
Intended for use when creating a value for embedding-secret-key.
Anonymous usage stats. Endpoint for testing, and eventually exposing this to instance admins to let them see what is being phoned home.
You must be a superuser to do this.
Endpoint that checks if the supplied password meets the currently configured password complexity rules.
passwordInsufficient password strength