List tables

List tables in the target Grist document

listtables(api)

Arguments

api

A 'gristapi::grist_api'-object

Value

A tibble::tibble() object.

See also

Other function_gristapi: add_records(), countrows(), delete_records(), fetch_table(), listcolumns(), sync_table(), update_records()

Examples

# List the tables in the document
api <- grist_api$new(
  server = 'https://grist.numerique.gouv.fr',
  api_key = Sys.getenv("GRIST_KEY"),
  doc_id = Sys.getenv("GRIST_DOC_TEST")
)
listtables(api)
#> # A tibble: 8 × 7
#>   id             primaryViewId summarySourceTable onDemand rawViewSectionRef
#>   <chr>                  <int>              <int> <lgl>                <int>
#> 1 Mtcars_m                 131                  0 FALSE                  392
#> 2 Mtcars_l                 135                  0 FALSE                  404
#> 3 Iris2                    204                  0 FALSE                  611
#> 4 Mtcars                   244                  0 FALSE                  731
#> 5 Mtcars_osx               267                  0 FALSE                  800
#> 6 Mtcars_windows           269                  0 FALSE                  806
#> 7 Iris                     272                  0 FALSE                  815
#> 8 Mtcars_linux             273                  0 FALSE                  818
#> # ℹ 2 more variables: recordCardViewSectionRef <int>, tableRef <int>