Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi every body,
I'm trying to connect to TFS, here is my code for the edvanced editor:
let
GetWorkItemIds = () =>
let
Source = Json.Document(Web.Contents("https://XXXXXX.visualstudio.com/XXXXXX/_apis/wit/wiql/a722b515-98b6-4bf7-b4a9-102c9aca1b8a")),
workItems = Source[workItems],
#"Converted to Table" = Table.FromList(workItems, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expand Ids" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"id"}, {"Work Item Id"})
in
#"Expand Ids"
in
GetWorkItemIds
With this code I get a function, but when I click to the "invoke" button, It appears the followin error:
Error inesperado en la consulta 'Consulta1'. DataFormat.Error: Se encontraron caracteres adicionales al final de la entrada JSON.
Detalles:
Value=
Position=4
Any idea?
Thanks and regards
@sandragocj27,
I test your function using my own JSON file, and everything works well. In your scenairo, do you get any error message when directly paste the following M codes into advanced editor of a new blank query?
let Source = Json.Document(Web.Contents("https://XXXXXX.visualstudio.com/XXXXXX/_apis/wit/wiql/a722b515-98b6-4bf7-b4a9-102c9aca1b8a")), workItems = Source[workItems], #"Converted to Table" = Table.FromList(workItems, Splitter.SplitByNothing(), null, null, ExtraValues.Error), #"Expand Ids" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"id"}, {"Work Item Id"}) in #"Expand Ids"
Regards,
Lydia
This is the error I get:
Error inesperado en la consulta 'Consulta1'. DataFormat.Error: Se encontraron caracteres adicionales al final de la entrada JSON.
Detalles:
Value=
Position=4
@sandragocj27,
It seems that there are extra characters in the JSON file that returned by TFS, please check my reply in this similar thread.
Regards,
Lydia
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |