let
[/LIST]
Source = Json.Document(Web.Contents("https://api.octopus.energy/v1/electricity-meter-points/**YOUR MPAN**/meters/**YOUR MP SERIAL**/consumption/?period_from=2018-12-13T00:00:00Z&period_to=2021-01-17T00:00:00Z&page_size=25000")),
results = Source[results],
#"Converted to Table" = Table.FromList(results, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"consumption", "interval_start", "interval_end"}, {"Column1.consumption", "Column1.interval_start", "Column1.interval_end"}),
#"Changed Type" = Table.TransformColumnTypes(#"Expanded Column1",{{"Column1.consumption", type number}})
in
#"Changed Type"