Forum Discussion

cike's avatar
cike
Champion
9 years ago

Query messages by tag using API v2

Hi,   I'm currently working on a component which show all messages for given tag. To get all messages I want to use REST API v2. My request looks like this:   SELECT * FROM messages WHERE depth ...
ChhamaJ's avatar
ChhamaJ
Khoros Staff
9 years ago

Hi irach15

 

You can try to do some thing like this 

select * from tags where messages.id = '1'

 You will have to provide message id though.

 

Regards,
Chhama

irach15's avatar
irach15
Maven
9 years ago

ChhamaJ,

yeaaa... I know about that way for a single id..

I need for any id, not a specific one aka universal call...

  • irach15's avatar
    irach15
    Maven
    9 years ago

    OK,

    I found how.

    it needs to be a couple calls.

    Some other parameters here are just for testing purpose :-)

     

    <#if page.context.thread??>
<#assign apiVersion = "2.0"/>
<#assign articleId = page.context.thread.topicMessage.uniqueId?c />
<#assign tagsQuery = "SELECT * FROM tags WHERE messages.id = '" + articleId + "'"/>
<#assign tags= rest(apiVersion, "/search?q=" + tagsQuery?url + "&restapi.response_style=view").data.items![] />
<h4>Tags!!!</h4>
<#list tags as tag>
<ul>
    <li>Tag: ${tag.text}</li>
</ul>
</#list>
<ul>
    <li>articleId: ${articleId}</li>
    <li>apiVersion: ${apiVersion}</li>
</ul>
</#if>