Sign inSign up

amond/metabase

By amond

•Updated almost 6 years ago

Image
0

784

amond/metabase repository overview

⁠metabase-http-json

⁠Example Site

https://metabase.amond.dev⁠

id : [email protected]
password: u3RGGEi5KKxP
⁠Query
{
  "url": "https://mixpanel.com/api/2.0/funnels/?funnel_id=5947336",
  "method": "GET",
  "headers": {
    "Authorization": "Basic NDMyMTQzMjM3OGI1NTBlYTQyZDRiMmZmZDBiMzBkMmY6"
  },
  "result" : {
    "path" : "data.2019-06-19.steps",
    "fields": ["count", "step_label"]
  }
}
⁠Http to Table

https://metabase.amond.dev/question/1⁠

⁠Http to Funnel

https://metabase.amond.dev/question/2⁠

⁠Run

docker run -p 3000:3000 amond/metabase:v0.32.9

⁠Usage

{ "url": "https://mixpanel.com/api/2.0/funnels/?funnel_id=5947336" }

The driver will make a GET request and parse the resulting JSON array into rows. Currently it only supports JSON.

You can provide a different method as well as headers and a JSON body:

{
  "url": "https://api.coinmarketcap.com/v1/ticker/",
  "method": "POST",
  "headers": {
    "Authentication": "SOMETOKEN"
  },
  "body": {
    "foo": "bar"
  }
}

Additionally, you can provide a result object with a JSONPath to the "root" in the response, and/or a list of fields:

{
  "url" : "https://mixpanel.com/api/2.0/funnels/?funnel_id=5947336",
  "result" : {
    "path" : "data.2019-06-19.steps",
    "fields": ["height", "time"]
  }
}

You can also predefine "tables" in the database configuration's Table Definitions setting. These tables will appear in the graphical query builder:

{
   "tables" : [
      {
         "name" : "Blocks",
         "url" : "https://blockchain.info/blocks?format=json",
         "fields" : [
            { "name" : "height", "type" : "number" },
            { "name" : "hash", "type" : "string" },
            { "name" : "time", "type" : "number" },
            { "type" : "boolean", "name" : "main_chain" }
         ],
         "result" : {
            "path" : "blocks"
         }
      }
   ]
}

Tag summary

Content type

Image

Digest

Size

257.5 MB

Last updated

almost 6 years ago

docker pull amond/metabase