Forum Discussion
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/te...
It is responding I have checked through web.browsercontains . Prolem has solved by using header and bearer token in it. thanks for the reply.
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