Relative Path to fix JSON import and allow auto refresh

Hi All,   After much research and reading a lot of posts I was able to use a base code and adapt it to my PBi needs, the current code merges all pages on a JSON but I am unable to refresh the datab...