Here’s a jump start using PHP code that should run just fine on just about any server/setup. I’ve quickly edited one of my class methods down to this—meaning, I haven’t actually run this code but it’s essentially what I always use when I’m outside of Wordpress. Inside of Wordpress, I have a different function that uses Wordpress’ wp_remote_get, transients, and other functions specific to the framework.
The following should return you records from a view called “Open Late” for a table called “Items” that have fields called “Type” and “Price” that match the values specified. It will sort the results on two fields—first Price then Type.
Good luck!
<?php
$AIRTABLE_API_KEY = "xxxxx";
$AIRTABLE_API_URL = "xxxxx";
$AIRTABLE_APP_ID = "xxxxx";
$table = "Items";
$filterByFormula = "OR( AND({Type}='Drink',{Price} <= 3), AND({Type}='Snack',{Price} <= 6))";
$view = "Open Late";
$sort = array(array("field" => "Price", "direction" => "desc"), array("field" => "Type", "direction" => "asc"));
$limit = 10;
$params = array("filterByFormula" => $filterByFormula, "view" => $view, "sort" => $sort, "limit" => $limit);
$items = getAirtableRecords($table,$params);
var_dump($items);
private function airtable_get($endpoint,$params=array()){
global $AIRTABLE_API_URL, $AIRTABLE_APP_ID, $AIRTABLE_API_KEY;
$ch = curl_init();
$http_headers = array( 'Authorization: Bearer ' . $AIRTABLE_API_KEY,
'Content-Type: application/json'
);
curl_setopt( $ch, CURLOPT_HTTPHEADER, $http_headers );
curl_setopt( $ch, CURLOPT_RETURNTRANSFER, TRUE );
curl_setopt( $ch, CURLOPT_TIMEOUT, 10 );
curl_setopt( $ch, CURLOPT_CUSTOMREQUEST, $method );
// Create an array to use to for URL and HTTP Headers.
$http_params = array();
// Initialize the offset.
$offset = '';
$records = array();
// Make calls to Airtable, until all of the data has been retrieved...
while ( !is_null( $offset ) ) {
// We're using an offset to get specific batches of records.
if (!empty($offset)){
$http_params["offset"] = $offset;
}
if (isset($params["view"])){
// Has a view been specified? The API will honor any filters
// that have been applied to the view, as well as any sort
// order that has been applied to it.
$http_params["view"] = $params["view"];
}
if (isset($params["limit"])){
// By default, the APi will return 100 records per request.
// You can specify smaller batch sizes using the "limit"
// query parameter, as we are here.
$http_params["limit"] = $params["limit"];
}
if (isset($params["sort"])){
// You may specify a sort order for the request,
// which will override any sort order that has been
// applied on the view.
$http_params["sort"] = $params["sort"];
}
if (isset($params["filterByFormula"])){
$http_params["filterByFormula"] = $params["filterByFormula"];
}
// Specify the URL to call.
$curlopt_url = $AIRTABLE_API_URL
. $AIRTABLE_APP_ID
. '/' . rawurlencode($endpoint)
. "?" . http_build_query($http_params);
curl_setopt( $ch, CURLOPT_URL, $curlopt_url );
// Execute the request.
$response_json = curl_exec( $ch );
// If there was a curl error encountered while making the call...
if ( curl_errno( $ch ) != 0 ) {
// Show an error message with the CURL error code.
// For a complete list of error codes, see:
// http://curl.haxx.se/libcurl/c/libcurl-errors.html
echo '<h2>CURL Error</h2>';
echo 'Code: ' . curl_errno( $ch );
echo "\n<br>\n".$curlopt_url;
die;
}
// Decode the JSON-formatted response that was received from the Airtable API.
$response = json_decode( $response_json, TRUE );
// If the Airtable API returned an error...
if ( isset ( $response["error"] ) ) {
// Show an error message.
echo '<h2>Airtable Error</h2>';
echo 'Type: ' . $response["error"]["type"] . '<br />';
echo 'Message: ' . $response["error"]["message"] . '<br />';
die;
}
// When getting a table, we'll build an array of records,
// when getting a record, we'll just return the record.
if (isset($response["records"])){
// remember, this could be just one of many pages
// so merge the results and keep fetching till we're done!
$records = array_merge($records,$response["records"]);
} else {
$records = $response;
}
// Adjust the offset.
// Airtable returns NULL when the final batch of records has been returned.
$offset = (isset($response["offset"]))? $response["offset"] : null;
}
curl_close( $ch );
return $records;
}
?>
