Package: harbouR 0.1.0

Raban Heller

harbouR: Work with Self-Hosted 'SeaTable' Servers and Data Files

An unofficial R client for self-hosted 'SeaTable' servers and for reading and writing 'SeaTable' data files directly. Reads a local '.dtable' export with no server at all, and talks to a self-hosted server over its REST (representational state transfer) application programming interface (API), returning tables, rows, columns and views as tidy 'tibble' objects through a column-type-aware coercion layer. Includes helpers for managing bases and files, converters to and from spreadsheet formats, and an optional 'shiny' explorer for interactive inspection. The 'SeaTable' API is documented at <https://api.seatable.com/>. This is an independent, third-party client: it is not affiliated with, endorsed by, or otherwise connected to SeaTable GmbH, and 'SeaTable' is their trademark, used here only to identify the software the package works with.

Authors:Raban Heller [aut, cre, cph], Paul Elsinghorst [aut], Wiebke Derz [aut], Matthias Ring [aut], Gerhard Achatz [aut], Vinzent Forstmeier [aut]

harbouR_0.1.0.tar.gz
harbouR_0.1.0.zip(r-4.7-any)harbouR_0.1.0.zip(r-4.6-any)harbouR_0.1.0.zip(r-4.5-any)
harbouR_0.1.0.tgz(r-4.6-any)harbouR_0.1.0.tgz(r-4.5-any)
harbouR_0.1.0.tar.gz(r-4.7-any)harbouR_0.1.0.tar.gz(r-4.6-any)
harbouR_0.1.0.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
DESCRIPTION |NEWS
card.svg |card.png
harbouR/json (API)

# Install 'harbouR' in R:
install.packages('harbouR', repos = c('https://cttir.r-universe.dev', 'https://cloud.r-project.org'))

Bug tracker:https://github.com/cttir/harbour/issues

Pkgdown/docs site:https://cttir.github.io

On CRAN:

Conda:

4.22 score 3 scripts 52 exports 23 dependencies

Last updated from:bf35c059d5. Checks:9 OK. Indexed: yes.

TargetResultTimeFilesSyslog
linux-develOK174
source / vignettesOK291
linux-releaseOK182
macos-releaseOK166
macos-oldrelOK143
windows-develOK149
windows-releaseOK131
windows-oldrelOK139
wasm-releaseOK112

Exports:hb_add_columnhb_add_columnshb_add_select_optionhb_append_rowshb_asset_pathhb_attach_filehb_check_credentialshb_clienthb_column_typeshb_create_tablehb_create_viewhb_delete_assethb_delete_columnhb_delete_rowshb_delete_select_optionhb_delete_tablehb_delete_viewhb_download_filehb_dtablehb_duplicate_tablehb_example_metadatahb_example_rowshb_get_rowhb_get_viewhb_list_collaboratorshb_list_columnshb_list_tableshb_list_viewshb_lock_rowshb_metadatahb_pinghb_queryhb_read_csvhb_read_dtablehb_read_tablehb_read_xlsxhb_rename_tablehb_run_explorerhb_server_infohb_unlock_rowshb_update_columnhb_update_rowshb_update_select_optionhb_update_viewhb_upload_filehb_validate_dtablehb_write_csvhb_write_dtablehb_write_xlsxis_harbour_clientis_harbour_dtableis_harbour_metadata

Dependencies:askpassclicpp11curlgenericsgluehttr2jsonlitelifecyclelubridatemagrittropensslpillarpkgconfigR6rlangsystibbletimechangeutf8vctrswithrzip

The harbouR explorer
Open something | The panels | Colour | Next steps
Rendered fromexplorer-app.Rmdusingknitr::rmarkdown

Last update: 2026-11-03
Started: 2026-05-30

Column types and coercion
The mapping table | What the rows look like | Scalars | List-columns | File and image columns | Read-only columns | Empty tables | Every type at once | Next steps
Rendered fromcolumn-types.Rmdusingknitr::rmarkdown

Last update: 2026-10-28
Started: 2026-05-30

Get started with harbouR
Connect | Inspect the base | Read a table | Analyse | Write back | Attach a file | Next steps | Citation | Authors | Trademarks and affiliation | Acknowledgements
Rendered fromharbouR.Rmdusingknitr::rmarkdown

Last update: 2026-10-28
Started: 2026-05-30

Readme and manuals

Help Manual

Help pageTopics
Coerce a dtable's table index to a tibbleas_tibble.harbour_dtable
Coerce harbour metadata to a tibbleas_tibble.harbour_metadata
Conditions signalled by harbouRharbouR-conditions
Add a column to a tablehb_add_column
Add several columns at oncehb_add_columns
Add a single-select optionhb_add_select_option
Append rows to a tablehb_append_rows
Resolve a bundled asset URL to a local filehb_asset_path
Attach a file to a cellhb_attach_file
Check that the client's credentials are acceptedhb_check_credentials
Create a SeaTable clientformat.harbour_client hb_client print.harbour_client
SeaTable column types and how harbouR maps themhb_column_types
Create a tablehb_create_table
Create a viewhb_create_view
Delete an assethb_delete_asset
Delete a columnhb_delete_column
Delete rowshb_delete_rows
Delete a single-select optionhb_delete_select_option
Delete a tablehb_delete_table
Delete a viewhb_delete_view
Download an assethb_download_file
Build a '.dtable' base from data frameshb_dtable
Duplicate a tablehb_duplicate_table
Offline example metadatahb_example_metadata
Offline example rowshb_example_rows
Get a single row by IDhb_get_row
Get a view's settingshb_get_view
List collaborators of the active basehb_list_collaborators
List columns of a tablehb_list_columns hb_list_columns.default hb_list_columns.harbour_client hb_list_columns.harbour_dtable
List the tables in a basehb_list_tables hb_list_tables.default hb_list_tables.harbour_client hb_list_tables.harbour_dtable
List views of a tablehb_list_views hb_list_views.default hb_list_views.harbour_client hb_list_views.harbour_dtable
Lock rowshb_lock_rows
Fetch base metadatahb_metadata
Check that a SeaTable server is reachablehb_ping
Run a SeaTable SQL queryhb_query
Read tables into a new base from CSV fileshb_read_csv
Read a SeaTable '.dtable' filehb_read_dtable
Read a table as a tibblehb_read_table hb_read_table.default hb_read_table.harbour_client hb_read_table.harbour_dtable
Read tables into a new base from an Excel workbookhb_read_xlsx
Rename a tablehb_rename_table
Launch the harbouR explorerhb_run_explorer
Server informationhb_server_info
Unlock rowshb_unlock_rows
Update a columnhb_update_column
Update rows in a tablehb_update_rows
Update a single-select optionhb_update_select_option
Update a viewhb_update_view
Upload a file to SeaTablehb_upload_file
Check a base for problems before writing ithb_validate_dtable
Export a base to CSV fileshb_write_csv
Write a 'harbour_dtable' back to a '.dtable' filehb_write_dtable
Export a base to an Excel workbookhb_write_xlsx
Test whether an object is a harbour clientis_harbour_client
Test whether an object is a harbour dtableis_harbour_dtable
Test whether an object is harbour metadatais_harbour_metadata
Number of tables in a dtablelength.harbour_dtable
Names of the tables in a dtablenames.harbour_dtable
Print a harbour dtableformat.harbour_dtable print.harbour_dtable
Print method for harbour metadataformat.harbour_metadata print.harbour_metadata
Summarise the schema of a dtablesummary.harbour_dtable
Summary of harbour metadatasummary.harbour_metadata