Baserow

Open source online database tool

Go to site
Explore
/
Apps
/
Baserow

Baserow API Integrations

Build and run workflows using the Baserow API. Use 1000s of source-available triggers and actions across 2,000+ apps. Or write custom code to integrate any app or API in seconds.

Overview

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.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
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}`,
      },
    })
  },
})

Choose an API to Connect with Baserow API

1
-
24
of
2,000+
apps by most popular

HTTP / Webhook
HTTP / Webhook
Get a unique URL where you can send HTTP or webhook requests
Node
Node
Anything you can do with Node.js, you can do in a Pipedream workflow. This includes using most of npm's 400,000+ packages.
Python
Python
Anything you can do in Python can be done in a Pipedream Workflow. This includes using any of the 350,000+ PyPi packages available in your Python powered workflows.
OpenAI (ChatGPT)
OpenAI (ChatGPT)
OpenAI is an AI research and deployment company with the mission to ensure that artificial general intelligence benefits all of humanity. They are the makers of popular models like ChatGPT, DALL-E, and Whisper.
Salesforce (REST API)
Salesforce (REST API)
Web services API for interacting with Salesforce
HubSpot
HubSpot
HubSpot's CRM platform contains the marketing, sales, service, operations, and website-building software you need to grow your business.
Zoho CRM
Zoho CRM
Zoho CRM is an online Sales CRM software that manages your sales, marketing, and support in one CRM platform.
Stripe
Stripe
Stripe powers online and in-person payment processing and financial solutions for businesses of all sizes.
Shopify Developer App
Shopify Developer App
Shopify is a user-friendly e-commerce platform that helps small businesses build an online store and sell online through one streamlined dashboard.
WooCommerce
WooCommerce
WooCommerce is the open-source ecommerce platform for WordPress.
Snowflake
Snowflake
A data warehouse built for the cloud
MongoDB
MongoDB
MongoDB is an open source NoSQL database management program.
Supabase
Supabase
Supabase is an open source Firebase alternative.
MySQL
MySQL
MySQL is an open-source relational database management system.
PostgreSQL
PostgreSQL
PostgreSQL is a free and open-source relational database management system emphasizing extensibility and SQL compliance.
AWS
AWS
Amazon Web Services (AWS) offers reliable, scalable, and inexpensive cloud computing services.
Twilio SendGrid
Twilio SendGrid
Send marketing and transactional email through the Twilio SendGrid platform with the Email API, proprietary mail transfer agent, and infrastructure for scalable delivery.
Amazon SES
Amazon SES
Amazon SES is a cloud-based email service provider that can integrate into any application for high volume email automation
Klaviyo
Klaviyo
Email Marketing and SMS Marketing Platform
Zendesk
Zendesk
Zendesk is award-winning customer service software trusted by 200K+ customers. Make customers happy via text, mobile, phone, email, live chat, social media.
ServiceNow
ServiceNow
The smarter way to workflow
Notion
Notion
Notion is a new tool that blends your everyday work apps into one. It's the all-in-one workspace for you and your team.
Slack
Slack
Slack is a channel-based messaging platform. With Slack, people can work together more effectively, connect all their software tools and services, and find the information they need to do their best work — all within a secure, enterprise-grade environment.
Microsoft Teams
Microsoft Teams
Microsoft Teams has communities, events, chats, channels, meetings, storage, tasks, and calendars in one place.

Example Use Cases

  • 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.

Delete Row with Baserow API on New Table from PostgreSQL API
PostgreSQL + Baserow
 
Try it
Update Row with Baserow API on New Requests from HTTP / Webhook API
HTTP / Webhook + Baserow
 
Try it
Update Row with Baserow API on New Item in Feed from RSS API
RSS + Baserow
 
Try it
Update Row with Baserow API on New Message (Instant) from Discord API
Discord + Baserow
 
Try it
Update Row with Baserow API on New Message In Channels (Instant) from Slack API
Slack + Baserow
 
Try it
Create Row with the Baserow API

Create a row See docs here

 
Try it
Delete Row with the Baserow API

Delete a row See docs here

 
Try it
Get Row with the Baserow API

Get a single row See docs here

 
Try it
List Rows with the Baserow API

List a table's rows See docs here

 
Try it
Update Row with the Baserow API

Update a row See docs here

 
Try it

Authentication

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.