{"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 'Smartsheet'\nAPI 2.0. . API is an acronym for\napplication programming interface; the 'Smartsheet' API allows users to\ninteract with 'Smartsheet' sheets directly within R.","License":"MIT + file LICENSE","Encoding":"UTF-8","RoxygenNote":"7.2.3","Depends":"R (>= 4.1.0)","Imports":"dplyr, httr, jsonlite, memoise, purrr, rlang, tibble, tidyr","Suggests":"devtools, knitr, testthat (>= 3.0.0)","Config/testthat/edition":"3","NeedsCompilation":"no","Packaged":"2023-10-27 13:20:56 UTC; cjohanson","Author":"Cole Johanson [aut, cre, cph]","Maintainer":"Cole Johanson ","Repository":"CRAN","Date/Publication":"2023-10-28 15:00:12 UTC","repoType":"cran","tarballUrl":"ftp://cran.r-project.org/pub/R/src/contrib/smartsheetr_0.1.0.tar.gz","jsonAuthors":[{"name":"Cole Johanson","email":"coldenjohanson@gmail.com","maintainer":true}],"readme":"\n\n\n# smartsheetr\n\n\n\n[![R-CMD-check](https://github.com/cole-johanson/smartsheetr/actions/workflows/R-CMD-check.yaml/badge.svg)](https://github.com/cole-johanson/smartsheetr/actions/workflows/R-CMD-check.yaml)\n\n\nsmartsheetr is an extensible [smartsheet](https://www.smartsheet.com/)\nAPI client. It utilizes the API to push/pull data frames as smartsheet\ndocuments.\n\n## Installation\n\nYou can install the released version of smartsheetr from\n[CRAN](https://cran.r-project.org/) with:\n\n``` r\ninstall.packages(\"smartsheetr\")\n```\n\nYou can install the development version of smartsheetr from\n[GitHub](https://github.com/) with:\n\n``` r\n# install.packages(\"devtools\")\ndevtools::install_github(\"cole-johanson/smartsheetr\")\n```\n\nYou will also need to [generate a smartsheet API\nkey](https://help.smartsheet.com/articles/2482389-generate-API-key) and\nthen add it as a global environment variable:\n\n``` r\nSys.setenv(\"SMARTSHEET_API_TOKEN\" = )\n```\n\n## Example\n\nUpload a sample data frame, and read it back into R:\n\n``` r\nss_mtcars_resp = smartsheetr::ss_write_sheet(\"mtcars\", mtcars)\nss_mtcars_sheetid = smartsheetr::ss_sheetid(ss_mtcars_resp)\nsmartsheetr::ss_list_sheets() |> dplyr::filter(name == 'mtcars')\n#> id name accessLevel\n#> 1 4018535999164292 mtcars OWNER\n#> permalink\n#> 1 https://app.smartsheet.com/sheets/47v6g7p3hGCg9CV4gQRJrF3fmPGwxjhQJ8r92rP1\n#> createdAt modifiedAt\n#> 1 2023-10-25T21:39:59Z 2023-10-25T21:39:59Z\nsmartsheetr::ss_read_sheet(ss_mtcars_sheetid)\n#> # A tibble: 32 × 11\n#> mpg cyl disp hp drat wt qsec vs am gear carb\n#> \n#> 1 21 6 160 110 3.9 2.62 16.5 0 1 4 4\n#> 2 21 6 160 110 3.9 2.88 17.0 0 1 4 4\n#> 3 22.8 4 108 93 3.85 2.32 18.6 1 1 4 1\n#> 4 21.4 6 258 110 3.08 3.22 19.4 1 0 3 1\n#> 5 18.7 8 360 175 3.15 3.44 17.0 0 0 3 2\n#> 6 18.1 6 225 105 2.76 3.46 20.2 1 0 3 1\n#> 7 14.3 8 360 245 3.21 3.57 15.8 0 0 3 4\n#> 8 24.4 4 147. 62 3.69 3.19 20 1 0 4 2\n#> 9 22.8 4 141. 95 3.92 3.15 22.9 1 0 4 2\n#> 10 19.2 6 168. 123 3.92 3.44 18.3 1 0 4 4\n#> # ℹ 22 more rows\n```","jobInfo":{"package":"smartsheetr","version":"0.1.0","parsingStatus":"success","parserVersion":2,"parsedAt":"2023-10-28T16:29:52+0000"}}

Description

Usage

Arguments

Value

Details

Examples