Expected behavior:
Say I have table Parents that have 1:N relations with table Students. Students in turn have 1:N relations with table Tutors.
Something like this:
{
"parent_name": "Aderonke",
"created": 1610025386000,
"Students": [
{
"tutors": {
"tutor_name": "John",
"phone": "123",
"created": 1610027425000,
"objectId": "D3E311E3-EB15-485A-9842-07A12F871ED6"
},
"subject": "Maths",
"created": 1610027323000,
"student_name": "Panos",
"updated": 1610027643000,
"objectId": "823D9812-0CB8-49B1-907E-ABEA5698C762"
}
]
}
- I check if objects in Parents need updating versus a property in an external list
- I now want to check if the relations 2 levels deep (Students and Tutors) need updating as well.
I am trying to use a load table block with dot notation like this
But I only get 1 object from the 1:N relations. Is that normal?
Alternatively I can load table by specifying properties and relations depth. However I would need a sequence of complex nested IF/else statements to check if each relation needs updating (if the related object exists, if the relation has changed, etc.)
What is the best way to check objects with relations versus an external list and then update them?