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 ...
irach15's avatar
irach15
Maven
9 years ago

Hi cike,

I was looking for something else and found your question.

Sorry, it might be too late and you've already figured it out :-)

Anyway,

here is the way how I'm getting all messages tagged with a specific tag

<#assign messages = rest("2.0","/search?q=" + "SELECT id, body, subject, view_href, post_time, board.id, teaser, board FROM messages WHERE tags.text = 'sometag' AND depth=0 ORDER BY post_time DESC LIMIT 10"?url) />

you can mention 'conversation.style' and other restrictions. you can try 'restadmin' if you don't see it.

------------------------

BTW, I'm looking how to get all tags and/or labels for a specific article without mentioning an article id, just any article when the user views it.

Any idea?

Thank you.

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>