I come to you not for technical reasons, but rather to get your opinion on the best organization to set up our project with Rconnect.
We have a.rmd file that must run every Monday, it aggregates data from googlesheet, from json files via htpp, but also by reading csv/xlsx that are locally on the server. These csv/xls files are updated weekly (deposited via FTP by an automatic service). This Rmd generates RDS files.
These RDS files are then used by a Shiny application.
For the moment we are obliged to:
manually knit the Rmd
moved the generated RDS to the shiny application folder
The ideal would be not to have to republish the application ( that the data are dynamically updated), see, if possible not to have to knit the Rmd every Monday. In short, everything is done on its own.
What solution can you propose for this situation?