Get Data from Custom Report in local app

1

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.

Thanks

2 
{
  "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",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "1.8.0_282-b08",
    "java.vendor": "Red Hat, Inc.",
    "java.vendor.url": "https://www.redhat.com/",
    "java.version": "1.8.0_282",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "25.282-b08",
    "os.name": "Linux",
    "os.version": "3.10.0-1160.21.1.el7.x86_64",
    "user.language": "en",
    "user.timezone": "Asia/Dhaka"
  },
  "metabase-info": {
    "databases": [
      "mysql",
      "h2"
    ],
    "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
    }
  }
}
3

Hi @TashiD
I don't understand what you're trying to do, but you can write SQL queries in Metabase:
https://www.metabase.com/docs/latest/users-guide/writing-sql.html

4

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.

5

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

6

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

7

@TashiD Yes, Metabase has an API that let's you do almost everything you can do in the application:
https://www.metabase.com/learn/developing-applications/advanced-metabase/metabase-api.html

1 Like
8

Thanks Sir

9

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

10

@TashiD Metabase currently does not support REST/API based data sources:
https://github.com/metabase/metabase/issues/4831 - upvote by clicking :+1: on the first post