{
  "_id": "6abe3be699f7aa8c6aa541cf",
  "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. <https://smartsheet.redoc.ly/>. 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-10-01 10:50:39 UTC",
    "User": "root"
  },
  "Author": "Cole Johanson [aut, cre, cph]",
  "Maintainer": "Cole Johanson <coldenjohanson@gmail.com>",
  "_user": "cole-johanson",
  "_type": "src",
  "_file": "smartsheetr_0.1.0.tar.gz",
  "_fileid": "https://r2.ropensci.org/4a89e58ecfda954ab0de37be3a2e7f195524e22938dae9a8d0a3d1ccb4b7d363",
  "_filesize": 126682,
  "_sha256": "4a89e58ecfda954ab0de37be3a2e7f195524e22938dae9a8d0a3d1ccb4b7d363",
  "_expires": "2027-01-09T10:54:28.000Z",
  "_created": "2026-10-01T10:50:39.000Z",
  "_published": "2026-10-01T10:54:30.113Z",
  "_jobs": [
    {
      "job": 110334521611,
      "time": 149,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "11156042592"
    },
    {
      "job": 110334521703,
      "time": 134,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11156067241"
    },
    {
      "job": 110334521673,
      "time": 164,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "11156137028"
    },
    {
      "job": 110334521724,
      "time": 182,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11156236556"
    },
    {
      "job": 110333431674,
      "time": 194,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11155597344"
    },
    {
      "job": 110334521618,
      "time": 129,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "11155697501"
    },
    {
      "job": 110334521747,
      "time": 71,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "11156330532"
    },
    {
      "job": 110334521720,
      "time": 79,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "11155442888"
    },
    {
      "job": 110334521683,
      "time": 73,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11156092015"
    }
  ],
  "_host": "GitHub-Actions",
  "_buildurl": "https://github.com/r-universe/cole-johanson/actions/runs/36851304726",
  "_status": "success",
  "_upstream": "https://github.com/cole-johanson/smartsheetr",
  "_commit": {
    "id": "7c934eddbad75f591416d40e6ecda8c87012c5a5",
    "author": "Cole Johanson <cjohanson@corcept.com>",
    "committer": "Cole Johanson <cjohanson@corcept.com>",
    "message": "CRAN feedback\n",
    "time": 1698412642
  },
  "_maintainer": {
    "name": "Cole Johanson",
    "email": "coldenjohanson@gmail.com",
    "login": "cole-johanson",
    "description": "\n",
    "uuid": 60905167
  },
  "_distro": "resolute",
  "_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",
    "followers": 0
  },
  "_downloads": {
    "count": 776,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/smartsheetr"
  },
  "_devurl": "https://github.com/cole-johanson/smartsheetr",
  "_searchresults": 2,
  "_rbuild": "4.6.1",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/manual.pdf",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md",
    "extra/smartsheetr.html",
    "LICENSE"
  ],
  "_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-10-01T10:53:45.000Z",
      "distro": "resolute",
      "commit": "7c934eddbad75f591416d40e6ecda8c87012c5a5",
      "fileid": "https://r2.ropensci.org/98b28958b21bb9c42bf2a7c8a63b734ca6440f03cb5f1554e723ac1d3fa1c545",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cole-johanson/actions/runs/36851304726"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "0.1.0",
      "date": "2026-10-01T10:52:56.000Z",
      "distro": "resolute",
      "commit": "7c934eddbad75f591416d40e6ecda8c87012c5a5",
      "fileid": "https://r2.ropensci.org/ea8d0191972486547d7ca46ae1f63c25a007977850b21290d3894fc6c4cb9213",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cole-johanson/actions/runs/36851304726"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.1.0",
      "date": "2026-10-01T10:53:04.000Z",
      "commit": "7c934eddbad75f591416d40e6ecda8c87012c5a5",
      "fileid": "https://r2.ropensci.org/715025fcc209dcebd21425525679172851f112e6c6f606c7ef8ef95ef34bc35f",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cole-johanson/actions/runs/36851304726"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "0.1.0",
      "date": "2026-10-01T10:53:11.000Z",
      "commit": "7c934eddbad75f591416d40e6ecda8c87012c5a5",
      "fileid": "https://r2.ropensci.org/b9da8883de9d33027054201f1f79c5d06178b53bc6e58a7d0b02803f51b9720c",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cole-johanson/actions/runs/36851304726"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.1.0",
      "date": "2026-10-01T10:53:00.000Z",
      "commit": "7c934eddbad75f591416d40e6ecda8c87012c5a5",
      "fileid": "https://r2.ropensci.org/698f8f89a54d7afdac61f6300a1fcc724a1237f08a72692012ef48417fa43361",
      "status": "success",
      "buildurl": "https://github.com/r-universe/cole-johanson/actions/runs/36851304726"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.1.0",
      "date": "2026-10-01T10:51:46.000Z",
      "commit": "7c934eddbad75f591416d40e6ecda8c87012c5a5",
      "fileid": "https://r2.ropensci.org/34539ad22924ba6af2682c68c0d36dbf31550b1dbacd8b5753e46ff5f6b8f633",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cole-johanson/actions/runs/36851304726"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.1.0",
      "date": "2026-10-01T10:51:53.000Z",
      "commit": "7c934eddbad75f591416d40e6ecda8c87012c5a5",
      "fileid": "https://r2.ropensci.org/41f95946122937936bbf0b7a3b24055698e37b9ef9f34b5ae591a956af250848",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cole-johanson/actions/runs/36851304726"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "0.1.0",
      "date": "2026-10-01T10:51:48.000Z",
      "commit": "7c934eddbad75f591416d40e6ecda8c87012c5a5",
      "fileid": "https://r2.ropensci.org/41e8032bf3c893dd1acaf817411ffdc5e6d79531a719fd8e9c54f4d3e1d5d3b4",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cole-johanson/actions/runs/36851304726"
    }
  ]
}