Trying to use occasion_data.status

Thanks MattV for the suggestion. I have tried that in the past and tried it just now to be sure. All I get back is this:

{
  "status" : "success",
  "message" : "",
  "http_code" : 200,
  "data" : {
    "type" : "messages",
    "list_item_type" : "message",
    "size" : 1,
    "items" : [ {
      "type" : "message",
      "occasion_data" : {
        "type" : "occasion_data"
      }
    } ]
  },
  "metadata" : { }
}

So I don't think that's the issue here.

And yes, that was a typo on my part, SarahD although I've tried it both ways and still get it returning as a null value unfortunately.

Even if my code is written as below, I still get "The following has evaluated to null or missing: ==> occasionData.occasion_data.status"

<#assign occasionQry="SELECT occasion_data.status FROM messages" />
<#assign getOccasionData=commonUtils.executeLiQLQuery(occasionQry) />
<#list getOccasionData as occasionData>
<#assign eventStatus=occasionData.occasion_data.status />
${eventStatus}
</#list>