let // Read the list of covered funds (one GET, no key), naming your own project Doc = Json.Document(Web.Contents( "https://tickerinside.com/api/v1/funds.json", [Headers = [#"User-Agent" = "MyProject/1.0 (+https://example.com)"]])), // One row per fund read from its issuer's own file: t is the ticker, // n the name, c the category, er the expense ratio, p the positions Funds = Table.SelectColumns( Table.FromRecords(Doc[funds], null, MissingField.UseNull), {"t", "n", "c", "er", "p"}), Named = Table.RenameColumns(Funds, {{"t", "ticker"}, {"n", "name"}, {"c", "category"}, {"er", "expense_ratio"}, {"p", "positions"}}), // The date of the data, on every row Dated = Table.AddColumn(Named, "as_of", each Date.FromText(Doc[as_of]), type date) in Dated