Metadata

In order to present the client the list of Tables and Field as well as correctly parse the return data from the Airtable API, we need metadata.

Unfortunately the standard API does not offer this information and further omits keys from the response when the value is null-like

Returned records do not include any fields with "empty" values, e.g. "", [], or false.

Airtable does offer a Metadata API; however, this API is not open to the public:

If you want to develop an integration using the Metadata API, you must register here for access and to receive a client secret. Enterprise Airtable accounts do not require a separate Metadata API client secret.

Other options that were explored / might work:

• Infer (guess) the type using the first N rows of data
• Scrape the API docs page, which offers a data structure with this information
  • https://github.com/aivantg/airtable-schema-generator
  • https://github.com/real-ashwin/airtable-schema-chrome-extension
  • https://github.com/cape-io/airtable-schema
    • https://github.com/qumaujean/airtable-schema-generator
  • https://github.com/noamross/archive-airtable
  • OpenAPI / Swagger
    • https://github.com/briankinney/airtable-swagger
• Scrape a "shared" page
  • https://github.com/banditelol/blog/blob/master/content/blog/scraping-airtable-pt2/index.md
  • https://github.com/banditelol/airscraper
  • https://github.com/thgh/Airtable-to-Figma
  • https://github.com/apibrac/get-airtable-schema
• Using the Web Client API
  • With Cookies: https://github.com/xavivaldes/airtable-schema
• Blocks
  • https://github.com/TheF1rstPancake/AirtableOpenAPICustomBlock
• Snoop with errors [sort / filter]
  • This doesn't seem to work