Get Data from Custom Report in local app

Dear Experts,
I am glad to come across such an awesome product, Metabase. I connected the Metabase to my custom application for generating an awesome dashboard. After exploring this application I got stuck in the middle. I have developed a report(tabular form) in my app with a few complicated logics using the native language, Is there any feature in Metabase whereby i can display the data returned from that custom report sir.


  "browser-info": {
    "language": "en-US",
    "platform": "Linux x86_64",
    "userAgent": "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.114 Safari/537.36",
    "vendor": "Google Inc."
  "system-info": {
    "file.encoding": "UTF-8",
    "": "OpenJDK Runtime Environment",
    "java.runtime.version": "1.8.0_282-b08",
    "java.vendor": "Red Hat, Inc.",
    "java.vendor.url": "",
    "java.version": "1.8.0_282",
    "": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "25.282-b08",
    "": "Linux",
    "os.version": "3.10.0-1160.21.1.el7.x86_64",
    "user.language": "en",
    "user.timezone": "Asia/Dhaka"
  "metabase-info": {
    "databases": [
    "hosting-env": "unknown",
    "application-database": "h2",
    "application-database-details": {
      "database": {
        "name": "H2",
        "version": "1.4.197 (2018-03-18)"
      "jdbc-driver": {
        "name": "H2 JDBC Driver",
        "version": "1.4.197 (2018-03-18)"
    "run-mode": "prod",
    "version": {
      "tag": "v0.38.4",
      "date": "2021-04-08",
      "branch": "release-x.38.x",
      "hash": "057b6bb"
    "settings": {
      "report-timezone": null

Hi @TashiD
I don't understand what you're trying to do, but you can write SQL queries in Metabase:

Dear Sir,
Thanks for your prompt response. I got the row data using SQL queries. However, I need to process this row data by applying some logics using python and visualize the processed data in Metabase.

@TashiD Then you need to do the processing on your database, so Metabase just gets the final result.

Thanks sir. Any possibilities of calling the custom report via api?

@TashiD Yes, Metabase has an API that let's you do almost everything you can do in the application:

1 Like

Thanks Sir

I want to use API as a data source instead of a database. Possible Sir?

@TashiD Metabase currently does not support REST/API based data sources: - upvote by clicking :+1: on the first post