Forum Discussion

rapalaku's avatar
rapalaku
Guide
8 years ago

Is there any possibility to get Number of discussion board subscriptions added in the previous month

Do we have any api call to get "Number of discussion board subscriptions added in the previous month" in the community? If not, Is there any logic to achieve this with multiple api calls?   Thanks...
TariqHussain's avatar
TariqHussain
Boss
8 years ago

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.