metabase常用指令

• 获取管理员session

很多操作都基于session

curl -X POST -H "Content-Type: application/json" -d '{"username": "root@qq.com", "password": "root"}' http://127.0.0.1:3000/api/session

{"id":"c9ad042a-9481-4547-bd77-e83321e20f26"}% 

• 创建账号

将上面获取的id填到 X-Metabase-Session 中。 分组可以不填，如果填写group_ids参数、必须含有1所有人组。通过命令方便批量创建用户，分组。

curl -X POST -H "Content-Type: application/json" -H "X-Metabase-Session: c9ad042a-9481-4547-bd77-e83321e20f26" -d '{"first_name": "wu", "last_name": "core", "email": "test1@qq.com", "password": "test1", "group_ids":[1,20]}' http://127.0.0.1:3000/api/user

• 重置用户密码

在数据库中找到用户id，我这里的是96，password填新密码。

curl  -X PUT -H "Content-Type: application/json" -H "X-Metabase-Session: c9ad042a-9481-4547-bd77-e83321e20f26" -d '{"password" :"test1234"}'  http://127.0.0.1:3000/api/user/96/password 

• 查看用户信息

curl  -H "X-Metabase-Session: 3a133416-b27e-4503-b8a6-74d51bd89742"  http://127.0.0.1:3000/api/user/96

• 查看面板、问题数据

curl -X POST -H "X-Metabase-Session: 3a133416-b27e-4503-b8a6-74d51bd89742" http://127.0.0.1:3000/api/card/597/query

{"data":{"rows":[
["2020-09-10T00:00:00+08:00",6.355237937855E10],
["2020-09-09T00:00:00+08:00",7.4175531087601E10],
["2020-09-08T00:00:00+08:00",8.4376768223309E10],
["2020-09-07T00:00:00+08:00",8.4343592824870998E10],
["2020-09-06T00:00:00+08:00",8.3672440357048998E10],
["2020-09-05T00:00:00+08:00",8.3682336807729E10],
["2020-09-04T00:00:00+08:00",8.3643838965455E10]
],

• 更多api可查看官方文档
  Metabase官方API