Download Gists from Github API to Power Query

gistfile1.txt

let
    // Your GitHub token for authentication
    github_token = "Your Github Token Here",
    
    // GitHub API URL for listing your gists
    api_url = "https://api.github.com/gists",
    
    // Make the API request
    Source = Json.Document(Web.Contents(api_url, 
        [Headers=[#"Authorization"="token " & github_token]])),
        
    // Transform the JSON to table (customize this part as needed)
    ToTable = Table.FromList(Source, Splitter.SplitByNothing())
in
    ToTable