What do you want to automate
with Keen.io and Database?
Prompt, edit and deploy AI agents that connect to Keen.io, Database and 2,500+ other apps in seconds.
Trusted by 1,000,000+ developers from startups to Fortune 500 companies
Overview of Keen.io#
The Keen.io API provides robust analytics and data collection capabilities. On Pipedream, you can harness this power to create custom event tracking and analysis workflows, automate reporting, and drive data-informed decisions. With Keen.io's ability to capture, analyze, and embed event data, you can set up workflows on Pipedream that react to data streams in real-time, aggregate metrics, or trigger actions in other apps based on insights.
Connect Keen.io#
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
keen_io: {
type: "app",
app: "keen_io",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://api.keen.io/3.0/projects/${this.keen_io.$auth.project_id}/events`,
params: {
api_key: `${this.keen_io.$auth.key}`,
},
})
},
})
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;
},
};
Trusted by 1,000,000+ developers from startups to Fortune 500 companies