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.
miguel
Community Admin
Community AdminHey!
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.