Forum Discussion
TariqHussain
8 years agoBoss
rapalaku- Unfortunately, there is no filed for subscription added date in API v2 and API v1 result that is why there is no way to fetch the count of subscription added in previous month.
E.g
API V2
"type" : "subscription", "id" : "1134", "href" : "/subscriptions/1134", "target" : { "type" : "board", "id" : "test", "href" : "/boards/test", "view_href" : "/t5/Surge/bd-p/test" }, "subscriber" : { "type" : "user", "id" : "475", "href" : "/users/475", "view_href" : "/t5/user/viewprofilepage/user-id/475", "login" : "tariqh" }
You can only count the board subscription since the beginning.
SELECT count(*) FROM subscriptions WHERE target.type = 'board'
Or post an idea here.
Related Content
- 4 years ago
- 7 years ago