How to get data using app api key?

[Arya_Shetty]

Hi,

I've got api key and url. I'm trying to extract json data from them. So I've formulated this code.

let

apiUrl = "<url>",

token="<api key>",

options = [Headers=[Authorization="Bearer " & token ]],

result = Json.Document(Web.Contents(apiUrl , options))

in

#"result"

But I'm getting this error.

DataFormat.Error: We found extra characters at the end of the JSON input.
Details:
Value=<
Position=2

Using Anonymous. Please help with this. Thank you.

[v-jingzhang]

Hi @Arya_Shetty 

You may refer to an old thread: We found extra characters at the end of JSON input... - Microsoft Power BI Community Many people shared their solutions to the same problem. Maybe you can find one helpful. 

In addition, if you use result = Web.Contents(apiUrl , options), will this query return a binary value successfully before converting it to JSON format? 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.