Trying to use occasion_data.status

Hello there,

This is a great question! I do need a little more context to properly test this on our end.

Can we see more of the code? For example, how are you making the query within FreeMarker? Are you using the rest context object, liql context object, etc.?

More information:

• rest context object
• liql context object

Once I have this information, I can test the method of retrieving data from the rest API against the data being retrieved. That will help us determine where the issue is.

Here is some more information that might be helpful:

• Make a Rest Call with FreeMarker

Thanks so much for your help and patience,

Ryan

Excuse my code if it's messy, I'm still learning all the Khoros stuff! 😅

Here's the basic query I'm using, I've stripped out a few things that didn't really pertain to my issue. The real issue is that the query isn't returning the status object, whether I run it here in my code or if I run it in the API browser in Studio

<#assign currentDate=.now?iso_local>
<#assign occasionQry="SELECT subject, view_href, occasion_data, images FROM messages WHERE board.id='instructurelive' AND occasion_data.status IN ('upcoming','ongoing')  ORDER BY occasion_data.start_time asc LIMIT 1" />
<#assign getOccasionData=commonUtils.executeLiQLQuery(occasionQry) />
<#list getOccasionData as occasionData>
//Assign some variables from my query here
</#list>

All the docs I'm seeing say that if I grab "occasion_data" I should be able to use the status object (but I'm still learning so I could be interpreting that totally wrong).

What I was trying to do later on with the occasion_data.status object was something like:

<#if occasionData.status == 'upcoming'>
//do some stuff for upcoming events here
<#else>
//do stuff for ongoing events here
</#if>

But that's where I got the null value error as if my query wasn't pulling in the status object. Can we not use status in this way? It clearly is tied to the event since I can pull it in for my WHERE filter but it doesn't come in as an object that I can use elsewhere in FreeMarker

Run the 

SELECT subject, view_href, occasion_data, images FROM messages WHERE board.id='instructurelive' AND occasion_data.status IN ('upcoming','ongoing')  ORDER BY occasion_data.start_time asc LIMIT 1

 query in the API browser in studio, and see what the data structure looks like. I don't have a good place to test at the moment, but if you're having issues with that, I'd guess that potentially the occasion status isn't in the exact structure you expect.

That's the problem, it's not in the structure at all. So I'm wondering, is this something buggy in our instance or an oversight in either the API or the docs? Or maybe just something that's not included yet? Here's what I get back from that query:

{
  "status" : "success",
  "message" : "",
  "http_code" : 200,
  "data" : {
    "type" : "messages",
    "list_item_type" : "message",
    "size" : 1,
    "items" : [ {
      "type" : "message",
      "view_href" : "/t5/test-event/Upcoming-Test-Event/ev-p/7648",
      "subject" : "Upcoming Test Event",
      "occasion_data" : {
        "type" : "occasion_data",
        "start_time" : "2021-07-15T07:00:00.000-07:00",
        "end_time" : "2021-07-15T08:00:00.000-07:00",
        "timezone" : "US/Mountain",
        "location" : "",
        "featured_guests" : {
          "type" : "users",
          "list_item_type" : "user",
          "size" : 0,
          "items" : [ ]
        },
        "rsvp" : {
          "query" : "SELECT * FROM rsvps WHERE message.id = '7648'"
        },
        "pending_invites" : {
          "query" : "SELECT * FROM occasion_invites WHERE message.id = '7648'"
        }
      },
      "images" : {
        "query" : "SELECT * FROM images WHERE messages.id = '7648'"
      }
    } ]
  },
  "metadata" : { }
}

APIv2 doesn't always return everything, you may need to specifically select it. So instead of SELECT occassion_data try SELECT occasion_data.status

Natkinson 

If I understand the return object, correctly, I think you just have a misleading loop variable name.

what is currently:

<#if occasionData.status == 'upcoming'>
//do some stuff for upcoming events here
<#else>
//do stuff for ongoing events here
</#if>

Should be:

<#if occasionData.occasion_data.status == 'upcoming'>
//do some stuff for upcoming events here
<#else>
//do stuff for ongoing events here
</#if>

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>

MattV would you suggest filing a ticket with support to report this as a bug? Or what's the best course of action for reporting issues like this?

Yes I would suggest filing a support ticket.