Issue – While creating the question from the metric (created from a model) and group by with a column already present in the model, I have encountered the permission issue. Although, I have Full rights and provided the same rights to my API key, while creating question, I am getting the view only with my question. Also, while hovering on the view only it shows me message – One of the administrators hid the source table "Test_BM_Data", making this question view-only. Tried multiple times creating the question still I am not getting editor access to the question. What I am trying to do – I am working with some sort of automation, so after creation of model & metric (from same model), I am creating a question using some automation tool using API Hit (provided same rights as me having currently). I have hitted a POST Request on https://metabase.xxxxxxxxxx.com/api/card and in body I have provided the necessary details required to create question. The API is not failing shows that my API hit is correct. But I am unable to find a reason why after giving same access as I have I am getting view only for a question created by API.
Can you post a (redacted) version of the API call?
what’s the Test_BM_Data table and why is it hidden?
Test_BM_Data(model) is not hidden it is in the same collection where I am trying to create the question also the metric which I have used in the creating the question is also in the same collection.
API Call -
POST
URL - https://metabase.xxxxxxxxx.com/api/card
Authentication - None
Header - X-API-Key (zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz)
JSON Body-
[
{
"name": "SDFGSDFG",
"display": "table",
"collection_id": 000,
"dataset_query": {
"type": "query",
"query": {
"source-table": "card__0000",
"aggregation": [
[
"metric",
0000
]
],
"breakout": [
[
"field",
"xxxxxxxx",
{
"base-type": "type/Text"
}
]
]
}
},
"visualization_settings": {}
}
]
Hey, any update how to resolve this?