Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

How to retrieve table column metadata?

Topic Labels: API
4062 4
Showing results for 
Search instead for 
Did you mean: 

I’d like to retrieve types of columns in a table and their metadata, e.g. type, select options and colours.
Is there an API for this?

4 Replies 4

There’s no metadata available at all. :frowning:

@Chester_McLaughlin 's solution here is the best you will do:

I read his post, thought, wow, that seems like a terrible hack, but tried it, and got remarkably useful information out of it. An API, it is not.

I’d love to see a metadata API tho, it would make writing generic tools which interact with existing bases a whole lot easier.

There’s now this: Accessing the metadata API.


I know is too late, but maybe somebody can use it. I need to access to the Column Metadata too, like to check the options in a selectable field. I’m using a workaround for that, and it is to perform a call to the Airtable Web API, the API that they use on the Airtable Web Client.

fetch(`${baseId}/read`, {
    "headers": {
        "accept": "*/*",
        "x-airtable-application-id": baseId,
        "x-requested-with": "XMLHttpRequest",
        "x-time-zone": "Europe/Berlin",
        "x-user-locale": "us",
        "Cookie": `__Host-airtable-session=${AIRTABLE_SESSION}; __Host-airtable-session.sig=${AIRTABLE_SESSION_SIG};`

You need to use a couple of cookies, but they seem to work fine for very long time. You can see more information in my GitHub: GitHub - xavivaldes/airtable-schema: Workaround to retrieve the Base schema from Airtable. Waiting f...

Thank you!