Select labels along with messages in one query

Yes you can do this with a json subquery. The Community API v2 request (khoros.com)

I think yours would look something like this:

[
    {
      "messages":{
        "fields":[
          "id",
          "subject",
          "search_snippet",
          "body",
          "cover_image.view_href",
          "teaser",
          "view_href",
          "author",
          "conversation.last_post_time",
          "replies.count(*)",
          "metrics.views",
          "labels"
        ],
        "constraints":[
          {
            "category.id":"DE",
            "conversation.style":"tkb",
            "body":"mykeyword",
            "depth":0
          }
        ],
        "sorts": [
            "post_time desc"
        ],
        "limit":10,
        "subQueries":{
          "labels":{
            "fields":[
              "text"
            ]
          }
        }
      }
    }
]

There is a good example here of using Freemarker to make an API request with a json body restBuilder (khoros.com)

Thanks for your answer, 

unfortunately I cannot access developer.khoros.com urls. They always stuck in a TOO_MANY_REDIRECTS error by the browser.

Can you please give me an example here on how the request for messages with a subquery looks like?

Sure are you using Freemarker? See below.

<#assign messagePostCall = restBuilder()
   .method("POST")
   .path("/api/2.0/search")
   .body([
    {
      "messages":{
        "fields":[
          "id",
          "subject",
          "search_snippet",
          "body",
          "cover_image.view_href",
          "teaser",
          "view_href",
          "author",
          "conversation.last_post_time",
          "replies.count(*)",
          "metrics.views",
          "labels"
        ],
        "constraints":[
          {
            "category.id":"DE",
            "conversation.style":"tkb",
            "body":"mykeyword",
            "depth":0
          }
        ],
        "sorts": [
            "post_time desc"
        ],
        "limit":10,
        "subQueries":{
          "labels":{
            "fields":[
              "text"
            ]
          }
        }
      }
    }
])
   .admin(true) />
<#assign resp = messagePostCall.call() />

I think that should work.

thx,

the like contraint doesnt seem to work:

"body":"mykeyword",

it returns 

I looked it up and it should be like this

MATCHES Operator Syntax
"fieldname": { "matches": value }
Example:
"subject":{ "matches":"'Another concert review'" }

So try replacing that with:

"body":{ "matches":"'mykeyword'" },

thanks, that worked. 

One more question (sorry to bother you further)

How would this LIQL constraint be in a JSON query

AND labels.text IN ('Text1','Text2')

Thank you very much for the quick response and help.