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": s

	{

			"id": "rec2aPmtsQyMWL0gL",

			"createdTime": "2022-10-10T10:23:38.000Z",

			"fields": {

				"Type": "type",

				"ID": 2,

				"Luck": 1,

				"Order": 2,

				"Rewards": s

					"reca2ZiYRTk0rqv9x",

					"recg2oisqku0f9kol"

				],

                 ...]

I will have an expanded Rewards data:

"records": s

	{

			"id": "rec2aPmtsQyMWL0gL",

			"createdTime": "2022-10-10T10:23:38.000Z",

			"fields": {

				"Type": "type",

				"ID": 2,

				"Luck": 1,

				"Order": 2,

				"Rewards": s

					{

                           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