Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Record id showing instead of Value

3414 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Craig_Robertson
4 - Data Explorer
4 - Data Explorer

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.

18 Replies 18
David_Lano
4 - Data Explorer
4 - Data Explorer

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:

Cristina_Grant
4 - Data Explorer
4 - Data Explorer

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!

Ben_Orozco
7 - App Architect
7 - App Architect

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

Hi! Has it been any progress in this? In my case it’s the most expected feature that would save plenty of extra queries

F_K
4 - Data Explorer
4 - Data Explorer

Same here. Any ideas?

F_K
4 - Data Explorer
4 - Data Explorer

I am using GraphQL to query the API, how do I re-query based on record Id?

Ambroise_Dhenai
8 - Airtable Astronomer
8 - Airtable Astronomer

Interested as well, using GraphQL underneath may be a viable solution and would bring lots of possibilities to the API!

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:

Andrew_Truong
4 - Data Explorer
4 - Data Explorer

this never happened, eh? seriously annoying where a CSV export of a view is miles faster than pulling via API.