Help

Re: How to retrieve table column metadata?

2853 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Sashman
6 - Interface Innovator
6 - Interface Innovator

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
Tuur
10 - Mercury
10 - Mercury

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

Hugh_Campbell
5 - Automation Enthusiast
5 - Automation Enthusiast

@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
5 - Automation Enthusiast
5 - Automation Enthusiast

There’s now this: Accessing the metadata API.

Xavi_Valdes
4 - Data Explorer
4 - Data Explorer

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!