I have been playing around for half an hour now and also only get subscriptions for the current user :( The target.id param seems to be always causing an error and therefor going against how it's documented even though it is returned in the resultset.
CarolineS target.type can be 'label', node.id can be 'board:your-board-id', the issue is the target.id. There seems to be no way to find out the label id.
But there is a work around. You can ignore target.id, the below query example can give you the subscribers of all labels within a board. The response JSON also contains the label info. You can then use Python or whatever language to filter out the label you are interested. You can use pagination to fetch all subscribers which involves multiple request calls.
SELECT * FROM subscriptions where target.type='label' and node.id = 'board:HomeProducts' limit 100
If you need a hand, I have developers to help you.
I might miss something, but for me this query only reports the labels I subscribed to, and I'm an admin. Any idea why?
nbalogh I am having this problem too. When I run the query as Peter suggested, I only get the label subscriptions of the user I'm logged in as. (this took me a minute... I run this query as a service user in postman and was getting empty results... once I "Switched user" to the service user and had them subscribe to a label, I got a result... but just for the one label that the service user subscribed to)
peterlu any way around this to get ALL user label subscriptions?
I have been playing around for half an hour now and also only get subscriptions for the current user :( The target.id param seems to be always causing an error and therefor going against how it's documented even though it is returned in the resultset.
