{
  "_id": "6a1eb5c5b25058d4daadddd8",
  "Package": "hRvstAPI",
  "Title": "This is a wrapper for the Harvest REST API v2.",
  "Version": "0.0.0.9000",
  "Authors@R": "person(\n\"Eric\", \"Hunt\",\nemail = \"52219938+eric-hunt@users.noreply.github.com\",\nrole = c(\"aut\", \"cre\"),\ncomment = c(ORCID = \"0000-0002-6891-8294\")\n)",
  "Description": "The foremost function of this package is to act as a\n*convenient* wrapper around the Harvest REST API v2. To that\nend, the package handles credentials either through the system\nkeyring using the `keyring` package (preferred), or through\nenvironment variables written to a local `.Renviron` file.\nCredential handling can be initiated explicitly, but otherwise\nhappens automatically upon making an API request. This package\ntries to make accessing the Harvest API as easy as possible.\nWhile it does allow some tweaking of the actual HTTP request\nvia function arguments, the primary method for accessing API\ndata is to simply select which resource to query (e.g. \"users\"\nwill download all users data). *Note, that the default is to\nonly download \"active\" records.* The reason for this mode of\naccess is that a request usually isn't very big and the typical\nuser will probably want to manipulate the data in a more\nsophisticated manner for some downstream visualization or other\nanalysis. Building on this premise, the secondary function of\nthis package is to manage the long term storage of API data to\nminimize remote requests. This is achieved by storing API data\nin a local SQLite database, for which this package also\nprovides a straightforward way of accessing and updating with\nnew data. There is a companion Shiny application (hRvst) which\nutilizes this wrapper for Harvest API data access, and perhaps\nslightly enhances this package.",
  "License": "MIT + file LICENSE",
  "Encoding": "UTF-8",
  "Roxygen": "list(markdown = TRUE)",
  "RoxygenNote": "7.2.1.9000",
  "Collate": "'access.R' 'params.R' 'creds.R' 'req.R' 'store.R' 'zzz.R'",
  "Config/pak/sysreqs": "cmake make libicu-dev libuv1-dev libssl-dev\nlibx11-dev",
  "Repository": "https://eric-hunt.r-universe.dev",
  "Date/Publication": "2022-09-20 17:49:34 UTC",
  "RemoteUrl": "https://github.com/eric-hunt/hRvstAPI",
  "RemoteRef": "HEAD",
  "RemoteSha": "f8e29ed3e7e25b5fecc9c7b9a2ad09aeb1b5788a",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-06-02 10:39:59 UTC",
    "User": "root"
  },
  "Author": "Eric Hunt [aut, cre] (ORCID: <https://orcid.org/0000-0002-6891-8294>)",
  "Maintainer": "Eric Hunt <52219938+eric-hunt@users.noreply.github.com>",
  "MD5sum": "03494a01fd7b1de4aebe6aafbc87c105",
  "_user": "eric-hunt",
  "_type": "src",
  "_file": "hRvstAPI_0.0.0.9000.tar.gz",
  "_fileid": "523abb9c628ba9d6cdba187d82f614aa4c7206c20fa72b1ee09afbaf1fa3fc5e",
  "_filesize": 129189,
  "_sha256": "523abb9c628ba9d6cdba187d82f614aa4c7206c20fa72b1ee09afbaf1fa3fc5e",
  "_created": "2026-06-02T10:39:59.000Z",
  "_published": "2026-06-02T10:51:49.713Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 79052595611,
      "time": 124,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "WARNING",
      "artifact": "7355500051"
    },
    {
      "job": 79052595650,
      "time": 134,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "WARNING",
      "artifact": "7355502928"
    },
    {
      "job": 79052595649,
      "time": 195,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "WARNING",
      "artifact": "7355665459"
    },
    {
      "job": 79052595677,
      "time": 134,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "WARNING",
      "artifact": "7355603757"
    },
    {
      "job": 79052083238,
      "time": 187,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7355456973"
    },
    {
      "job": 79052595622,
      "time": 109,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7355495188"
    },
    {
      "job": 79052595615,
      "time": 79,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "WARNING",
      "artifact": "7355484956"
    },
    {
      "job": 79052595623,
      "time": 87,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "WARNING",
      "artifact": "7355487574"
    },
    {
      "job": 79052595706,
      "time": 75,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "WARNING",
      "artifact": "7355483330"
    }
  ],
  "_buildurl": "https://github.com/r-universe/eric-hunt/actions/runs/26814301944",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_upstream": "https://github.com/eric-hunt/hRvstAPI",
  "_commit": {
    "id": "f8e29ed3e7e25b5fecc9c7b9a2ad09aeb1b5788a",
    "author": "Eric Hunt <52219938+eric-hunt@users.noreply.github.com>",
    "committer": "Eric Hunt <52219938+eric-hunt@users.noreply.github.com>",
    "message": "added LICENSE\n",
    "time": 1663696174
  },
  "_maintainer": {
    "name": "Eric Hunt",
    "email": "52219938+eric-hunt@users.noreply.github.com",
    "login": "eric-hunt",
    "orcid": "0000-0002-6891-8294",
    "description": "Dad, caffeine addict (see previous), @nebiolabs scientist, rock climber, guitarist.",
    "uuid": 52219938
  },
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 4.1",
      "role": "Depends"
    },
    {
      "package": "assertthat",
      "role": "Imports"
    },
    {
      "package": "bit64",
      "role": "Imports"
    },
    {
      "package": "DBI",
      "role": "Imports"
    },
    {
      "package": "dplyr",
      "role": "Imports"
    },
    {
      "package": "fs",
      "role": "Imports"
    },
    {
      "package": "getPass",
      "role": "Imports"
    },
    {
      "package": "glue",
      "role": "Imports"
    },
    {
      "package": "httr2",
      "role": "Imports"
    },
    {
      "package": "lubridate",
      "role": "Imports"
    },
    {
      "package": "purrr",
      "role": "Imports"
    },
    {
      "package": "readr",
      "role": "Imports"
    },
    {
      "package": "rlang",
      "role": "Imports"
    },
    {
      "package": "RSQLite",
      "role": "Imports"
    },
    {
      "package": "stringr",
      "role": "Imports"
    },
    {
      "package": "tibble",
      "role": "Imports"
    },
    {
      "package": "withr",
      "role": "Imports"
    },
    {
      "package": "keyring",
      "role": "Suggests"
    }
  ],
  "_owner": "eric-hunt",
  "_selfowned": true,
  "_usedby": 0,
  "_updates": [],
  "_tags": [],
  "_stars": 0,
  "_contributors": [
    {
      "user": "eric-hunt",
      "count": 95,
      "uuid": 52219938
    }
  ],
  "_userbio": {
    "uuid": 52219938,
    "type": "user",
    "name": "Eric Hunt",
    "description": "Dad, caffeine addict (see previous), @nebiolabs scientist, rock climber, guitarist."
  },
  "_downloads": {
    "count": 0,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/hRvstAPI"
  },
  "_devurl": "https://github.com/eric-hunt/hrvstapi",
  "_searchresults": 1,
  "_rbuild": "4.6.0",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/hRvstAPI.html",
    "extra/readme.html",
    "extra/readme.md",
    "manual.pdf"
  ],
  "_cranurl": false,
  "_exports": [
    ".agent",
    ".db_path",
    ".rds_path",
    ".service",
    ".url",
    "check_creds",
    "create_db",
    "create_rds",
    "hrvst_acct_id",
    "hrvst_req",
    "hrvst_token",
    "query_db",
    "set_creds",
    "update_db"
  ],
  "_help": [
    {
      "page": "add_creds",
      "title": "Add user credentials to the keyring.",
      "topics": [
        "add_creds"
      ]
    },
    {
      "page": "check_creds",
      "title": "See if and where user credentials exist.",
      "topics": [
        "check_creds"
      ]
    },
    {
      "page": "clear_environment_creds",
      "title": "Delete all hRvstAPI Harvest credentials from the environment.",
      "topics": [
        "clear_environment_creds"
      ]
    },
    {
      "page": "clear_keyring_creds",
      "title": "Delete all hRvstAPI Harvest credentials from the keyring.",
      "topics": [
        "clear_keyring_creds"
      ]
    },
    {
      "page": "create_db",
      "title": "Create a SQLite database to hold Harvest API v2 request data.",
      "topics": [
        "create_db"
      ]
    },
    {
      "page": "create_rds",
      "title": "Download Harvest API v2 requests into a local file.",
      "topics": [
        "create_rds"
      ]
    },
    {
      "page": "get_keys",
      "title": "Get the unique set of key values that already exist in a table.",
      "topics": [
        "get_keys"
      ]
    },
    {
      "page": "hrvst_acct_id",
      "title": "Return the user's Harvest API v2 account ID.",
      "topics": [
        "hrvst_acct_id"
      ]
    },
    {
      "page": "hrvst_GET",
      "title": "Create an authenticated GET request with headers and queries.",
      "topics": [
        "hrvst_GET"
      ]
    },
    {
      "page": "hrvst_req",
      "title": "Perform a request for a Harvest API resource.",
      "topics": [
        "hrvst_req"
      ]
    },
    {
      "page": "hrvst_token",
      "title": "Return the user's Harvest API v2 personal access token.",
      "topics": [
        "hrvst_token"
      ]
    },
    {
      "page": "key_col",
      "title": "Get the name of the primary key column for a table.",
      "topics": [
        "key_col"
      ]
    },
    {
      "page": "params",
      "title": "hRvstAPI parameters",
      "topics": [
        ".agent",
        ".db_path",
        ".rds_path",
        ".service",
        ".url",
        "params"
      ]
    },
    {
      "page": "query_db",
      "title": "Query the local database and collect/return the result.",
      "topics": [
        "query_db"
      ]
    },
    {
      "page": "retrieve_creds",
      "title": "Retrieve user credentials from the keyring to environment.",
      "topics": [
        "retrieve_creds"
      ]
    },
    {
      "page": "set_creds",
      "title": "Set user credentials as environment variables.",
      "topics": [
        "set_creds"
      ]
    },
    {
      "page": "update_db",
      "title": "Update the local SQLite database with new Harvest API v2 request data.",
      "topics": [
        "update_db"
      ]
    }
  ],
  "_readme": "https://github.com/eric-hunt/hRvstAPI/raw/HEAD/README.md",
  "_rundeps": [
    "askpass",
    "assertthat",
    "bit",
    "bit64",
    "blob",
    "cachem",
    "cli",
    "clipr",
    "cpp11",
    "crayon",
    "curl",
    "DBI",
    "dplyr",
    "fastmap",
    "fs",
    "generics",
    "getPass",
    "glue",
    "hms",
    "httr2",
    "lifecycle",
    "lubridate",
    "magrittr",
    "memoise",
    "openssl",
    "pillar",
    "pkgconfig",
    "prettyunits",
    "progress",
    "purrr",
    "R6",
    "rappdirs",
    "readr",
    "rlang",
    "RSQLite",
    "rstudioapi",
    "stringi",
    "stringr",
    "sys",
    "tibble",
    "tidyselect",
    "timechange",
    "tzdb",
    "utf8",
    "vctrs",
    "vroom",
    "withr"
  ],
  "_score": 1.6989700043360187,
  "_indexed": true,
  "_nocasepkg": "hrvstapi",
  "_universes": [
    "eric-hunt"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.0.0.9000",
      "date": "2026-06-02T10:42:07.000Z",
      "distro": "noble",
      "commit": "f8e29ed3e7e25b5fecc9c7b9a2ad09aeb1b5788a",
      "fileid": "09638e068bca694dee7be2813bb2f1c59b3aadf6d78c8e13d423a14b9ffd40f4",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/eric-hunt/actions/runs/26814301944"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "0.0.0.9000",
      "date": "2026-06-02T10:42:13.000Z",
      "distro": "noble",
      "commit": "f8e29ed3e7e25b5fecc9c7b9a2ad09aeb1b5788a",
      "fileid": "a586f32f5bf741a259eebff045cef3d49faae42bce051239797d7c66c91a101c",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/eric-hunt/actions/runs/26814301944"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.0.0.9000",
      "date": "2026-06-02T10:50:24.000Z",
      "commit": "f8e29ed3e7e25b5fecc9c7b9a2ad09aeb1b5788a",
      "fileid": "49ff0da4975fd3bcecfcd513f5d94480955edd48cc4c55b24da585d2c69c3f3c",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/eric-hunt/actions/runs/26814301944"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "0.0.0.9000",
      "date": "2026-06-02T10:47:18.000Z",
      "commit": "f8e29ed3e7e25b5fecc9c7b9a2ad09aeb1b5788a",
      "fileid": "a8879cf0d9a83929f23689725b98461b217aa1cf1da7748b2d6d959797f1ae12",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/eric-hunt/actions/runs/26814301944"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.0.0.9000",
      "date": "2026-06-02T10:42:06.000Z",
      "commit": "f8e29ed3e7e25b5fecc9c7b9a2ad09aeb1b5788a",
      "fileid": "e9a47a214ea1a02b9f6e9f69019044c7c129309177bf205ac9783d49f9610ba1",
      "status": "success",
      "buildurl": "https://github.com/r-universe/eric-hunt/actions/runs/26814301944"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.0.0.9000",
      "date": "2026-06-02T10:41:16.000Z",
      "commit": "f8e29ed3e7e25b5fecc9c7b9a2ad09aeb1b5788a",
      "fileid": "ce146ae7aae821b4cef8b15359f47104d5af52516e1fe102d30c14d239dc696e",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/eric-hunt/actions/runs/26814301944"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.0.0.9000",
      "date": "2026-06-02T10:41:24.000Z",
      "commit": "f8e29ed3e7e25b5fecc9c7b9a2ad09aeb1b5788a",
      "fileid": "28a75377d47e152d2c528c5d62ffbc957a0ad4fad6dd1d5afc2175bdb89aa609",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/eric-hunt/actions/runs/26814301944"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "0.0.0.9000",
      "date": "2026-06-02T10:41:10.000Z",
      "commit": "f8e29ed3e7e25b5fecc9c7b9a2ad09aeb1b5788a",
      "fileid": "e23076beaf959aa9b81e6876ff13482de16ba0f82a52c5fb6b30b98e32fa168c",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/eric-hunt/actions/runs/26814301944"
    }
  ]
}