Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
Solved! Go to Solution.
It is responding I have checked through web.browsercontains . Prolem has solved by using header and bearer token in it. thanks for the reply.
can u explain how did you resolve it what is "Prolem has solved by using header and bearer token in it."
Hello,
I am also try to extract data from same azure rest API "https://dev.azure.com/{organization}/{project}/{team}/_apis/work/teamsettings/iterations/{iterationI... facing same issue , could you please provide more details information on this.
Thanks
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
Hi,
These things I will suggest you for now.
Hello
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.
It is responding I have checked through web.browsercontains . Prolem has solved by using header and bearer token in it. thanks for the reply.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
26 | |
12 | |
11 | |
11 | |
8 |
User | Count |
---|---|
53 | |
28 | |
16 | |
14 | |
13 |