Database
Query a SQL Database with a built-in SQL editor and Schema Explorer
Integrate the Database API with the Stripe API
Setup the Database API trigger to run a workflow which integrates with the Stripe API. Pipedream's integration platform allows you to integrate Database and Stripe remarkably fast. Free for developers.
Trusted by 1,000,000+ developers from startups to Fortune 500 companies
Popular Database and Stripe Actions#
Cancel a payment intent. Once canceled, no additional charges will be made by the payment intent and any operations on the payment intent will fail with an error. For payment intents with status=requires_capture, the remaining amount_capturable will automatically be refunded. See the docs for more information
Cancel or reverse a payout. A payout can be canceled only if it has not yet been paid out. A payout can be reversed only if it has already been paid out. Funds will be refunded to your available balance. See the docs for more information
Capture the funds of an existing uncaptured payment intent. See the docs for more information
Confirm that your customer intends to pay with current or provided payment method. Upon confirmation, Stripe will attempt to initiate a payment. See the docs for more information
Overview of Database#
The Database API on Pipedream allows users to execute SQL commands directly within workflows, enabling rich and dynamic data manipulation and storage. It supports PostgreSQL, MySQL, and SQLite, making it a versatile option for managing data across various database systems. With this API, users can perform tasks such as data insertion, querying, updates, and deletions, directly within their automations, facilitating real-time data processing and integration across multiple platforms.
Connect Database#
import postgresql from "@pipedream/postgresql";
export default {
props: {
postgresql,
sql: {
type: "sql",
auth: {
app: "postgresql",
},
label: "PostreSQL Query",
},
},
async run({ $ }) {
const args = this.postgresql.executeQueryAdapter(this.sql);
const data = await this.postgresql.executeQuery(args);
return data;
},
};
Overview of Stripe#
The Stripe API is a powerful tool for managing online payments, subscriptions, and invoices. With Pipedream, you can leverage this API to automate payment processing, monitor transactions, and sync billing data with other services. Pipedream's no-code platform allows for quick integration and creation of serverless workflows that react to Stripe events in real-time. For instance, you might automatically update customer records, send personalized emails after successful payments, or escalate failed transactions to your support team.
Connect Stripe#
import stripe from 'stripe'
export default defineComponent({
props: {
stripe: {
type: "app",
app: "stripe",
}
},
async run({steps, $}) {
const client = stripe(this.stripe.$auth.api_key)
return await client.accounts.list({ limit: 1 })
},
})
Trusted by 1,000,000+ developers from startups to Fortune 500 companies