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

[Up] [Top]

Documentation for package ‘smartsheetr’ version 0.1.0

Help Pages

random_sheet_name Get a random sheet name
ss_add_columns Add columns to an existing sheet
ss_add_rows Add rows to a sheet.
ss_api The workhorse function that performs each call to the Smartsheet API
ss_cols_to_dataframe Helper function to take columns data and create a data frame.
ss_column_ids List column ids for a given sheet
ss_column_type Return the Smartsheet Column Type that aligns with the R class
ss_column_type_to_class Return an empty vector of the correct class from the smartsheet Column Type
ss_delete Execute curl commands for the Smartsheet API
ss_delete_columns Delete non-primary columns from a given sheet.
ss_delete_rows Delete rows from a given sheet
ss_delete_sheet Delete a smartsheet
ss_get Execute curl commands for the Smartsheet API
ss_list_sheets Get a data frame describing the smartsheets available
ss_list_sheet_shares List share data for a given sheet
ss_list_users List smartsheet users
ss_post Execute curl commands for the Smartsheet API
ss_put Execute curl commands for the Smartsheet API
ss_read_sheet Reads a Smartsheet sheet into an R data frame
ss_rename_columns Rename columns
ss_replace_sheet Replace the contents of a sheet with a new data frame
ss_resp_data_to_dataframe Helper to rbind lists in a list into a data frame
ss_row_ids List row ids for a given sheet
ss_sheetid Get a smartsheet sheetId from a response
ss_sheet_share Share a sheet with a user
ss_write_sheet Create a sheet
ss_write_sheet_columns Write the initial columns for the a sheet
unlist_and_replace_null Helper function to replace NULL values with NA, and unlist, which is useful in converting nested lists to data frames
validate_ss_id Validate or get the sheetID from a numeric/character vector