Dump airtable contents to CSV

airtable-to-csv.php

<?php

/*
 * Totally simple way to dump an Airtable to CSV.
 * Uses https://github.com/sleiman/airtable-php
 */

// When true, first field is the row number (starting with 1)
define("NUMBER_OUTPUT_ROWS", true);

include('lib/airtable-php/src/Airtable.php');
include('lib/airtable-php/src/Request.php');
include('lib/airtable-php/src/Response.php');

use TANIOS\Airtable\Airtable;

// Enter credentials here
$airtable = new Airtable(array(
    'api_key'   => '',
    'base'      => '',
));

$request = $airtable->getContent( 'Brands' );
$stdout = fopen('php://output', 'w');

$base = 0;

do {
    $response = $request->getResponse();

	foreach ($response['records'] as $n => $rec) {
		if (!isset($headers)) {
			$headers = array_keys((array)$rec->fields);
			if (NUMBER_OUTPUT_ROWS) echo "#,";
			echo implode(",",$headers)."\n";
		}
		$row = $n + 1 + $base;
		$values = array();
		foreach($headers as $header) {
			$values[$header] = $rec->fields->$header;
		}
		if (NUMBER_OUTPUT_ROWS) array_unshift($values, $row);
		fputcsv($stdout, $values);
    }

    $base += $n;
    $request = $response->next();
	
} while( $request );


fclose($stdout);