Accessing nested objects in array

[Mike_Beattie]

Hi,
I'm sure this is really simple, but I cannot find out how to do it.

I'm using Retool to access a firestore database. The result set comes back as an array with objects in it :

In this case, I want to access the element "created_at" within "payload" :

What would the correct syntax be ? I have tried :

select payload.created_at from {{FirestoreCollection.data}} ;
but this returns an "undefined is not an object" error.

I realise it's something obvious, but I've searched the forum and the alaSQL documentation and not found an answer.

Thanks in advance.

[stefancvrkotic]

Hey Mike - welcome to the forum!

You can use -> to access nested objects
i.e.
My firestore data has canvas object with 3 different values and I'm looking to get winding which is a boolean value.

In your case it would be:

SELECT payload->created_at as created_at
FROM {{FirestoreCollection.data}}

Hope this helps!

[Mike_Beattie]

Wonderful !!! Thanks so much !!! Worked first time