You can use Microsoft Graph to allow web and mobile applications to read and modify Excel workbooks stored in OneDrive for Business, SharePoint site or Group drive.
Emit new event each time the specified coupon event(s) occur
Emit new event each time the specified customer event(s) occur
Emit new event each time the specified order event(s) occur
Emit new event each time the specified product event(s) occur
Adds rows to the end of specific table. See the documentation
Update the properties of tablerow object. (Only for work or school account)
See the documentation
The Microsoft Excel API on Pipedream allows you to automate spreadsheet tasks, manipulate data, and integrate Excel with other apps and services. Through Pipedream, you can create serverless workflows that react to events, perform operations on Excel files like reading, writing, updating cells, and managing worksheets. This API turns Excel into a powerful tool for data analysis, report generation, and task automation without manual intervention.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
microsoft_excel: {
type: "app",
app: "microsoft_excel",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://graph.microsoft.com/v1.0/me`,
headers: {
Authorization: `Bearer ${this.microsoft_excel.$auth.oauth_access_token}`,
},
})
},
})
WooCommerce is a customizable, open-source eCommerce platform built on WordPress. With the WooCommerce API, you can tap into the heart of your eCommerce store to read, create, update, and delete products, orders, and customers. On Pipedream, you can harness this API to automate routine tasks, sync data across platforms, and enhance customer experiences. By connecting WooCommerce to a wide array of apps and services, you can streamline operations, trigger personalized marketing, and analyze your sales data with greater ease.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
woocommerce: {
type: "app",
app: "woocommerce",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://${this.woocommerce.$auth.url}/wp-json/wc/v2/orders`,
auth: {
username: `${this.woocommerce.$auth.key}`,
password: `${this.woocommerce.$auth.secret}`,
},
})
},
})