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.5)smartsheetr_0.1.0.zip(r-4.4)smartsheetr_0.1.0.zip(r-4.3)
smartsheetr_0.1.0.tgz(r-4.4-any)smartsheetr_0.1.0.tgz(r-4.3-any)
smartsheetr_0.1.0.tar.gz(r-4.5-noble)smartsheetr_0.1.0.tar.gz(r-4.4-noble)
smartsheetr_0.1.0.tgz(r-4.4-emscripten)smartsheetr_0.1.0.tgz(r-4.3-emscripten)
smartsheetr.pdf |smartsheetr.html✨
smartsheetr/json (API)
NEWS

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

Peer review:

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

On CRAN:

3.40 score 5 stars 2 scripts 133 downloads 18 exports 31 dependencies

Last updated 1 years agofrom:7c934eddba. Checks:OK: 7. Indexed: yes.

TargetResultDate
Doc / VignettesOKNov 22 2024
R-4.5-winOKNov 22 2024
R-4.5-linuxOKNov 22 2024
R-4.4-winOKNov 22 2024
R-4.4-macOKNov 22 2024
R-4.3-winOKNov 22 2024
R-4.3-macOKNov 22 2024

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:askpasscachemclicpp11curldplyrfansifastmapgenericsgluehttrjsonlitelifecyclemagrittrmemoisemimeopensslpillarpkgconfigpurrrR6rlangstringistringrsystibbletidyrtidyselectutf8vctrswithr

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