Pizzly

The simplest, fastest way to integrate your app with an OAuth API

Go to site

Integrate the Pizzly API with the Pipedream API

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

Query SQL

Run a query against data saved to Pipedream's SQL service. To get started, connect your account using your API key (found in your account settings).

 
Try it
Get CSV for a SQL query execution

Retrieve a CSV for the results of a specific SQL query execution.

 
Try it
Get Authentication

Retrieve authentication details for a specific (integration, authId). See the docs: https://github.com/Bearer/Pizzly/wiki/Reference-:-API#retrieve-an-authentication

 
Try it
Get Integration Details

Retrieve an integration's details

 
Try it

Connect Pizzly

const fetch = require('node-fetch')

const { host, secretKey } = auths.pizzly
const authentication = 'Basic ' + Buffer.from(secretKey + ':').toString('base64')

// Make a test API request to Pizzly. Should return a success message
return await (await fetch(`https://${host}/api/`, { headers: { "Authorization": authentication } })).json()

Connect Pipedream

return await require("@pipedreamhq/platform").axios(this, {
  url: `https://api.pipedream.com/v1/users/me`,
  headers: {
    Authorization: `Bearer ${auths.pipedream.api_key}`,
  },
})