Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Expression.Error: We cannot convert the value false to type Text when connecting to Wrike's REST API

Hi,  I'm trying to connect to Wrike API via oAuth2. I have created an app in Wrike and got the access token .   I have made a test via postman and it worked perfectly.   In Power BI, I have cre...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous , you may need to check that output is actually a JSON Document.  

let
  Source = Web.Contents("https://www.wrike.com/api/v4/timelogs",
           [Headers=[#"Authorization"="#Authorization"="bearer <access token>"]]),
  //convertToJson = Json.Document(Source)
  viewBinary = Binary.ToText( Source )
in
  viewBinary

 

This should show you something similar to your Postman results.