The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi Community,
Can anyone please help me to connect Five9 API with Power BI.
Here is the Five9 Document
Thanks In Advance,
Sowmiya
Solved! Go to 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
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
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?
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