with ActiveCampaign and Microsoft Azure SQL Database?
Triggers when a new row is added or an existing row is updated.
Emit new event each time an automation sends out webhook data.
Emit new event when a contact email address bounces from a sent campaign.
Emit new event when a link from a campaign is clicked (will only run once for each unique link).
Executes a SQL query and returns the results. See the documentation
ActiveCampaign's API provides a powerful interface to automate your email marketing, sales automation, and customer relationship management. By leveraging ActiveCampaign with Pipedream, you can create custom, automated workflows that react to events in real-time, sync data between various platforms, and trigger targeted communication with your users. With the ability to perform actions such as adding contacts, updating deals, and sending out campaigns, the API offers a wide range of possibilities for enhancing your marketing strategies.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
activecampaign: {
type: "app",
app: "activecampaign",
}
},
async run({steps, $}) {
return await axios($, {
url: `${this.activecampaign.$auth.base_url}/api/3/users/me`,
headers: {
"Api-Token": `${this.activecampaign.$auth.api_key}`,
},
})
},
})
The Microsoft Azure SQL Database API allows you to manage and interact with your SQL databases hosted on Azure directly from Pipedream. It provides a serverless way to run SQL queries, manage tables, and handle database management tasks. You can create, read, update, and delete database records, execute stored procedures, and perform a variety of other SQL operations. Leveraging this API on Pipedream enables you to automate workflows, respond to database events in real-time, and integrate with countless other apps and services.
import azure_sql from '@pipedream/azure_sql';
export default defineComponent({
props: {
azure_sql,
},
async run({ steps, $ }) {
// Component source code:
// https://github.com/PipedreamHQ/pipedream/tree/master/components/azure_sql
const queryObj = {
query: "SELECT GETDATE()",
values: [],
};
return await this.azure_sql.executeQuery(queryObj);
},
});