So I know you can use the file upload component to import csvs and have that set up and working
but that method we would need a person to manually put the csvs into the component.
What I am really looking for is for a way to put a filepath in the script and then it grabs the csv from that filepath from my mapped network drive of N:
is this possible in perspective? I was trying to use system.file.openfile but i couldnt get it to work
Did you follow the instructions for mapping a drive for the gateway to use? (A user mapping a drive on that server's desktop doesn't make that drive usable by the gateway.) If the gateway service is using a user account that has network privileges, UNC paths should work (no drive letter).