Electricity tariff with a loyalty program allowing every electricity customer to do micro investments into renewable energy generation facilities
Emit new event when you add or modify a new row in a table. See the docs here
Emit new event when new rows are returned from a custom query. See the docs here
Emit new event when a new table is added to a database. See the docs here
The Corrently API offers a suite of services related to green energy, including insights on electricity consumption, cost forecasting, and localized energy generation data. With Corrently, you can pull real-time data to drive sustainability initiatives, create cost-optimization strategies for energy usage, and foster eco-friendly practices. Leveraging this API within Pipedream allows for automated workflows that can turn this data into actionable insights, integrate with smart home devices, manage energy budgets, and even shift usage to times when the grid is greener and electricity cheaper.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
corrently: {
type: "app",
app: "corrently",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://api.corrently.io/v2.0/stromkonto/balances`,
params: {
account: `${this.corrently.$auth.account}`,
},
})
},
})
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);
},
});