I have integrated WebDataRocks pivot table into one of our R Shiny applications. This pivot table has a pre-determined format and a dynamic dataset, that is updated in collaboration with the other members of the team. Both the format and dataset files are stored in Sharepoint. My team now wants to be able to open the latest version of the data on component startup rather than having to click in the load button and selecting the report. I have tried to save the link to the file in the argument "dsource" and also "report" of the function "pivta", but I always received the same error message:
Any insight is much appreciated.