Forum Discussion

Sowmiya's avatar
Sowmiya
Helper III
7 years ago
Solved

Connecting Five9 API with Power BI

Hi Community, Can anyone please help me to connect Five9 API with Power BI. Here is the Five9 Document 1. https://webapps.five9.com/assets/files/for_customers/documentation/apis/vcc-agent+supervis...
General Comment
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Sowmiya,

     

    You can refer to following links about use power query to get data from REST api and web service:

     

    Get Data from Twitter API with Power Query

    Sample:

    let
 //Url header which used in other request
 APIHeaderURl="https://app-scl.five9.com:443/",
 //Login to get Authorization Key
 username="[email protected]",
 password="******",
 body="{""passwordCredentials"":{""username"":"&username&",""password"":"&password&"},""policy"":""ForceIn""}",
 AuthKey =Web.Contents("https://app.five9.com/appsvcs/rs/svc/auth/login",
     [
         Headers = [#"Content-Type"="application/json"],
         Content = Text.ToBinary(body) 
     ]
 ),
 
 //Use Sample
 agentID=123456,
 RequestPath="appsvcs/rs/svc/agents/"&agentID&"/callbacks",
 Result = Web.Contents(APIHeaderURl&RequestPath,
     [
         Headers = [#"Authorization"=AuthKey,
                    #"Content-Type"="application/json"])
     ]
 )
 in
  Result

     

    Working with web services in Power Query/Excel and Power BI

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Sowmiya,

 

You can refer to following links about use power query to get data from REST api and web service:

 

Get Data from Twitter API with Power Query

Sample:

let
 //Url header which used in other request
 APIHeaderURl="https://app-scl.five9.com:443/",
 //Login to get Authorization Key
 username="[email protected]",
 password="******",
 body="{""passwordCredentials"":{""username"":"&username&",""password"":"&password&"},""policy"":""ForceIn""}",
 AuthKey =Web.Contents("https://app.five9.com/appsvcs/rs/svc/auth/login",
     [
         Headers = [#"Content-Type"="application/json"],
         Content = Text.ToBinary(body) 
     ]
 ),
 
 //Use Sample
 agentID=123456,
 RequestPath="appsvcs/rs/svc/agents/"&agentID&"/callbacks",
 Result = Web.Contents(APIHeaderURl&RequestPath,
     [
         Headers = [#"Authorization"=AuthKey,
                    #"Content-Type"="application/json"])
     ]
 )
 in
  Result

 

Working with web services in Power Query/Excel and Power BI

 

Regards,

Xiaoxin Sheng