Build apps that scale with managed and intelligent SQL database in the cloud.
Executes a SQL query and returns the results. See the documentation
Adds a product or products to a custom collection or collections. See the docs
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 Shopify Admin REST & GraphQL API unleashes a myriad of possibilities to automate and enhance online store operations. It provides programmatic access to Shopify functionalities, allowing users to manage products, customers, orders, and more. Leveraging the Shopify Admin API within Pipedream, developers can create custom workflows that automate repetitive tasks, sync data across platforms, and respond dynamically to events in Shopify.
This integration can be used as a custom app on your store, or for automating actions on behalf of merchants through your Shopify app.
Looking for integrating into the Shopify Partner API for your apps, themes or referrals? Check out our Shopify Partner API integration.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
shopify_developer_app: {
type: "app",
app: "shopify_developer_app",
}
},
async run({steps, $}) {
const data = {
"query": `{
shop {
id
name
email
}
}`,
}
return await axios($, {
method: "post",
url: `https://${this.shopify_developer_app.$auth.shop_id}.myshopify.com/admin/api/2024-04/graphql.json`,
headers: {
"X-Shopify-Access-Token": `${this.shopify_developer_app.$auth.access_token}`,
"Content-Type": `application/json`,
},
data,
})
},
})