Package: smartsheetr 0.1.0

smartsheetr: Access and Write 'Smartsheet' Data using the 'Smartsheet' API 2.0

Interact with the 'Smartsheet' platform through the 'Smartsheet' API 2.0. <https://smartsheet.redoc.ly/>. API is an acronym for application programming interface; the 'Smartsheet' API allows users to interact with 'Smartsheet' sheets directly within R.

Authors:Cole Johanson [aut, cre, cph]

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

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

Bug tracker:https://github.com/cole-johanson/smartsheetr/issues

On CRAN:

Conda:

3.40 score 5 stars 2 scripts 303 downloads 18 exports 30 dependencies

Last updated from:7c934eddba. Checks:9 OK. Indexed: yes.

TargetResultTimeFilesSyslog
linux-devel-x86_64OK144
source / vignettesOK193
linux-release-x86_64OK135
macos-release-arm64OK136
macos-oldrel-arm64OK129
windows-develOK80
windows-releaseOK79
windows-oldrelOK106
wasm-releaseOK118

Exports:random_sheet_namess_add_columnsss_add_rowsss_column_idsss_delete_columnsss_delete_rowsss_delete_sheetss_list_sheet_sharesss_list_sheetsss_list_usersss_read_sheetss_rename_columnsss_replace_sheetss_row_idsss_sheet_sharess_sheetidss_write_sheetss_write_sheet_columns

Dependencies:askpasscachemclicpp11curldplyrfastmapgenericsgluehttrjsonlitelifecyclemagrittrmemoisemimeopensslpillarpkgconfigpurrrR6rlangstringistringrsystibbletidyrtidyselectutf8vctrswithr

Readme and manuals

Help Manual

Help pageTopics
Get a random sheet namerandom_sheet_name
Add columns to an existing sheetss_add_columns
Add rows to a sheet.ss_add_rows
The workhorse function that performs each call to the Smartsheet APIss_api
Helper function to take columns data and create a data frame.ss_cols_to_dataframe
List column ids for a given sheetss_column_ids
Return the Smartsheet Column Type that aligns with the R classss_column_type
Return an empty vector of the correct class from the smartsheet Column Typess_column_type_to_class
Delete non-primary columns from a given sheet.ss_delete_columns
Delete rows from a given sheetss_delete_rows
Delete a smartsheetss_delete_sheet
Execute curl commands for the Smartsheet APIss_delete ss_get ss_post ss_put
List share data for a given sheetss_list_sheet_shares
Get a data frame describing the smartsheets availabless_list_sheets
List smartsheet usersss_list_users
Reads a Smartsheet sheet into an R data framess_read_sheet
Rename columnsss_rename_columns
Replace the contents of a sheet with a new data framess_replace_sheet
Helper to rbind lists in a list into a data framess_resp_data_to_dataframe
List row ids for a given sheetss_row_ids
Share a sheet with a userss_sheet_share
Get a smartsheet sheetId from a responsess_sheetid
Create a sheetss_write_sheet
Write the initial columns for the a sheetss_write_sheet_columns
Helper function to replace NULL values with NA, and unlist, which is useful in converting nested lists to data framesunlist_and_replace_null
Validate or get the sheetID from a numeric/character vectorvalidate_ss_id