Forum Discussion

adriana4u's avatar
adriana4u
Maven
3 years ago

Is there any API call to see how many posts have a tag?

Hello,   Is there any API call that we can use to see how many posts in our community have a certain tag?   Thank you ahead!
REST API v2 & LiQL
Akenefick's avatar
Akenefick
Genius
3 years ago

I think this should work. 

SELECT count(*) FROM messages WHERE tags.text = 'wireless headphones'

 

See here messages (khoros.com) for more options.

 

So the full call would be something like this

[Community Domain]/api/2.0/search?q=SELECT%20count(*)%20FROM%20messages%20WHERE%20tags.text%20%3D%20%27wireless%20headphones%27

 

or with Freemarker

rest("2.0","/search?q=" + "SELECT count(*) FROM messages WHERE tags.text = 'wireless headphones'"?url)

 

  • adriana4u's avatar
    adriana4u
    Maven
    3 years ago

    Hello,

     

    Hope to find you well. 

     

    I have tried to do this api call:

     

     

    And it gave the error above... Maybe I'm not doing it well, since I've only made rest apis before.

    • Akenefick's avatar
      Akenefick
      Genius
      3 years ago

      Hi,

      Try doing it through your browser while you are logged into your community in the same browser. 

      Also if you want more than the count you can add other fields like id to get a list of message ids for messages with that tag or view_href to get links to the posts. SELECT id, view_href, count(*) FROM messages etc.. Just need to encode everything after the equals sign, but it looks like you have that covered.