Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Get the names of the tables from a database

Topic Labels: API
5158 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.!!