Metabase API
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
Example 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
const url = "https://www.metabase.com/";
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
Matrix Score Breakdown
Fully tested on Apr 5, 2026
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.