Connecting Five9 API with Power BI

[Sowmiya]

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-ap...

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

Thanks In Advance,

Sowmiya

[v-shex-msft · Accepted solution]

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="abc@xxx.com",
 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

[garrettm]

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?

[jemh_100]

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