I have a workflow with a macro which sends an API request and downloads a .zip file to the specified folder for each country.
When the specified folder is 'C:\Users\Public' it is not overwriting the file, however when I specify any other folder, every time it downloads the file for the particular country.
Could somebody help to understand why it happens so?
Do you have write access to that folder? Try opening file explorer outside of Alteryx, right clicking and going new -> text document. I am thinking that maybe your user permissions don't allow for writing to this location.