Hi,
My org is looking to retrieve questions contain certain columns. We have over 4k questions so doing this manually would not be possible. I found that the API that is available for Metabase and was wondering if it was possible to use with Python to retrieve columns within a question via an endpoint.
Thank you for your help,
Vincent
Why don't you access the Metabase Application DB and check for those fields in the report_card table which is the table that stores all your question reference
A light SQL query should get you what you need
Unfortunately it looks like the way my org has set up databases in admin, the Application DB is not available to query. Are there alternative ways to look for this?
Not really no, I mean you can programatically fetch each card metadata then do the search programatically but thats gonna be a lot of work ... Easier to simply ask your Admin to give access and you can query your App DB outside of metabase, just connect directly to it 