Accessing table's model via API

Did you get anywhere with this? I am trying to do something very similar. Checking for already existing records etc.

Sadly I didn’t. I originally sent an email to Airtable about this and no-one has given me an answer yet there either (the first reply suggested I ask on the community forum…).

Here’s the deal…

I have been able to pull the table names using php /json. (see below)
But my ONLY problem is to always pull the column name despite if the field are empty or not. By default AirTable only allows data that is “not” empty… Does anyone know how to override this?

<?php
$AIRTABLE_API_KEY = 'key_XXXXXXXXXX';
$AIRTABLE_BASE_ID = 'app_XXXXXXXXX';
$AIRTABLE_TABLE_NAME = 'Your_Table_Name';
$AIRTABLE_PARAMS = '&amp;maxRecords=1&amp;view=All%20Responses'; //Retrieve just one record.
$AIRTABLE_API_URL ='https://api.airtable.com/v0/';

if (($AIRTABLE_API_KEY) && ($AIRTABLE_BASE_ID) && ($AIRTABLE_TABLE_NAME)):

$url =$AIRTABLE_API_URL.$AIRTABLE_BASE_ID."/".$AIRTABLE_TABLE_NAME."?api_key=".$AIRTABLE_API_KEY.$AIRTABLE_PARAMS;

$column_names = array();
$records = array();

$st = ini_get("default_socket_timeout"); // backup current value
ini_set("default_socket_timeout", 5000); // 5 seconds

$data = @file_get_contents($url); 
    if($data === false):
        echo "<strong>Airtable API Connection Error!</strong><br/>There is an error when connecting to AirTable API. Please make sure your Airtable credentials are all correct.";
    else:
        echo "<strong>Success!</strong><br/>You are successfully connected to Airtable's API.";

        //Start process after successful connection.
        ini_set("default_socket_timeout", $st); // restore previous value

      $arrJson = json_decode($data, true);
      $records = $arrJson['records'][0]['fields']; //Drilldown to the fields level

      //Just get the Column Names
      foreach($records as $key => $val):

          $column_names[ $key ] = $key; 

      endforeach;

    endif;
else:

    $column_names = "Please Connect to AirTable first";

endif;
      //Show results in array of data.
      var_dump($column_names);
      die();

I’m finding this a bit hard to grok at the moment. There’s obviously some way to get the table’s model/metadata, as is apparent in the API Documentation being generated per table. However there is not a publicly exposed way to do this.

Is there any way to get an actual Airtable dev to look at this and give us some insight as to why it might not be public, and is there any way we can request this feature?

There is an API. I know one developer who had access to it, and obviously Zapier uses it too.

At this point I would be very surprised if it will ever see a public release though. All references to it in the public docs are gone too…

Hmm. I got an email notification about a reply to this from @Jordan_Violet, but now the reply on this thread has gone. I tried the info he put in there, however the closest I get to anything is from accessing:

GET https://api.airtable.com/v0/{{base_id}}/meta

… and the response:

{
    "error": {
        "type": "TABLE_NOT_FOUND",
        "message": "Could not find table meta in application {{base_id}}"
    }
}

Unfortunately they shut down the API from public use.