Hi - I'm trying to access a metabase table from Python via https://pypi.org/project/metabase-api/.
First, I use mb.get('/api/database/')
and mb.get('/api/table/')
to get the appropriate db and table numbers. Then I run
query = {"database":2,"type":"query","query":{"source_table":16},"parameters":[]}
mb.post('/api/dataset/json',query)
But that returns false! What am I doing incorrectly?
Hi @eric.knudson
Check the Metabase log for more details - Admin > Troubleshooting > Logs.
The best way to learn the API, is to just use Metabase while having your browser developer Network-tab open and looking at the request, and what data is being send/received.
The export is not quite the same format as just regular queries. See your browser Network-tab.
https://www.metabase.com/docs/latest/api-documentation.html#post-apidatasetexport-format