PostgreSQL

The World's Most Advanced Open Source Relational Database

Go to site

Integrate the PostgreSQL API with the GitHub API

Setup the PostgreSQL API trigger to run a workflow which integrates with the GitHub API. Pipedream's integration platform allows you to integrate PostgreSQL and GitHub remarkably fast. Free for developers.

Create Repo Issue

Creates an issue in a repository.

 
Try it
Get Repo

Gets a repository's details.

 
Try it
Search Issues or Pull Requests

Searches for issues or pull requests by state and keyword.

 
Try it
Create Fork

Creates a fork given a repository for the authenticated user.

 
Try it
Create Gist

Creates a new gist with one or more files.

 
Try it

Connect PostgreSQL

const { Client } = require('pg')

const { host, user, password, port, database } = auths.postgresql

const client = new Client({
  host,
  database,
  user,
  password,
  port,
})

await client.connect()
this.results = (await client.query("SELECT NOW()")).rows
await client.end()

Connect GitHub

return await require("@pipedreamhq/platform").axios(this, {
  url: `https://api.github.com/user`,
  headers: {
    Authorization: `Bearer ${auths.github.oauth_access_token}`,
  },
})