Count # of members subscribed to a topic?

You can supply the thread id when querying API v2's "subscriptions" collection:

Count of subscribers: 
SELECT count(*) FROM subscriptions WHERE target.type = 'thread' AND target.id = '2250'

Subscribers: 
SELECT subscriber FROM subscriptions WHERE target.type = 'thread' AND target.id = '2250'

Thanks Claudius 

I suspect user error on my part but this doesn't appear to be working for me. 

If i subscribe using a test account the result doesn't change, I am show '1' as the result in count query, the details query just shows my details (the 1 account I assume)?

I am changing the targetid of course so I'm not sure what I am doing wrong. 

SELECT count(*) FROM subscriptions WHERE target.type = 'thread' AND target.id = '2250'

• Shows the result of '1' despite subbing from other test accounts.

SELECT subscriber FROM subscriptions WHERE target.type = 'thread' AND target.id = '2250'

• Results in my details being shown only; I know another account is subscribed however. I am logged in as the Admin here. 

tyw 

Unfortunately yes, this API is only designed to do stuff for the current users subscriptions (or another user if you pass subscriber.id='xx') and is unable to do a global count of subscribers to a node. 

Is there a way to get board subscriptions by using the same format mentioned above? 

"Count of subscribers: 
SELECT count(*) FROM subscriptions WHERE target.type = 'thread' AND target.id = '2250'

Subscribers: 
SELECT subscriber FROM subscriptions WHERE target.type = 'thread' AND target.id = '2250'"

Hello Bparra 

Hi MohammedSh 

Both! However it keeps giving me my user id unique subscriptions and Im wanting global subscriptions to certain threads and boards.

Another problem I am having is that our board ids have changed and Im not able to find the board id of when they were originally created. 

Thanks! 
Betty Jo 

Bparra, to locate the board ID, navigate to Community Structure, access the board, and select Manage. The URL should conclude with "forum-board:myforum". For filter creation, utilize your text editor to locate the necessary code phrases such as "board.id.title = Forum ID". Another option is to use "config.filter_report_board_id.title = Board ID for filter reports".

Please refer to this post for complete details with screenshot. 

Hi all,

Sorry to be late to this thread, as has already been said trying to get thread level subscriber counts is not very well supported at the moment. It should be better using the APIs provided by Aurora.

For Board subscriber counts

I have written an excel file which allows you to iterate through every board in a community and find out how many people are subscribed to that board.

Instructions:

Open this XLSM file: https://1drv.ms/x/s!AkiSjdO4yjrasPABOjsq12IkyikdVA?e=mYjICe

You may need to enable content (depending on the security settings of your excel installation)

Go to the settings tab and enter: 

UserName: the user name of a user in your community who at least as read permissions to the API

Password: The password for the above user (note: if your community uses SSO then you will need to create a non-sso user using the create user button in the Users Tab).
Community URL: The base url for your community (i.e. https://community.khoros.com

ClientID: Go to this page: OAuth 2.0 authorization grant flow (khoros.com) and follow the steps to register an App and you get this client id.

Once done go back to the Report Data tab and click Get Subscription Data and it will pull every single category / board from your community and put the subscriptions to that board in this file.

As noted previously this count DOES NOT include subscriptions to the actual topic just the board.

If you get an error when you try to run the code you may need to add some references. To do this open the file, right click on the sheet name and click "View Code". When the VBA editor opens click Tools at the top and click References.

This file requires:

• Visual Basic for Applications
• Microsoft Excel 16.0 Object Library (likely anything newer will also work)
• OLE Automation
• Microsoft Office 16.0 Object Library (likely anything newer will also work)
• Microsoft ActiveX Data Objects 6.1 Library
• Microsoft Forms 2.0 Object Library
• Microsoft XML v6.0

Disclaimer: this file is provided as is, it was clean of viruses and only does what I say it does at the time I uploaded it but you should treat any file you don't know with suspicion until your happy it works safely.

This file REQUIRES Microsoft Excel Desktop and will not function in the Web browser.

Feel free to reuse any of my VBA code, although would love to know if you use guys use it for anything else cool!

Whoa!  This worked.  I checked the VBA for anything scummy and found nothing. 

I did, however, make one change in Main_Prog to allow it to work for me:

strLiql = "Select id,title from categories where ancestor_categories.id = 'communities' ORDER BY position DESC limit 1000"

making it:

strLiql = "Select id,title from categories ORDER BY position DESC limit 1000"

Thank you for sharing this!  Currently I have a PowerQuery M script getting other sorts of data, and have been hoping to get some API tools a bit more integrated into Excel for stuff like this.  This file gives a sweet jump-start! 

I will share my (re)usages!