Extended data for linked records in RESTful API

Stefan_Isarie · ‎Oct 10, 2022

Hey All! Nice to find you!

I am happy I’ve discovered Airtable as it seems to be quite a nice data management platform for my use cases. We are a team of two guys: one that manages data and me, the one who will consume this data via RESTful API in a web application.

I’ve created four tables in base and linked them appropriately. All good for now. What I want when accessing the API is to have the links fully expanded (with all the data) and not just the ID pointing to a reference ID. Would that be possible?

So, basically instead of (see Rewards key):

"records": [
	{
			"id": "rec2aPmtsQyMWL0gL",
			"createdTime": "2022-10-10T10:23:38.000Z",
			"fields": {
				"Type": "type",
				"ID": 2,
				"Luck": 1,
				"Order": 2,
				"Rewards": [
					"reca2ZiYRTk0rqv9x",
					"recg2oisqku0f9kol"
				],
                [...]

I will have an expanded Rewards data:

"records": [
	{
			"id": "rec2aPmtsQyMWL0gL",
			"createdTime": "2022-10-10T10:23:38.000Z",
			"fields": {
				"Type": "type",
				"ID": 2,
				"Luck": 1,
				"Order": 2,
				"Rewards": [
					{
                           id: "reca2ZiYRTk0rqv9x",
                           field: "Another",
                           [other fields]
                    },
					{
                           id: "recg2oisqku0f9kol",
                           field: "And yet another",
                           [other fields]
                    }
				],
                [...]

Would that be possible with Airtable RESTful API? Looking forward for an answer!

Thank you!

Stefan