the code:
library(shiny)
library(shinydashboard)
library(googlesheets4)
library(DT)
data <- read_sheet("<insert URL to sheet here")
# Define server logic required to draw a histogram
server <- function(input, output) {
}
# Run the application
shinyApp(ui = ui, server = server)
when I run this code it redirects to ask for which googl account i want to allow tidyverse API packages with.
after selecting the account it asks me to allow the account permission.
then, confirm my choices, and click 'allow'.
the app cycles and then errors out with:
this site can't be reached - localhost refused to connect
I'm using r studio server community edition on ubuntu 18.04 - there is no gui on this server...administration is done through command line. thus, i do not have my google drive connected to this server. I'm not sure if that's part of the issue or not. i would assume not. if i place this application on shinyapps.io i would not have my google drive connected on their infrastructure.
when i putty to the server and run a 'curl' of the URL to the sheet i get basic head information in return, so i know i have a connection between the server and google - it's in the app, but i cannot for the life of me find a guide that solves this.
cheers ~!