Forum Discussion

StefanFried's avatar
StefanFried
Steel Contributor
Mar 03, 2020

PSTN Call Statistics - API

hi i'm heavily looking for a way to retrieve PSTN data in an automatic way. I can't find anything in terms of Graph HOWEVER i have seen a vendor which can pull this data "somehow". So i'm wondering...
microsoft teams
lexcpc's avatar
lexcpc
Copper Contributor
Jul 16, 2020

StefanFried 
Not many replies here. Maybe it was too new?
I am looking at the MSGraph API in beta, but struggling to get it working.  I hope there will be some full walkthrough soon.

MrDeanoB's avatar
MrDeanoB
Copper Contributor
Jan 19, 2021

lexcpc

 

Appreciate this reply may be a little late  (and may have been solved) but I've only just come across this thread.

 

I've been looking into this myself and have solved - or, at least, have found a way of doing this with the beta graph APIs. First, I pull the SKUs to understand how many business voice licenses exist to determine total call minutes available. I then use the API:

/communications/callRecords/getPstnCalls
 
to look for any call type that matches and outbound call and then total the duration for each matching record. From this, you end up with total minutes available for the tenant and total minutes used. If you want an example then let me know.
 
The getPstnCalls takes a date range so you can specify the window you want data for. From this, you could choose to run when needed. As an example, we use this data to provide our customers will daily updates on their calling credits.
  • NickK890's avatar
    NickK890
    Brass Contributor
    Mar 01, 2023

    MrDeanoB , Appreicate if you can provide an example.  Thanks !

    • Prachi_Jain's avatar
      Prachi_Jain
      Copper Contributor
      May 22, 2023

      NickK890 Do you find any solution for this.

       

      Could please advise?

       

      Thank you

       

      Prachi Jain

      • NickK890's avatar
        NickK890
        Brass Contributor
        May 23, 2023

        Prachi_Jain , Not really.

         

        I believe following is the method but haven't had chance to properly test it yet. 

        https://learn.microsoft.com/en-us/graph/api/callrecords-callrecord-getpstncalls?view=graph-rest-beta&tabs=http

         

        Thanks ! Nick.

  • pion_1eer's avatar
    pion_1eer
    Copper Contributor
    Feb 01, 2021

    MrDeanoB 

    If it wont be too much trouble, i would like to know how you achieved this walkaround. I'm trying to do the same thing on my end but it amounts to no success