{
"_id": "6a13e716acfb0bcc41d2d467",
"Package": "smartsheetr",
"Title": "Access and Write 'Smartsheet' Data using the 'Smartsheet' API\n2.0",
"Version": "0.1.0",
"Authors@R": "person(\"Cole\", \"Johanson\", , \"coldenjohanson@gmail.com\", role = c(\"aut\", \"cre\", \"cph\"))",
"Description": "Interact with the 'Smartsheet' platform through the\n'Smartsheet' API 2.0. . API is an\nacronym for application programming interface; the 'Smartsheet'\nAPI allows users to interact with 'Smartsheet' sheets directly\nwithin R.",
"License": "MIT + file LICENSE",
"Encoding": "UTF-8",
"Roxygen": "list(markdown = TRUE)",
"RoxygenNote": "7.2.3",
"Config/testthat/edition": "3",
"Config/pak/sysreqs": "libicu-dev libssl-dev",
"Repository": "https://cole-johanson.r-universe.dev",
"Date/Publication": "2023-10-27 13:17:22 UTC",
"RemoteUrl": "https://github.com/cole-johanson/smartsheetr",
"RemoteRef": "HEAD",
"RemoteSha": "7c934eddbad75f591416d40e6ecda8c87012c5a5",
"NeedsCompilation": "no",
"Packaged": {
"Date": "2026-05-25 06:04:24 UTC",
"User": "root"
},
"Author": "Cole Johanson [aut, cre, cph]",
"Maintainer": "Cole Johanson ",
"MD5sum": "7ff03548668bd1218cc068564afe966e",
"_user": "cole-johanson",
"_type": "src",
"_file": "smartsheetr_0.1.0.tar.gz",
"_fileid": "69810157a49fb167493277b9b43d8716fad0f036a589026706c03ac80cdd9638",
"_filesize": 125312,
"_sha256": "69810157a49fb167493277b9b43d8716fad0f036a589026706c03ac80cdd9638",
"_created": "2026-05-25T06:04:24.000Z",
"_published": "2026-05-25T06:07:18.255Z",
"_distro": "noble",
"_jobs": [
{
"job": 77664576841,
"time": 144,
"config": "linux-devel-x86_64",
"r": "4.7.0",
"check": "OK",
"artifact": "7192601918"
},
{
"job": 77664576855,
"time": 135,
"config": "linux-release-x86_64",
"r": "4.6.0",
"check": "OK",
"artifact": "7192600507"
},
{
"job": 77664576836,
"time": 129,
"config": "macos-oldrel-arm64",
"r": "4.5.3",
"check": "OK",
"artifact": "7192596399"
},
{
"job": 77664576866,
"time": 136,
"config": "macos-release-arm64",
"r": "4.6.0",
"check": "OK",
"artifact": "7192595381"
},
{
"job": 77664272410,
"time": 193,
"config": "source",
"r": "4.6.0",
"check": "OK",
"artifact": "7192576137"
},
{
"job": 77664576840,
"time": 118,
"config": "wasm-release",
"r": "4.6.0",
"check": "OK",
"artifact": "7192597510"
},
{
"job": 77664576858,
"time": 80,
"config": "windows-devel",
"r": "4.7.0",
"check": "OK",
"artifact": "7192590319"
},
{
"job": 77664576929,
"time": 106,
"config": "windows-oldrel",
"r": "4.5.3",
"check": "OK",
"artifact": "7192595209"
},
{
"job": 77664576837,
"time": 79,
"config": "windows-release",
"r": "4.6.0",
"check": "OK",
"artifact": "7192590349"
}
],
"_buildurl": "https://github.com/r-universe/cole-johanson/actions/runs/26353327850",
"_status": "success",
"_host": "GitHub-Actions",
"_upstream": "https://github.com/cole-johanson/smartsheetr",
"_commit": {
"id": "7c934eddbad75f591416d40e6ecda8c87012c5a5",
"author": "Cole Johanson ",
"committer": "Cole Johanson ",
"message": "CRAN feedback\n",
"time": 1698412642
},
"_maintainer": {
"name": "Cole Johanson",
"email": "coldenjohanson@gmail.com",
"login": "cole-johanson",
"description": "\n",
"uuid": 60905167
},
"_registered": true,
"_dependencies": [
{
"package": "R",
"version": ">= 4.1.0",
"role": "Depends"
},
{
"package": "dplyr",
"role": "Imports"
},
{
"package": "httr",
"role": "Imports"
},
{
"package": "jsonlite",
"role": "Imports"
},
{
"package": "memoise",
"role": "Imports"
},
{
"package": "purrr",
"role": "Imports"
},
{
"package": "rlang",
"role": "Imports"
},
{
"package": "tibble",
"role": "Imports"
},
{
"package": "tidyr",
"role": "Imports"
},
{
"package": "devtools",
"role": "Suggests"
},
{
"package": "knitr",
"role": "Suggests"
},
{
"package": "testthat",
"version": ">= 3.0.0",
"role": "Suggests"
}
],
"_owner": "cole-johanson",
"_selfowned": true,
"_usedby": 0,
"_updates": [],
"_tags": [],
"_stars": 5,
"_contributors": [
{
"user": "cole-johanson",
"count": 21,
"uuid": 60905167
}
],
"_userbio": {
"uuid": 60905167,
"type": "user",
"name": "cole-johanson"
},
"_downloads": {
"count": 303,
"source": "https://cranlogs.r-pkg.org/downloads/total/last-month/smartsheetr"
},
"_devurl": "https://github.com/cole-johanson/smartsheetr",
"_searchresults": 2,
"_rbuild": "4.6.0",
"_assets": [
"extra/citation.cff",
"extra/citation.html",
"extra/citation.json",
"extra/citation.txt",
"extra/contents.json",
"extra/NEWS.html",
"extra/NEWS.txt",
"extra/readme.html",
"extra/readme.md",
"extra/smartsheetr.html",
"manual.pdf"
],
"_homeurl": "https://github.com/cole-johanson/smartsheetr",
"_realowner": "cole-johanson",
"_cranurl": true,
"_releases": [
{
"version": "0.1.0",
"date": "2023-10-28"
}
],
"_exports": [
"random_sheet_name",
"ss_add_columns",
"ss_add_rows",
"ss_column_ids",
"ss_delete_columns",
"ss_delete_rows",
"ss_delete_sheet",
"ss_list_sheet_shares",
"ss_list_sheets",
"ss_list_users",
"ss_read_sheet",
"ss_rename_columns",
"ss_replace_sheet",
"ss_row_ids",
"ss_sheet_share",
"ss_sheetid",
"ss_write_sheet",
"ss_write_sheet_columns"
],
"_help": [
{
"page": "random_sheet_name",
"title": "Get a random sheet name",
"topics": [
"random_sheet_name"
]
},
{
"page": "ss_add_columns",
"title": "Add columns to an existing sheet",
"topics": [
"ss_add_columns"
]
},
{
"page": "ss_add_rows",
"title": "Add rows to a sheet.",
"topics": [
"ss_add_rows"
]
},
{
"page": "ss_api",
"title": "The workhorse function that performs each call to the Smartsheet API",
"topics": [
"ss_api"
]
},
{
"page": "ss_cols_to_dataframe",
"title": "Helper function to take columns data and create a data frame.",
"topics": [
"ss_cols_to_dataframe"
]
},
{
"page": "ss_column_ids",
"title": "List column ids for a given sheet",
"topics": [
"ss_column_ids"
]
},
{
"page": "ss_column_type",
"title": "Return the Smartsheet Column Type that aligns with the R class",
"topics": [
"ss_column_type"
]
},
{
"page": "ss_column_type_to_class",
"title": "Return an empty vector of the correct class from the smartsheet Column Type",
"topics": [
"ss_column_type_to_class"
]
},
{
"page": "ss_delete_columns",
"title": "Delete non-primary columns from a given sheet.",
"topics": [
"ss_delete_columns"
]
},
{
"page": "ss_delete_rows",
"title": "Delete rows from a given sheet",
"topics": [
"ss_delete_rows"
]
},
{
"page": "ss_delete_sheet",
"title": "Delete a smartsheet",
"topics": [
"ss_delete_sheet"
]
},
{
"page": "ss_get",
"title": "Execute curl commands for the Smartsheet API",
"topics": [
"ss_delete",
"ss_get",
"ss_post",
"ss_put"
]
},
{
"page": "ss_list_sheet_shares",
"title": "List share data for a given sheet",
"topics": [
"ss_list_sheet_shares"
]
},
{
"page": "ss_list_sheets",
"title": "Get a data frame describing the smartsheets available",
"topics": [
"ss_list_sheets"
]
},
{
"page": "ss_list_users",
"title": "List smartsheet users",
"topics": [
"ss_list_users"
]
},
{
"page": "ss_read_sheet",
"title": "Reads a Smartsheet sheet into an R data frame",
"topics": [
"ss_read_sheet"
]
},
{
"page": "ss_rename_columns",
"title": "Rename columns",
"topics": [
"ss_rename_columns"
]
},
{
"page": "ss_replace_sheet",
"title": "Replace the contents of a sheet with a new data frame",
"topics": [
"ss_replace_sheet"
]
},
{
"page": "ss_resp_data_to_dataframe",
"title": "Helper to rbind lists in a list into a data frame",
"topics": [
"ss_resp_data_to_dataframe"
]
},
{
"page": "ss_row_ids",
"title": "List row ids for a given sheet",
"topics": [
"ss_row_ids"
]
},
{
"page": "ss_sheet_share",
"title": "Share a sheet with a user",
"topics": [
"ss_sheet_share"
]
},
{
"page": "ss_sheetid",
"title": "Get a smartsheet sheetId from a response",
"topics": [
"ss_sheetid"
]
},
{
"page": "ss_write_sheet",
"title": "Create a sheet",
"topics": [
"ss_write_sheet"
]
},
{
"page": "ss_write_sheet_columns",
"title": "Write the initial columns for the a sheet",
"topics": [
"ss_write_sheet_columns"
]
},
{
"page": "unlist_and_replace_null",
"title": "Helper function to replace NULL values with NA, and unlist, which is useful in converting nested lists to data frames",
"topics": [
"unlist_and_replace_null"
]
},
{
"page": "validate_ss_id",
"title": "Validate or get the sheetID from a numeric/character vector",
"topics": [
"validate_ss_id"
]
}
],
"_readme": "https://github.com/cole-johanson/smartsheetr/raw/HEAD/README.md",
"_rundeps": [
"askpass",
"cachem",
"cli",
"cpp11",
"curl",
"dplyr",
"fastmap",
"generics",
"glue",
"httr",
"jsonlite",
"lifecycle",
"magrittr",
"memoise",
"mime",
"openssl",
"pillar",
"pkgconfig",
"purrr",
"R6",
"rlang",
"stringi",
"stringr",
"sys",
"tibble",
"tidyr",
"tidyselect",
"utf8",
"vctrs",
"withr"
],
"_score": 3.3979400086720375,
"_indexed": true,
"_nocasepkg": "smartsheetr",
"_universes": [
"cole-johanson"
],
"_binaries": [
{
"r": "4.7.0",
"os": "linux",
"version": "0.1.0",
"date": "2026-05-25T06:06:48.000Z",
"distro": "noble",
"commit": "7c934eddbad75f591416d40e6ecda8c87012c5a5",
"fileid": "298d1c14b9112fe43bba3af4bc29edf7cc77241a011a2974ea41d2cc77a3223a",
"status": "success",
"check": "OK",
"buildurl": "https://github.com/r-universe/cole-johanson/actions/runs/26353327850"
},
{
"r": "4.6.0",
"os": "linux",
"version": "0.1.0",
"date": "2026-05-25T06:06:42.000Z",
"distro": "noble",
"commit": "7c934eddbad75f591416d40e6ecda8c87012c5a5",
"fileid": "e74bcbb40d25d89a4acfa11eb52dd2d746e90d651182c64324f3231befce4bc5",
"status": "success",
"check": "OK",
"buildurl": "https://github.com/r-universe/cole-johanson/actions/runs/26353327850"
},
{
"r": "4.5.3",
"os": "mac",
"version": "0.1.0",
"date": "2026-05-25T06:06:22.000Z",
"commit": "7c934eddbad75f591416d40e6ecda8c87012c5a5",
"fileid": "4cb34742bb011d91c5fe502855b591e3e078ec3d53bdb23365e2549695fa6e58",
"status": "success",
"check": "OK",
"buildurl": "https://github.com/r-universe/cole-johanson/actions/runs/26353327850"
},
{
"r": "4.6.0",
"os": "mac",
"version": "0.1.0",
"date": "2026-05-25T06:06:14.000Z",
"commit": "7c934eddbad75f591416d40e6ecda8c87012c5a5",
"fileid": "c4751306e9af47eab75e2c8b7d64829f26302781ba1326b59a7d59e341a1b669",
"status": "success",
"check": "OK",
"buildurl": "https://github.com/r-universe/cole-johanson/actions/runs/26353327850"
},
{
"r": "4.6.0",
"os": "wasm",
"version": "0.1.0",
"date": "2026-05-25T06:06:36.000Z",
"commit": "7c934eddbad75f591416d40e6ecda8c87012c5a5",
"fileid": "54281cde96b0b7f772d09c34284e34a0e0bbd5ed4c30bd5f97dd2729668ecf11",
"status": "success",
"buildurl": "https://github.com/r-universe/cole-johanson/actions/runs/26353327850"
},
{
"r": "4.7.0",
"os": "win",
"version": "0.1.0",
"date": "2026-05-25T06:05:41.000Z",
"commit": "7c934eddbad75f591416d40e6ecda8c87012c5a5",
"fileid": "5c1be59c4ce095bfcab937e0d5b874e4fab4d47e4b960fc64fdc4c8a49482c2c",
"status": "success",
"check": "OK",
"buildurl": "https://github.com/r-universe/cole-johanson/actions/runs/26353327850"
},
{
"r": "4.5.3",
"os": "win",
"version": "0.1.0",
"date": "2026-05-25T06:06:07.000Z",
"commit": "7c934eddbad75f591416d40e6ecda8c87012c5a5",
"fileid": "0924ce47eb2e050803aa49cab6cba1caa284ae812fd92968441d9d0470be71ff",
"status": "success",
"check": "OK",
"buildurl": "https://github.com/r-universe/cole-johanson/actions/runs/26353327850"
},
{
"r": "4.6.0",
"os": "win",
"version": "0.1.0",
"date": "2026-05-25T06:05:41.000Z",
"commit": "7c934eddbad75f591416d40e6ecda8c87012c5a5",
"fileid": "d46871cd43c1917fac60d3e55b4a6bdd5f3f3d4812f5e7334b1128b27972e1cd",
"status": "success",
"check": "OK",
"buildurl": "https://github.com/r-universe/cole-johanson/actions/runs/26353327850"
}
]
}