Retrieve a record by ID (faster than quickCheck) about airtable-php HOT 2 CLOSED

Hi @peachp thank you for reaching out and for the the feedback! :)

You can use getContent() in order to retrieve a single record using the Record ID.
You just have to specify the 'recId' after the table name (tableName/recId).
This will return a single record, you won't need to loop through the records to retrieve the content.

Here's an example:

$request = $airtable->getContent( 'Tracks/recsJX1bry74HaGBh' );
$response = $request->getResponse();
echo $response->id;

I just did a simple benchmark test for each way. Using a table with less than 500 records, the results were very similar between the two. With a larger set of records, it was much faster to use the Record ID to retrieve your single record.

I hope this helps!

from airtable-php.

Hi. Thanks for the tip! Yes, it does help even if it won't be much faster, it is still cleaner compared to doing something like:

$params = array(
                "filterByFormula" => "AND( RECORD_ID() = '$rec_id' )",
                "maxRecords" => 1,
                "pageSize" => 1
);

Thanks again and keep up the good work!

Btw, one of the projects I use your code in is a bespoke theme for the Grav CMS, which will allow to use Airtable as backend / DB for the website. Static pages like Homepage or Contact will be still created in Grav, but repeating, semi-dynamic content such as let's say Portfolio will be managed in Airtable, because it is more comfortable, and in our case we also use the same data for backend order processing. Of course it cannot replace a proper MySQL or similar, but for websites which don't have a lot of visitors and the content doesn't change that often, it's a good GUI / DB combination.

from airtable-php.