- 获取管理员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