let // Read VOO's file (one GET, no key), naming your own project Fund = Json.Document(Web.Contents( "https://tickerinside.com/api/v1/fund/voo.json", [Headers = [#"User-Agent" = "MyProject/1.0 (+https://example.com)"]])), // holdings maps each ticker to its weight in percent: one row each Rows = Table.RenameColumns(Record.ToTable(Fund[holdings]), {{"Name", "ticker"}, {"Value", "weight_pct"}}), Typed = Table.TransformColumnTypes(Rows, {{"ticker", type text}, {"weight_pct", type number}}), // Largest first Sorted = Table.Sort(Typed, {{"weight_pct", Order.Descending}}), // The date of the issuer's file, and the line to cite, on every row Dated = Table.AddColumn(Sorted, "holdings_as_of", each Date.FromText(Fund[holdings_as_of]), type date), Cited = Table.AddColumn(Dated, "cite_as", each Fund[cite_as], type text) in Cited