Error: Cannot convert a value of type Record to type List

(0) Share

Report

Posted on by JohnG768

I've been using a web link to import some game data into Excel for several years now. Recently, I started getting this message when I refresh the data:

Expression.Error: We cannot convert a value of type Record to type List.

Here is the code. The full code is longer (renaming/removing columns), but this is where the error pops up.

let
 Source = Json.Document(Web.Contents("https://swgoh.gg/api/player/182854573/")),
 #"Converted to Table" = Record.ToTable(Source),
 Value = #"Converted to Table"{0}[Value],
 #"Converted to Table1" = Table.FromList(Value, Splitter.SplitByNothing(), null, null, ExtraValues.Error)
in
 #"Converted to Table1"

I've found a few other threads with similar issues, but unfortunately, I don't fully understand how the code works, so I'm not equipped to determine a solution on my own.

Anyone have possible solutions?

Thanks,

John

Categories:

General Comment