Build apps that scale with managed and intelligent SQL database in the cloud.
Executes a SQL query and returns the results. See the documentation
Converts a Lead into a Contact or an Account. See the documentation
Inserts a new row in a table. See the documentation
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);
},
});
The Zoho CRM API enables the manipulation and retrieval of data within Zoho CRM, a platform for managing your sales, marketing, support, and inventory in a single system. Leveraging this on Pipedream, you can automate tasks like syncing contacts, updating lead statuses, or creating custom CRM operations that trigger actions in other apps. Pipedream's serverless platform allows for real-time data processing, transforming, and orchestrating workflows that respond to events in Zoho CRM with minimal latency.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
zoho_crm: {
type: "app",
app: "zoho_crm",
}
},
async run({steps, $}) {
return await axios($, {
url: `${this.zoho_crm.$auth.api_domain}/crm/v2/users?type=CurrentUser`,
headers: {
"Authorization": `Zoho-oauthtoken ${this.zoho_crm.$auth.oauth_access_token}`,
},
})
},
})