Database
Query a SQL Database with a built-in SQL editor and Schema Explorer
Integrate the Database API with the Twilio SendGrid API
Setup the Database API trigger to run a workflow which integrates with the Twilio SendGrid API. Pipedream's integration platform allows you to integrate Database and Twilio SendGrid remarkably fast. Free for developers.
Trusted by 1,000,000+ developers from startups to Fortune 500 companies
Popular Database and Twilio SendGrid Actions#
Allows you to add one or more email addresses to the global suppressions group. See the docs here
Allows you to create a new contact list. See the docs here
Allows you to delete all email addresses on your blocks list. See the docs here
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 Twilio SendGrid#
The Twilio SendGrid API opens up a world of possibilities for email automation, enabling you to send emails efficiently and track their performance. With this API, you can programmatically create and send personalized email campaigns, manage contacts, and parse inbound emails for data extraction. When you harness the power of Pipedream, you can connect SendGrid to hundreds of other apps to automate workflows, such as triggering email notifications based on specific actions, syncing email stats with your analytics, or handling incoming emails to create tasks or tickets.
Connect Twilio SendGrid#
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
sendgrid: {
type: "app",
app: "sendgrid",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://api.sendgrid.com/v3/user/account`,
headers: {
Authorization: `Bearer ${this.sendgrid.$auth.api_key}`,
},
})
},
})
Community Posts#
Trusted by 1,000,000+ developers from startups to Fortune 500 companies