The Baserow API allows you to interact programmatically with Baserow, an open-source no-code database tool. With its API, you can automate database operations such as creating, reading, updating, and deleting records. Moreover, it's possible to manage databases, tables, fields, and rows, or integrate with external services to enrich or move data in real-time. Leveraging Pipedream’s capabilities, you can trigger workflows from a variety of events and connect Baserow to numerous apps for seamless data processes.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
baserow: {
type: "app",
app: "baserow",
}
},
async run({steps, $}) {
return await axios($, {
url: `${this.baserow.$auth.base_api_url}/database/rows/table/[TABLE_ID]/`,
headers: {
"Authorization": `Token ${this.baserow.$auth.token}`,
},
})
},
})
Real-time Lead Capture to CRM: Capture leads in real-time from a landing page form and feed them directly into a Baserow database. Use Pipedream to trigger a workflow that enriches these leads with additional data points from external APIs (like Clearbit for business intelligence) and then syncs them to a CRM like Salesforce, ensuring your sales team always has the most up-to-date lead information.
Automated Support Ticket Triage: Automatically create support tickets in Baserow based on incoming customer support emails or chat messages from platforms like Zendesk. Use Pipedream to analyze the sentiment of the inquiry with a tool like the IBM Watson API and prioritize or categorize the ticket accordingly, streamlining your customer service operations and response times.
Inventory Management Sync: Synchronize your inventory management by updating Baserow records each time a sale is made on an e-commerce platform like Shopify. Set up a Pipedream workflow that listens for new order webhooks from Shopify, updates the inventory count in Baserow, and if the stock falls below a threshold, triggers reorder notifications to suppliers via email or SMS, keeping inventory levels optimal with minimal manual intervention.
Emit new event when a table row is created, updated or deleted, according to the selected event types
Baserow uses API keys for authentication. When you connect your Baserow account, Pipedream securely stores the keys so you can easily authenticate to Baserow APIs in both code and no-code steps.
Baserow uses a simple token based authentication. You need to generate at least one API token in your settings.