Metabase Custom icon

Metabase Custom

Use the Metabase API

Actions4

Question → Result Data

AI-generated

Overview

This node interacts with the Metabase API to retrieve result data for a specific question. It is designed to fetch the output of a saved question in Metabase, which can be useful for automating report generation, data extraction, or integrating Metabase query results into other workflows.

Common scenarios include:

  • Automatically exporting query results from Metabase for further processing.
  • Integrating Metabase question results into dashboards or other applications.
  • Scheduling regular data exports in various formats (CSV, JSON, XLSX).

For example, you might use this node to get the latest sales report stored as a Metabase question and export it as a CSV file for analysis in a spreadsheet application.

Properties

Name Meaning
Question ID The unique identifier of the Metabase question whose result data you want to retrieve.
Format The format in which to receive the result data. Options: CSV, JSON, XLSX.

Output

The node outputs the result data of the specified Metabase question in the chosen format. The json output field contains the parsed response from the Metabase API, typically including the data rows and metadata depending on the format requested.

If the format is CSV or XLSX, the node may also output binary data representing the file content suitable for download or further processing.

Dependencies

  • Requires an active connection to a Metabase instance via an API key credential.
  • The node configuration must include the base URL of the Metabase server.
  • Proper permissions on the Metabase side to access the specified question and its results.

Troubleshooting

  • Invalid Question ID: If the provided Question ID does not exist or is inaccessible, the node will fail. Verify the ID and user permissions.
  • Authentication Errors: Ensure the API key credential is valid and has sufficient rights.
  • Unsupported Format: Only CSV, JSON, and XLSX are supported. Using other formats will cause errors.
  • Network Issues: Connectivity problems with the Metabase server will prevent data retrieval.

Links and References

Discussion