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 created a Query and used M language to connect via REST API using the bearer authorization token

as follow:

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

 

After pressing "Done", I got the following expression error:

Expression.Error: We cannot convert the value false to type Text.
Details:
Value=FALSE
Type=[Type]

 

help would be appreciated.

Thanks.

Need Help

1 Reply

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