let Source = Json.Document( Web.Contents( "https://sec-event-intelligence.p.rapidapi.com", [ RelativePath = "v1/sec/watchlist/changes", Query = [ tickers = "AAPL,MSFT", since = "2026-07-01", limit = "10" ], Headers = [ #"x-rapidapi-host" = "sec-event-intelligence.p.rapidapi.com", #"x-rapidapi-key" = RapidAPIKey ] ] ) ), Groups = Source[data], GroupTable = Table.FromRecords(Groups, null, MissingField.UseNull), ExpandedChanges = Table.ExpandListColumn(GroupTable, "changes"), ExpandedChange = Table.ExpandRecordColumn( ExpandedChanges, "changes", {"changeType", "observedAt", "filing"}, {"changeType", "observedAt", "filing"} ), ExpandedFiling = Table.ExpandRecordColumn( ExpandedChange, "filing", {"companyName", "form", "filedAt", "accessionNo", "filingUrl"}, {"companyName", "form", "filedAt", "accessionNo", "filingUrl"} ) in ExpandedFiling