with Database and PostGrid Print & Mail?
Create a new contact in PostGrid. See the documentation
Creates a new letter in PostGrid. See the documentation
Creates a new postcard in PostGrid. See the documentation
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.
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;
},
};
The PostGrid Print & Mail API offers seamless print and mail solutions, enabling the automation of sending personalized letters, postcards, checks, and more. With this API, you can systematize direct mail campaigns, transactional mailings, or on-demand dispatch without managing printing infrastructure. In Pipedream, you can harness this capability to interlace PostGrid with an array of other services and triggers, creating workflows that respond to events such as form submissions, scheduled campaigns, or customer actions.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
postgrid: {
type: "app",
app: "postgrid",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://api.postgrid.com/print-mail/v1/contacts`,
headers: {
"x-api-key": `${this.postgrid.$auth.api_key}`,
},
})
},
})