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+supervisor-rest-api-reference-guide.pdf

2. https://webapps.five9.com/assets/files/for_customers/documentation/apis/config-webservices-api-reference-guide.pdf

Thanks In Advance,

Sowmiya

 

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

3 Replies

  • 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

    • jemh_100's avatar
      jemh_100
      New Member
      6 years ago

      Good afternoon, Can someone help me, use the query that they put in to connect me to five9 but send me the following message:

       

      Expression.Error: No se puede aplicar el operador & a los tipos Text y Number.
      Detalles:
      Operator=&
      Left=appsvcs/rs/svc/agents/
      Right=123456

       

      I am lost 

    • garrettm's avatar
      garrettm
      New Member
      6 years ago

      Does this work even though the second link provided (to the Config Web Service API) is a SOAP API and not a REST API?  If not, is there any way to send the requests in a SOAP envelope?