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

[Anonymous]

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.

[Daryl-Lynch-Bzy]

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.