Forum Discussion

leeclemmer's avatar
leeclemmer
Guide
2 years ago

Data/Metrics on Subscriptions

Hi there, I got a question that I thought would be straight-forward, but doesn't seem to be: "how many users are subscribed to category XYZ?" Apparently there's no good way to answer this? In lookin...
Bulk Data API
Community API
Rest API
REST API v2 & LiQL
irach15's avatar
irach15
Maven
2 years ago

you can also get the nested subscriptions

https://developer.khoros.com/khoroscommunitydevdocs/docs/retrieve-nested-subscriptions-for-a-node

 

You can make this call if you logged as an Admin

https://yourcommunity/api/2.0/search?q=SELECT%20*%20FROM%20subscriptions&restapi.response_style=view&restapi.response_format=json

However, 

you can not run this call via Postman, I've tried any possible way and created a Khoros support case and reached to their devs for that, Waiting on the response.

https://{{hostname}}/api/2.0/search?q=SELECT%20*%20FROM%20subscriptions LIMIT 1000&restapi.session_key={{sessionkey}}

I can make many of the api calls except of the above... 

  • leeclemmer's avatar
    leeclemmer
    Guide
    2 years ago

    Thanks for your comment irach15 . However the problem I've been running into when making LIQL calls against the subscriptions collection is that I'm only getting my own subscriptions; this is also what happened when I put your API call in after being logged on: I only see my own subs. Is this a permission issue?