API Enpoint to list all bases for an api key?

Is there an endpoint to list all the bases for an api key, zapier is able to do it in their app, but i couldn’t find anything related to this in the standard api documentation ?

6 Likes

no one has answered yet?!

No. Unfortunately, the API requires you to know the table(s) you wish to access.

My cross base/cross workspace search engine desparately needs this ability, and to overcome this lack of schema transparency, my system requires admins to first configure a table of tables.

A table of tables? How do you achieve that?
Also, how can be a table of tables be above bases?

Just create a table of all bases and tables that you want an API process to know about. When you open and access this table in the API, you can read it and then know about all the other tables that your API process should access to do its job.

It can’t - that’s the whole point. Airtable has not exposed this capability, so, you need to come up with a good way to overcome this shortfall. A table of bases and each its own tables achieves this. Lots of additional configuration effort and some maintenance responsibility, but it works.

2 Likes

Just wanted to +1 the need for this API endpoint. Like @Bill.French I’m building a tool for other Airtable users, and currently I need to explain to each user how they should go and get their Base IDs manually, and then have them type in table names (hopefully without spelling or formatting errors).

It would be extremely helpful if the API that Zapier uses was made public.

3 Likes

You can go to the main page of your api (w w w airtable dot com slash api) (sorry the forum wont let me post links), open the browser console and run the following sript:

const targetElements = document.querySelectorAll(".mb1.link-quiet.pointer.flex.items-center");
let str = "";
Array.prototype.slice.call(targetElements).forEach(el => {
  str += `"${el.getAttribute("title")}";"${el.getAttribute("href").split("/")[1]}"\n`;
})
console.log(str);

Not an actuall API endpoint but if you dont want to manually change the fields it works :slight_smile:

2 Likes

Thanks for chiming in @Allan_Holmes and welcome to the community.

Finally, we have a better pathway to build smarter apps.

1 Like

Is the api call https://api.airtable.com/v0/meta/bases working? I am getting a Not Found error, possibly due to the wrong key? I am using the key generated from my dashboard’s account feature.

Hey João - Are you using the special metadata API key + request header?

See this document. You need to register for a special metadata API key: https://airtable.com/api/meta

Hey Acco. Firstly, thank you for helping out. I am using the normal API key, that was probably why. I registered for a special metadata API key but I am still waiting on it, how long it usually takes to have the key?

Thanks.

Yep that’s it @Joao_Cavalcanti

I’m not sure how long it takes, not on the Airtable team :slight_smile: