Hi @channel, having some query. since I am new to Metabase, I couldn't find api for retrieving details from database tables.
I have multiple database and in each database I have multiple table.
I need to extract a particular table from a particular database using a query in table like created date> some date..
I was able to figure out this api to find the database id
Tried using
https://url/metabase/api/database/id?include=tablename
Using this gives,404 error
Thanks in advance
Hi @gowtham_kishore
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.
For reference: https://www.metabase.com/docs/latest/api-documentation.html
You cannot return a single table like that. I'm not completely sure what you're trying to do, but first you need to find the ID of the table - you could use this:
/api/database/:id/metadata
And then if you need the columns of one of the tables returned in the above query, then try:
/api/table/:id/query_metadata?include_sensitive_fields=true