Hello there. I was working on my sales management project which accessed multiple rows from another table in the base. when I used REST API, I found that I could only get the key of the row, instead of all the fields the row contained.
I have an ‘Inventory’ and ‘Order’ table in my base. the Inventory table has ‘Item Name’ and ‘Price’ fields, I access them from the Order table through a Link to table field called ‘Sales’, to show what items have been purchased in the very order.
It looks all good in Baserow, yet when I access it from API it seems only the key is obtainable:
"Sales": [
{
"id": 1,
"value": "Apple"
},
{
"id": 2,
"value": "Banana"
}
]
I was wondering if it’s possible to get more information out of linked rows? in this case, I would like to have ‘Price’ field along with it, as the following:
"Sales": [
{
"id": 1,
"value": {
"Item Name": "Apple",
"Price": 300
}
},
{
"id": 2,
"value": {
"Item Name": "Banana",
"Price": 500,
}
}
]
Thank you folks.