Subscribers to label

ldelagoutte jeffshurtliff Akenefick I heard back from Engineering. This is indeed a gap in the API. The issue has come up in the past, yet a formal ticket for a feature request never came as a result. 

I think the best path moving forward is to file a ticket through Support. Bugs/Enhancements/Feature requests have more sway when they come from customers than only from within. Be sure to mention the both the inability to get subscribers to a label as well as the need to interact with subscriptions not limited to the user account making the request.

ldelagoutte have you tried querying the board where the labels exist and seeing if they show up as nested subscriptions?

jeffshurtliff and ldelagoutte  I tried the nested subscriptions and it worked, but it gave me both label and conversation subscriptions.

SELECT id, target.type, subscriber, href FROM subscriptions WHERE target.id = 'aktestboard' AND target.type = 'board' AND include_nested = true

I tried to constrain it to just labels with nested_target_type but could not get that to work.

Very odd, I just confirmed the same thing.  It seems that the nested_target_type only works for the board and category values and not for conversation, label or message and possibly others.

I also tried filtering for a specific label ID and struck out as well:

Query:

SELECT * FROM subscriptions WHERE target.id = 'Downloads' AND target.type = 'label'

Response:

{
  "status" : "success",
  "message" : "",
  "http_code" : 200,
  "data" : {
    "type" : "subscriptions",
    "list_item_type" : "subscription",
    "size" : 0,
    "items" : [ ]
  },
  "metadata" : { }
}

SuzieH, are you and the Engineering Team already aware of this limitation?  Any suggestions for filtering only for label subscriptions another way with LiQL?

Akenefick, where are you using the LiQL response, is it in some FreeMarker code or through a script or something?  I ask because you could always filter the query results after the fact...although I could see where this would almost certainly result in much larger query results than you'd want.

FreeMarker Example:

<#-- Import dependencies -->
<#import 'theme-lib.common-functions' as commonUtils />

<#-- Perform the LiQL query -->
<#assign query = "SELECT subscriber,target FROM subscriptions WHERE target.id = 'my-awesome-forum' AND target.type = 'board' AND include_nested = true" />
<#assign subscriptions = commonUtils.executeLiQLQuery(query, false, true)![] />

<#-- Initialize a sequence to store the results -->
<#assign labelSubscriptions = [] />

<#-- Loop through the data -->
<#list subscriptions as subscription>
  <#if subscription.target.type == 'label'>
    <#assign subData = {
      "label": (subscription.target.id)!"UNKNOWN_LABEL", 
      "user": (subscription.subscriber.login)!"UNKNOWN_LOGIN"
    } />
    <#assign labelSubscriptions += [subData] />
  </#if>
</#list>

(Disclaimer: I wrote the code above from memory without testing so it should be correct and free from syntax errors.  🙂) 

EDIT: Adjusted the executeLiQLQuery function call to run as admin per your latest comment.