How to retrieve table column metadata?

Sashman · ‎Nov 07, 2017

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?

Tuur · ‎Nov 07, 2017

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

Hugh_Campbell · ‎Nov 09, 2017

@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.

Joe_Wicentowski · ‎Jan 25, 2021

There’s now this: Accessing the metadata API.

Xavi_Valdes · ‎Feb 14, 2021

Hi!

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(`https://airtable.com/v0.3/application/${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!