Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago
Solved

API Query Error - Unexpected error in JSON input

Hi all,   I'm trying to generate an authentication token from an API. The first step in using the API is to generate an API token by sending two parameters in the body of a POST request to the API....
  • Syndicate_Admin's avatar
    Syndicate_Admin
    3 years ago

    I received some help outside of this forum and was able to resolve the issue. The code that worked correctly follows:

     

    let
    url = "https://xxx.xxx.com/api/auth",
    headers = [#"Content-Type"="application/json"],
    body = "{ ""Param1"": ""XXX-XXX-XXX"", ""Param2"": ""YYY-YYY-YYY""}",
    Source = Text.FromBinary(Web.Contents(url,[ Content = Text.ToBinary(body), Headers = headers ]))
    in
    Source

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Syndicate_Admin ,

 

The error message you’re seeing is usually caused by an issue with the JSON format. It seems like there might be an extra character at the end of the JSON input.

You can try checking the JSON file in a JSON formatter to see if there are any additional pieces of information that might be causing the issue.

Or please try:

let
    url = "https://xxx.xxx.com/api/auth",
    headers = [#"Content-Type"="application/json"],
    body = Json.FromValue([Param1 = "XXX-XXX-XXX", Param2 = "YYY-YYY-YYY"]),
    Source = Json.Document(Web.Contents(url, [Content = Text.ToBinary(Json.ToString(body)), Headers = headers]))
in
    Source

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum