GitHub PRs and Issues [REST Basic Auth]

This guide shows you how to connect GitHub to PocketQuery using the GitHub REST API and display live GitHub data inside your Confluence pages.

At the end, you'll be able to visualize GitHub data like open pull requests, issues, or commits in a dynamic table.

Preview

Step 1: Create a GitHub Personal Access Token

• Go to https://github.com/settings/tokens and create a new Personal Access Token.

• Make sure the token has read-only permissions for the repositories or orgs you want to access.

• Save the token securely.

Step 2: Create a Datasource in PocketQuery

Open PocketQuery Administration → Datasources, and create a new REST datasource:

Test the connection and save the datasource.

Step 3: Create a Query in PocketQuery

Let’s start by fetching open pull requests for a specific repository.

Replace {owner} and {repo} with your actual GitHub owner and repository name.

Step 4: Create a Template (Velocity)

Use the following Velocity template to render the API result as an interactive table:

#set($tableRows = $PQ.toList($result))
<table class="aui">
  <thead>
    <tr>
      <th>Title</th>
      <th>Author</th>
      <th>Status</th>
      <th>Updated at</th>
      <th>Created at</th>
    </tr>
  </thead>
  <tbody>
  #foreach ($row in $tableRows)		
      <tr>
        <td><a href="$row.html_url">$row.title</a></td>
        <td>$row.get('user.login')</td>
        <td>$row.state</td>
        <td>$row.updated_at</td>
        <td>$row.created_at</td>
      </tr>
  #end
  </tbody>
</table>

This will display all open pull requests as a live table on your Confluence page.

Sample Use Cases

You can use the GitHub API with PocketQuery to build:

• Sprint dashboards: Show PRs, issues, and commits by repo or label

• Contributor boards: List top contributors per repo or org

• Release monitors: Show GitHub Actions or workflow status

• Security watchlists: Display Dependabot alerts across repos

🔗 Useful GitHub API Endpoints

Full documentation: GitHub REST API v3

Why Use PocketQuery for GitHub Integration?

• No plugin development or external server needed

• Secure: uses personal access tokens

• Works in Confluence Cloud and Data Center

• Supports custom tables, filters, dashboards

• Combine GitHub with Jira, SQL, Sentry, and more