Record id showing instead of Value

[Craig_Robertson]

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.

[David_Lano]

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]

Howie:

API to “expand” that linked record and return all its cell values inline

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]

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

[Marc_Vilella]

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]

Same here. Any ideas?

[F_K]

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

[Ambroise_Dhenai]

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

[Chadd_Dumagas]

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]

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