Go to file
Kevin Veen-Birkenbach 13f5ca0f15 Refactored repositorories and API 2023-09-12 16:38:44 +02:00
api Refactored repositorories and API 2023-09-12 16:38:44 +02:00
repository Refactored repositorories and API 2023-09-12 16:38:44 +02:00
.gitignore Ignored file cache 2023-09-04 18:46:18 +02:00
LICENSE Create LICENSE 2023-09-03 20:06:45 +02:00
README.md Updated README.md 2023-09-04 19:12:44 +02:00
controller.py Refactored repositorories and API 2023-09-12 16:38:44 +02:00
main.py Refactored and transformed to mvc modell 2023-09-04 19:08:23 +02:00
matrix_builder.py Refactored repositorories and API 2023-09-12 16:38:44 +02:00
view.py Refactored and transformed to mvc modell 2023-09-04 19:08:23 +02:00

README.md

Baserow IFTO API Wrapper

This repository contains a Python-based API wrapper for Baserow, designed to provide Input, Filter, Transform, and Output (IFTO) functionalities for Baserow data.

Features

  • Fetch all rows from a specific table in Baserow.
  • Fetch all tables from a specific database in Baserow.
  • Fetch all data from a specific database in Baserow.
  • Handle API responses, including error checking and JSON decoding.
  • Merge tables based on references.
  • Command-line interface for fetching data.

Getting Started

Prerequisites

  • Python 3.x
  • requests library. Install it using:
    pip install requests
    

Usage

  1. Clone this repository:

    git clone https://github.com/yourusername/baserow-ifto.git
    cd baserow-ifto
    
  2. Use the script with the required arguments:

    python controller.py BASE_URL API_KEY --database_id DATABASE_ID
    

    Replace BASE_URL, API_KEY, and DATABASE_ID with the appropriate values:

    • BASE_URL: Base URL of your Baserow instance, e.g., https://YOUR_BASEROW_INSTANCE_URL/api/
    • API_KEY: Your Baserow API key.
    • DATABASE_ID: ID of the Baserow database you want to fetch data from.

    The script will fetch all the data from the specified Baserow database and print it to the console.

Additional Options

  • --table_ids: Specify IDs of the Baserow tables you want to fetch data from, separated by commas.
  • --matrix: Merge tables based on references.
  • -v or --verbose: Enable verbose mode for debugging.
  • --linked_fields: Outputs the linked tables.
  • --quiet: Suppress output of JSON.

License

All rights to this code belong in equal parts to Marco Petersen and Kevin Veen-Birkenbach.

Contributing

If you have suggestions, improvements, or any issues, feel free to open an issue or submit a pull request. Your contributions are always welcome!