We want to query activity logs periodically via API, from the instance I saw there is a section called Acitivity logs which is internally querying the card with ID: 51. I drilled down more and saw that v_audit_log table is getting queried which is part of Internal Metabase Database database.
My question is can we rely on this table name value to get the logs? because a possible solution is to directly query this table (possibly using table id or table name) but I feel the table id might change from metabase instance to instance.
Also if we can rely is there a way to use table name instead of table id while getting the data?
Havent found a guide for building the queries,
I would suggest you check the Metabase analytics collection and hit the card endpoints so you get the data
I did checked the card endpoint, internally it is using "card__51" but the thing is this card id might differ from metabase instance to instance. We dont want to rely on this id.