AWS IoT Core Rule for uplink_message rx_metadata array

1

I am transferring data from AWS IoT Core using a rule into DynamoDB, which works for everything except the rx_metadata from TTN since it is in an array.

I think the below is correct syntax, but it does not work.

SELECT
uplink_message.rx_metadata[0].rssi as rssi
FROM ‘lorawan/+/uplink’

Any suggestions?

2

I found a solution.
get(uplink_message.rx_metadata,‘0’).rssi AS rssi