Help

Get the names of the tables from a database

Topic Labels: API
4247 2
cancel
Showing results for 
Search instead for 
Did you mean: 
HHelb
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello!
I am writing a script that will export all the data from a database into Json files.
With the API, I can easily get the column’s name and their values, but can’t get the table’s name!
For instance, I have a table named “People” with its attribute: name, address, age, etc…
I can get the attributes… but I want to get “People”.
So I wrote manually in the script their names, but it’s not very convenient as if, in the future, new tables will be created.
Is there any call I can do with the API? A “get” function or do something with the value of the records received?

I work with node.
Thank you and have a nice day everyone!

2 Replies 2
zgavin
4 - Data Explorer
4 - Data Explorer

This. The lack of method in the API to reach multiple tables at any given time is extremely limiting.

MuhammadAli
5 - Automation Enthusiast
5 - Automation Enthusiast

I’m also facing this same issue. and i want to get all table names in a base.?
is this possible or not? as we get all table names in sql, mysql and oracle etc. e.g in mysql we get DB::select( “SHOW tables”); but in airtable im unable to do so.!!