I'm wanting a way to automate (e.g. via Scheduled task running a PowerShell script) copying a file from a Windows server environment (accessible via Remote App) to a SFTP location.
Scenario background - ERP software running on a Windows Server (on AWS) exports a daily report in csv format to a folder that is accessible only via Microsoft RemoteApps. I want that file accessible via SFTP (for use by another service.)
On my computer (or rather, a separate Windows computer - Server 2025 virtual machine instance actually setup exclusively for this purpose), when I open "Personal Cloud Documents" it makes the RDP connection to the ERP environment, and then provides a "sandboxed/virtual/remote" Windows Explorer window. From there, I can access the server folder (e.g. \server\export) and I can manually copy and paste the file from that window to the desktop. But I can't "drag and drop" it like I could if it were mounted on the local machine / network, and cannot access this directly via Run (e.g. \server\export), for instance - I can only access it within that RemoteApps window. So a PowerShell script running on this won't "see" the file...
I presume there must be some workaround such that I can reliably access this file via script.
The scheduled task, SFTP setup, PowerShell script, etc. isn't my challenge - "simply" accessing a file in this RemoteApps folder "programmatically" however is.
Note - I do NOT have Administrator access on the ERP server. I do have Administrator access on the cloud computer designated for this task.
I have very limited RemoteApps experience, and hoping there's something simple that I'm missing. Any ideas?
