Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Feb 26, 2016 05:54 PM
Hello all,
I have been messing around with the API and PHP to try and display a list of records.
I have been sort of successful in retrieving records but when it is linked to another table it just shows the Record ID instead of the value from the other table. Anyway around this?
For instance in the code below $model is returned as the Record ID instead of the Model Name.
if ( array_key_exists ( 'Model', $fields ) ) {
echo '<h2>Model</h2>';
echo '<ul>';
foreach ( $fields[ 'Model' ] as $model ) {
echo '<li>' . $model . '</li>';
}
echo '</ul>';
}
Thanks.
Feb 02, 2017 11:58 AM
I’d also love to see the API expanded so it could reference and output the actual field name for a linked record. For now, I’ll use the Formula hack, but that does at a lot of extra work. I’m hoping to integrate Airtable extensively with our Klipfolio dashboard, so naturally a richer API would be much appreciated! :grinning_face_with_big_eyes:
Mar 01, 2018 07:43 PM
I saw this was posted back in 2016. Any news of expanding the API so that the linked records return all of its cell values inline? It would be quite useful!
Aug 11, 2018 10:42 AM
Something like http://jsonapi.org/ supports the includes
parameter exactly to include nested relationships
Also, a GraphQL endpoint would achieve same thing more elegantly IMHO: API Idea: GraphQL endpoint
Dec 28, 2018 11:46 AM
Hi! Has it been any progress in this? In my case it’s the most expected feature that would save plenty of extra queries
Feb 11, 2019 06:00 AM
Same here. Any ideas?
Feb 11, 2019 06:34 AM
I am using GraphQL to query the API, how do I re-query based on record Id?
Feb 23, 2019 05:07 AM
Interested as well, using GraphQL underneath may be a viable solution and would bring lots of possibilities to the API!
Dec 15, 2021 11:12 PM
return all its cell values inline, rather than simply its record ID
are there any updates on this matter?
its quite ironic to do relational database in airtable to validate records yet when you store them into another warehouse say snowflake. all you get are IDs…
now you have re-join the different tables just to get the desired result and that’s quite the resource just to re-join. that’s like doing twice the effort. :face_vomiting:
Jan 13, 2022 10:44 AM
this never happened, eh? seriously annoying where a CSV export of a view is miles faster than pulling via API.