Connection from Power BI

XO Platform APIs and SDKs
1

Hi!

I am trying to get the conversations from Power BI, using the API. The request is working fine for me in Postman (getMessages endpoint, JWT token as a header). But when replicating it from Power Query, I am seeing error 400.

Has anybody connected from Power BI via API? The Power Query code I tried out is:

= Json.Document(Web.Contents(“https://de-bots.kore.ai/api/public/stream//getMessages”, [Headers=[#“Content-Type”=“application/json”, #“auth”=]]))

2

I solved it after several tries. The solution was to include in the request an empty body: Content=Text.ToBinary(“”)