Shiny auto refresh using local CSV

[peye5275]

I wrote a simple shiny app that I deployed to shinyappsio. The app just reads in a csv and displays the contents of the csv. I want the app to refresh every 15 minutes (i realize the code below shows 15 seconds) using the updated csv that is saved locally. However, when I deploy to shinyappsio, it seems to cache the csv and doesn't to display the new file. This code runs as expected locally, but does not update once deployed to shinyappsio

ui <- fluidPage(
   
  
   titlePanel("Standings"),
   
  
      mainPanel(
         dataTableOutput("mytable")
      )
   )


server <- function(input, output) {
  
  observe({
   
  standings <- reactiveFileReader(15000, file = "live_scores.csv", session = NULL, read.csv)
  
   output$mytable <- renderDataTable(standings())
  })

}

shinyApp(ui = ui, server = server)

[andresrcs]

@peye5275

However, when I deploy to shinyappsio, it seems to cache the csv and doesn't to display the new file.

This is exactly what is happening, when you deploy to shinyapps.io a copy of your files gets uploaded to their servers, they don't have access to your local files any more, you have to follow a different approach, like saving your csv file on a cloud service or save your data to a sql server that allows remote access.