Forum Discussion
Connecting Five9 API with Power BI
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
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
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=123456I am lost
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?
