MySQL is an open-source relational database management system.
Search for new orders which are PAID and AWAITING_PROCESSING. Emits events for each order and sets order fulfilment status to PROCESSING
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
Update the Status of an Ecwid Order. Makes use of the Update Order API.
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);
},
});
Ecwid's API offers dynamic access to an online store's data, allowing for the automation of tasks such as inventory management, order processing, and customer data analysis. With Pipedream's serverless integration platform, you can create custom workflows that trigger actions within Ecwid or synchronize data across various other apps and services. This capability can streamline operations, save time, and reduce the likelihood of human error.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
ecwid: {
type: "app",
app: "ecwid",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://app.ecwid.com/api/v3/${this.ecwid.$auth.storeId}/profile`,
headers: {
Authorization: `Bearer ${this.ecwid.$auth.client_secret}`,
},
})
},
})