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.
Popular PostgreSQL and GitHub Legacy Actions#
Create Repo Issue
Creates an issue in a repository.
Get Repo
Gets a repository's details.
Search Issues or Pull Requests
Searches for issues or pull requests by state and keyword.
Create Fork
Creates a fork given a repository for the authenticated user.
Create Gist
Creates a new gist with one or more files.
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}`,
},
})