List all tables using the self-hosted API?

narthur · March 26, 2024, 3:11pm

Is there a way to list all tables in a workspace or database using a self-hosted baserow instance API? I’m working on a way to generate code from my database schema and would like a way to use my instance’s endpoint to discover all existing tables.

petrs · March 27, 2024, 2:02am

Hi @narthur, would list_database_tables endpoint be sufficient?

narthur · March 28, 2024, 11:21am

@petrs Looks promising! Thank you!

narthur · March 29, 2024, 4:49pm

Oof, seems that endpoint only supports jwt, not database tokens, unfortunately.

petrs · May 22, 2024, 10:03am

There is an open MR to allow database token to be used here: Enable token authentication to 'list_database_tables' endpoint (!1844) · Merge requests · Baserow / baserow · GitLab

However this is an external contribution and I can’t promise it will be merged (or when).

narthur · May 22, 2024, 11:04am

Great to hear! Currently I’m just hard-coding my tables list, so would be great if I could start using this endpoint with a database token.