with Canny and PostgreSQL?
Emit new event when a new comment is created. See the documentation
Emit new event when a new vote is created. See the documentation
Emit new event when a new column is added to a table. See the documentation
Emit new event when the status of a post is changed. See the documentation
Emit new event when a row is added or modified. See the documentation
Change the status of a post. See the documentation
Create a comment. See the documentation
Deletes a row or rows from a table. See the documentation
Create a post. See the documentation
The Canny API provides programmatic access to Canny's customer feedback management platform. With it, you can automate the collection, analysis, and response to user feedback. This includes creating posts, voting on behalf of users, fetching boards, and managing comments and tags. Such integrations can streamline how you gather insights and act on user suggestions, making sure the voice of the customer is heard and addressed efficiently.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
canny: {
type: "app",
app: "canny",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://canny.io/api/v1/boards/list`,
params: {
apiKey: `${this.canny.$auth.api_key}`,
},
})
},
})
On Pipedream, you can leverage the PostgreSQL app to create workflows that automate database operations, synchronize data across platforms, and react to database events in real-time. Think handling new row entries, updating records from webhooks, or even compiling reports on a set schedule. Pipedream's serverless platform provides a powerful way to connect PostgreSQL with a variety of apps, enabling you to create tailored automation that fits your specific needs.
import postgresql from "@pipedream/postgresql"
export default defineComponent({
props: {
postgresql,
},
async run({ steps, $ }) {
// Component source code:
// https://github.com/PipedreamHQ/pipedream/tree/master/components/postgresql
const queryObj = {
text: "SELECT NOW()",
values: [], // Ignored since query does not contain placeholders
};
return await this.postgresql.executeQuery(queryObj);
},
})