GraphQL Query Example

graphql.ps1

$query = @"
query {
    organization(login: "powershell") {
      name
      url
      repository(name: "powershell") {
        name
        pullRequests(last: 20, states: [OPEN]) {
          edges {
            node {
              title
              comments(last: 20) {
                edges {
                  node {
                    author {
                      login
                    }
                  }
                }
              }
            }
          }
        }
      }
    }
  }
"@

$body = @{query=$query} | ConvertTo-Json
$data = Invoke-RestMethod https://api.github.com/graphql -Authentication OAuth -Token (Get-Secret GitHub) -Body $body -Method Post
$data.data.organization.repository.pullRequests.edges.node | Format-Table title,
    @{
        label = "comments";
        expression = {
            $_.comments.edges.count
        }
    },
    @{
        label = "authors";
        expression = {
            [string]::Join(",", (
                $_.comments.edges.node.author.login | Select-Object -Unique | Sort-Object
            ))
        }
    }