Overview
Metabase is an open-source business intelligence tool with a REST API that lets you query your databases, manage dashboards, and export data programmatically. You host it yourself (or use Metabase Cloud), and the API uses session token authentication after a simple login call. It is great for beginners who want to automate reports or embed analytics in their own apps.
Beginner Tip
Your first step is always to get a session token via POST /api/session with your username and password. Store this token and include it as X-Metabase-Session in every subsequent request — tokens expire after 14 days by default.
Available Data
The kind of data this API exposes, based on its documentation. We could not call the endpoint to confirm the exact field names.
Example Response
Illustrative shape only — we were not able to call this endpoint (it requires credentials or exposes no public sample URL), so the fields below show the kind of data this API returns rather than a recorded response.
{
"route": "Line 1",
"origin": "Station A",
"destination": "Station B",
"departure": "08:30",
"arrival": "09:15",
"status": "On Time",
"delays_min": 0
} Field Reference
id Session token UUID; include this as X-Metabase-Session header in all subsequent requests data For query results: contains "rows" (array of arrays) and "cols" (column metadata) describing the dataset name Human-readable name of the dashboard, card, or database object returned description Optional text description of the resource creator_id User ID of the person who created this resource in Metabase Implementation Example
Calls a real endpoint of this API. Replace any placeholder credentials with your own key.
const url = "http://localhost:3000/api/session";
const response = await fetch(url);
if (!response.ok) throw new Error(`Request failed: ${response.status}`);
const data = await response.json();
console.log(data); What Can You Build?
Note: These code examples are AI-generated and unverified. Always refer to the official API documentation for accurate usage.
Common Errors & Troubleshooting
Generated guidance based on this API's documentation, not observed by us. Treat it as a starting point and check against the provider's own error reference.
Metadata Score Breakdown
Estimated from metadata — endpoint not independently tested
Metadata estimate · endpoint not independently tested
Technical Specifications
Related Tags
Similar APIs
View All →Countly
Countly is an open-source product analytics platform, and its REST API lets you query event data, session metrics, user counts, and custom dashboards you have set up in your Countly instance.
Datamuse
⭐ Beginner's PickDatamuse is a free word-finding API that helps you discover words by meaning, sound, spelling, and context — no API key needed.
Drupal.org
The Drupal.org API gives you programmatic access to information about Drupal modules, projects, users, and releases hosted on drupal.org.
Evil Insult Generator
⭐ Beginner's PickThe Evil Insult Generator API returns randomly generated humorous (fictional) insults in multiple languages — no API key required.
GitHub Contribution Chart Generator
⭐ Beginner's PickThe GitHub Contribution Chart Generator API creates a visual representation of any GitHub user's contribution activity over the past year.