let // Read NVDA's file (one GET, no key), naming your own project Stock = Json.Document(Web.Contents( "https://tickerinside.com/api/v1/sec/nvda.json", [Headers = [#"User-Agent" = "MyProject/1.0 (+https://example.com)"]])), // The etf_ownership block holds the figure Own = Stock[etf_ownership], // holdings_dates is null too when no figure is published Dates = Own[holdings_dates], // One row. pct_lower_bound is null when no figure is published, and // refused says why Result = Table.FromRecords({[ pct_lower_bound = Own[pct_lower_bound], basis = Own[basis], refused = Own[refused], shares_held = Own[shares_held], shares_outstanding = Own[shares_outstanding], shares_outstanding_as_of = Own[shares_outstanding_as_of], holdings_oldest = if Dates = null then null else Dates[oldest], holdings_newest = if Dates = null then null else Dates[newest], cite_as = Own[cite_as]]}) in Result