Save csv file to shared folder using mid server

Hi,

I have been task with creating a csv in ServiceNow and saving it to a shared folder.  I know that I can use the scheduled export, but that only allows me to save it to a file path relative to the Mid Server directory and also I need specific headers (which I will create through script).  I want to use the mid server to save this file to that shared folder, but I am not sure how to go about that.

I am wondering if I should create a custom PowerShell to drop that file in that folder.

Does anyone have any suggestions?