Skip to main content

Is there any plan for an API to pull metadata? It’s currently very difficult to infer the schema, you have to resort to hacks like reading all records and then trying to infer types and column names from that. It’d be great if you could pull the schema information for a table more easily!



It’d also be awesome if you’d be able to add and change tables from the API, but that’s less pressing to me 🙂

+1. Apparently they’re working on it… 🙂





Note that the Standard API does not provide the ability to create or modify base schemas. For this type of behavior, you will need to use the Airtable Metadata API, which has not yet been released.






Anyone have any idea whether the Metadata API is getting close… ?


Anyone have any idea whether the Metadata API is getting close… ?


As of last week: months…


😞



Oh well. Guess I’ll stick with hard-coding for now… thx.


😞



Oh well. Guess I’ll stick with hard-coding for now… thx.


I found a half-way solution that will help in some use-cases while waiting for the metadata API.



Visit https://airtable.com/api and select a base. Then open your browsers console (Developer Tools) and run the following (I tried simply running JSON.stringify(window.application), however there are circular references so I had to manually reconstruct the properties I wanted).



var myapp = {

id:window.application.id,

name:window.application.name,

tables:l]

};



for (let table of window.application.tables){



var mytable = {

id:table.id,

isEmpty:table.isEmpty,

name:table.name,

nameForUrl:table.nameForUrl,

primaryColumnName:table.primaryColumnName,

columns:m]

};



for (let column of table.columns){

var mycolumn = {

id:column.id,

name:column.name,

type:column.type,

typeOptions:column.typeOptions

};



mytable.columns.push(mycolumn);



}



myapp.tables.push(mytable);



}



jQuery('linklrel=stylesheet]').remove();

jQuery("body").html(JSON.stringify(myapp));

console.log(myapp);

+1, getting the schema would be really great! Modifying the schema is far less important for our use-cases.


+1. Apparently they’re working on it… 🙂





Note that the Standard API does not provide the ability to create or modify base schemas. For this type of behavior, you will need to use the Airtable Metadata API, which has not yet been released.








Any news on this guys? Or are you keeping it exclusive to Zapier et al?


Similar to the @Chester_McLaughlin solution above I created a node script that launches a browser environment and downloads the schema to a json file. https://github.com/cape-io/airtable-schema


Similar to the @Chester_McLaughlin solution above I created a node script that launches a browser environment and downloads the schema to a json file. https://github.com/cape-io/airtable-schema


Unfortunately that’s not good enough for me.


I feel your hurt Tuur - between





  • the lack of a metadata API


  • the inability to list all bases accessible with a given API key (hmm Zapier can do it, why can’t we? What endpoint have they been granted access to that we haven’t?)


  • the inconsistent way that fields are returned (empty values are sometimes just missing, other times empty arrays)




developers will struggle to write useful, reusable tools. The silence on this front is frustrating. If a small % of the effort going into front end tools like Blocks was put into these small enhancements, the sky is the limit.


I feel your hurt Tuur - between





  • the lack of a metadata API


  • the inability to list all bases accessible with a given API key (hmm Zapier can do it, why can’t we? What endpoint have they been granted access to that we haven’t?)


  • the inconsistent way that fields are returned (empty values are sometimes just missing, other times empty arrays)




developers will struggle to write useful, reusable tools. The silence on this front is frustrating. If a small % of the effort going into front end tools like Blocks was put into these small enhancements, the sky is the limit.


I’m afraid the silence (and removing of old references) is telling…



They probably have other priorities.


I’d love to see a Metadata API as well…


Why would it take so long? They use something automated to generate the table’s API documentation (I doubt there’s a poor intern building each table model for each table’s API docs…).



I’m sure all they’d have to do is expose it as an API endpoint that we can read.


@Simon_Horup_Eskildse any chance we can do a similar schema hack for “view” meta data besides columns?


This is a blocker for me. Oh well, back to Google Sheets.


Hello, is there any official update on this? The blocks seems to be using a private API endpoint to fetch the data I want.



It would be cool if we could get access to the same API even if it’s released in Beta. At least we can build some proof-of-concept’s until a mature API is ready


+1 for making metadata a first class citizen


+1 and then some…



Schema…



If Airtable wants to see intelligent, non-brittle integrations emerge around their product, they will expand API access as soon as is practical. Forcing the developer community to script hard-coded solutions doesn’t allow us to create sustainable outcomes. This is bad for business.



Blocks…



It’s also not wise (in my opinion) for Airtable to create classes of API access that are denied to the general user community. It tends to stifle innovation. Ideally, we should all be able to define and register custom blocks using open web standards.


+1 for this feature, the ability to create tables and modify table schemas would be enormously helpful in our use case. I’d be happy to pay extra for this too.


+1 Readable metadata as a minimum!


This is a real bummer and would be very useful. Its 2020 now and still no response… frustrating


This is a real bummer and would be very useful. Its 2020 now and still no response… frustrating




Yep. A half-decade waiting. This is the equivalent of 35 Internet years; roughly half the lifetime of the product.



The request for a simple Split() function is also in the 5yr range. Unbelievable.


+1 and then some…



Schema…



If Airtable wants to see intelligent, non-brittle integrations emerge around their product, they will expand API access as soon as is practical. Forcing the developer community to script hard-coded solutions doesn’t allow us to create sustainable outcomes. This is bad for business.



Blocks…



It’s also not wise (in my opinion) for Airtable to create classes of API access that are denied to the general user community. It tends to stifle innovation. Ideally, we should all be able to define and register custom blocks using open web standards.


100% this… I’m wanting to work on a big integration with Airtable into my existing application, but it’s way too hard without having Schema definitions… its like you said… brittle and unpredictable - if I don’t know what type of field I’m working with, I can’t make a good experience for our users.


This is critical functionality and would make Airtable a much more powerful tool.




I was seeing? the codepen Airtable API Encoder, and I be reading the comments of this post, and i thinking that if is possible add more complex options to the codepen code for econde our Api to get more and best request? is for this that zapier can do other functions that we dont can?


Reply