with Letterdrop and MySQL?
Emit new event when a new post gets published on Letterdrop. After creating the source, access Letterdrop UI, go to Settings > Integrations > API and Webhooks > Webhook Endpoints > Setup endpoints and add your source endpoint URL to the respective webhook endpoint. See the documentation
Emit new event when a new subscriber gets added on Letterdrop. After creating the source, access Letterdrop UI, go to Settings > Integrations > API and Webhooks > Webhook Endpoints > Setup endpoints and add your source endpoint URL to the respective webhook endpoint. See the documentation
Emit new event when you add a new column to a table. See the docs here
Emit new event when you add or modify a new row in a table. See the docs here
Emit new event when you add a new row to a table. See the docs here
Adds a new subscriber to your Letterdrop publication. See the documentation
Drafts a new blog post in your workspace with the required title and content, and optional images and tags. See the documentation
Adds a new row. See the docs here
Delete an existing row. See the docs here
The Letterdrop API enables automated content marketing workflows, streamlining the process of creating, delivering, and tracking email campaigns and newsletters. By harnessing this API within Pipedream, users can craft data-driven, personalized content distribution strategies, integrate with CRMs for targeted outreach, and monitor engagement metrics to refine future campaigns. In essence, it's a tool that can help you engage your audience efficiently by automating repetitive content operations and aggregating performance data for actionable insights.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
letterdrop: {
type: "app",
app: "letterdrop",
}
},
async run({steps, $}) {
const data = {
"query": `Pipedream`,
"offset": `0`,
"limit": `5`,
}
return await axios($, {
method: "post",
url: `https://api.letterdrop.com/api/v1/posts`,
headers: {
"api-key": `${this.letterdrop.$auth.api_key}`,
},
data,
})
},
})
The MySQL application on Pipedream enables direct interaction with your MySQL databases, allowing you to perform CRUD operations—create, read, update, delete—on your data with ease. You can leverage these capabilities to automate data synchronization, report generation, and event-based triggers that kick off workflows in other apps. With Pipedream's serverless platform, you can connect MySQL to hundreds of other services without managing infrastructure, crafting complex code, or handling authentication.
import mysql from '@pipedream/mysql';
export default defineComponent({
props: {
mysql,
},
async run({steps, $}) {
// Component source code:
// https://github.com/PipedreamHQ/pipedream/tree/master/components/mysql
const queryObj = {
sql: "SELECT NOW()",
values: [], // Ignored since query does not contain placeholders
};
return await this.mysql.executeQuery(queryObj);
},
});