{"action":"created","issue":{"url":"https://api.github.com/repos/MarkEdmondson1234/googleAnalyticsR/issues/147","repository_url":"https://api.github.com/repos/MarkEdmondson1234/googleAnalyticsR","labels_url":"https://api.github.com/repos/MarkEdmondson1234/googleAnalyticsR/issues/147/labels{/name}","comments_url":"https://api.github.com/repos/MarkEdmondson1234/googleAnalyticsR/issues/147/comments","events_url":"https://api.github.com/repos/MarkEdmondson1234/googleAnalyticsR/issues/147/events","html_url":"https://github.com/MarkEdmondson1234/googleAnalyticsR/issues/147","id":294235209,"number":147,"title":"googlesheets to visNetwork to shinyapps.io","user":{"login":"ridenourranchcompany","id":35438857,"avatar_url":"https://avatars0.githubusercontent.com/u/35438857?v=4","gravatar_id":"","url":"https://api.github.com/users/ridenourranchcompany","html_url":"https://github.com/ridenourranchcompany","followers_url":"https://api.github.com/users/ridenourranchcompany/followers","following_url":"https://api.github.com/users/ridenourranchcompany/following{/other_user}","gists_url":"https://api.github.com/users/ridenourranchcompany/gists{/gist_id}","starred_url":"https://api.github.com/users/ridenourranchcompany/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ridenourranchcompany/subscriptions","organizations_url":"https://api.github.com/users/ridenourranchcompany/orgs","repos_url":"https://api.github.com/users/ridenourranchcompany/repos","events_url":"https://api.github.com/users/ridenourranchcompany/events{/privacy}","received_events_url":"https://api.github.com/users/ridenourranchcompany/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2018-02-04T22:02:15Z","updated_at":"2018-02-05T10:43:53Z","closed_at":"2018-02-04T23:06:15Z","author_association":"NONE","body":"Dear MarkEdmondson1234\r\n\r\nI am working on an app in shinyapps.io.   I am using your code to and simple example to get my sheets to publish on shinyapps.io.  Now I want to use the data in the sheet to create a visNetwork.  I have not been able to overcome the error in inherits.  Im using code from Mark Edmondson 1234 from https://github.com/jennybc/googlesheets/issues/235 create an object `gs_df `. \r\n\r\n```\r\nWarning: Error in : inherits(ss, \"googlesheet\") is not TRUE\r\nStack trace (innermost first):\r\n    81: stopifnot\r\n    80: gs_read_csv\r\n    79: gs_read\r\n    78: func [/App-1/app.R#38]\r\n    77: origRenderFunc\r\n    76: output$network\r\n     1: runApp\r\n\r\n```\r\n\r\nMy code is here:\r\n\r\n```\r\nserver <- function(input, output) {\r\n\r\n  gs_df <- reactive({\r\n    #Use key to fetch googlesheet\r\n    options(\"googlesheets.httr_oauth_cache\" = \"gs_auth\")\r\n    gskey2 <- \"12_5p4EkOI8TGHnTg5L5R9ONG5JJuXmv--9uxY_ZuQy0\"\r\n    \r\n    gs_auth()\r\n    # register the googlesheet\r\n    gs_file <- gs_key(x=gskey2)\r\n    gs_df <- gs_read(gs_file)\r\n    \r\n  })\r\n  \r\n  output$network <- renderVisNetwork({\r\n  \r\n    df = gs_df()\r\n\r\n   ws_From_To<- df %>% gs_read(ss=df, ws = \"From_To\")\r\n   ws_Id <- df %>% gs_read(ss=df, ws = \"Id\")\r\n    \r\n    \r\nnodes <- as.data.frame(ws_Id)\r\nedges<-as.data.frame(ws_From_To)\r\n##############\r\n```\r\n\r\nI saw code idea by jennybc at https://github.com/jennybc/googlesheets/issues/114\r\nIt seems like this copy + register, consume idea might be part of the solution, but i don't understand how to apply the `copy_ss() `or `get_via_csv()` functions to the gs_df object created by your reactive code.\r\n\r\n```\r\ngap_key <- \"1HT5B8SgkKqHdqHJmn5xiuaC04Ngb7dG9Tv94004vezA\"\r\ngap_ss <- copy_ss(key = gap_key, to = \"gap_copy\")\r\noceania_csv <- get_via_csv(gap_ss, ws = \"Oceania\")\r\nstr(oceania_csv)\r\noceania_csv\r\n```\r\n"},"comment":{"url":"https://api.github.com/repos/MarkEdmondson1234/googleAnalyticsR/issues/comments/363047320","html_url":"https://github.com/MarkEdmondson1234/googleAnalyticsR/issues/147#issuecomment-363047320","issue_url":"https://api.github.com/repos/MarkEdmondson1234/googleAnalyticsR/issues/147","id":363047320,"user":{"login":"MarkEdmondson1234","id":3155884,"avatar_url":"https://avatars1.githubusercontent.com/u/3155884?v=4","gravatar_id":"","url":"https://api.github.com/users/MarkEdmondson1234","html_url":"https://github.com/MarkEdmondson1234","followers_url":"https://api.github.com/users/MarkEdmondson1234/followers","following_url":"https://api.github.com/users/MarkEdmondson1234/following{/other_user}","gists_url":"https://api.github.com/users/MarkEdmondson1234/gists{/gist_id}","starred_url":"https://api.github.com/users/MarkEdmondson1234/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MarkEdmondson1234/subscriptions","organizations_url":"https://api.github.com/users/MarkEdmondson1234/orgs","repos_url":"https://api.github.com/users/MarkEdmondson1234/repos","events_url":"https://api.github.com/users/MarkEdmondson1234/events{/privacy}","received_events_url":"https://api.github.com/users/MarkEdmondson1234/received_events","type":"User","site_admin":false},"created_at":"2018-02-05T10:43:53Z","updated_at":"2018-02-05T10:43:53Z","author_association":"OWNER","body":"Thanks Drew :) Glad to be of help."}}
{"actor":{"display_login":"MarkEdmondson1234"}}