Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Data Format .Error: We found extra characters at the end of JSON input.

Hi,

I am trying to fetch data from web using api using this format

 

let
    Source = Json.Document(
        Web.Contents(
            "https://dev.azure.com/{organization}/{project}/_apis/work/teamsettings/iterations/{iterationId}/capacities/{teamMemberId}?api-version=6.0"
        )
    ),
    #"Converted to Table" = Table.FromRecords({Source})
in
    #"Converted to Table"

 

but its giving an error

 

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

 

can anyone help me out

Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    4 years ago

    It is responding I have checked through web.browsercontains . Prolem has solved by using header and bearer token in it. thanks for the reply.

7 Replies

  • miguel's avatar
    miguel
    Community Admin
    4 years ago

    Hey!

     

    Probably the response that you're getting from the API is not a valid JSON.

     

    Try converting your query to the one below and then read the file as a TXT document by right clicking the binary icon and reading it as a TXT / CSV:

    let
    Source = Web.Contents(
            "https://dev.azure.com/{organization}/{project}/_apis/work/teamsettings/iterations/{iterationId}/capacities/{teamMemberId}?api-version=6.0"
        )
in
    Source

    You need to determine if the response is a valid JSON or not. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      It is responding I have checked through web.browsercontains . Prolem has solved by using header and bearer token in it. thanks for the reply.

  • MiguelRodrigues's avatar
    MiguelRodrigues
    Regular Visitor
    3 years ago

    Hello,
    Can you please share how the code should look like?
    I'm getting the same errors with below code:
    let
    Source = Json.Document(Web.Contents("link")),
    #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", {"fields"})
    in
    #"Expanded Column1"

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi,

      1. try to check the java code in sublime or any other compiler. There must be an extra "," or other things to join the existing code which you have to understand and remove to get in the data.
      2. firstly check with using wer content then convert it to json. This step will let you know if your credentials are working or not. if its not working then use headers and add authentication and token.

      These things I will suggest you for now.

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    can u explain how did you resolve it what is "Prolem has solved by using header and bearer token in it."