acdh-baserow-pyutils

acdh-baserow-pyutils

a python client for baserow

install

pip install acdh-baserow-pyutils

how to use

Have a look into tests/test_baserow_client.py

dump all tables of a given database into JSON-FILES

import os
from acdh_baserow_pyutils import BaseRowClient

# store baserow credentials as ENV-Variables
BASEROW_USER = os.environ.get("BASEROW_USER")
BASEROW_PW = os.environ.get("BASEROW_PW")
BASEROW_TOKEN = os.environ.get("BASEROW_TOKEN") # you need to create a token via baserow
DATABASE_ID = "41426" # you can get this ID from Baserow
BASEROW_URL="https://my-custom-baserow/api/

# initialize the client to baserows hosted instance
br_client = BaseRowClient(BASEROW_USER, BASEROW_PW, BASEROW_TOKEN)

# to initialize the client to some other baserow instance, you need to pass in br_base_url=BASEROW_URL

br_client = BaseRowClient(BASEROW_USER, BASEROW_PW, BASEROW_TOKEN, br_base_url="https://api.baserow.io/api/",)


# writes all tables from Database as json.files into a folder 'out' (the folder needs to exist!) and returns a list of the file names
files = br_client.dump_tables_as_json(DATABASE_ID, folder_name='out')
print(files)
# ['out/place.json', 'out/person.json', 'out/profession.json']