SFTP Data Source : MidServer Location

[Ken83]

Hello Community,

I have a .csv file on my MidServer in the \export\folder directory. I want to retrieve this file using an SFTP data source and run a data transform on it. When i try to retrieve the file, i get an error. Why can't I retrieve the file?

[Ken83 · Accepted solution]

After speaking with ServiceNow, they explained that in order to utilize an SFTP Data Source, the site/server hosting the file must be publicly accessible over the internet. I pivoted to a third party file transfer solution to grab the file from the host and hold it in a location that ServiceNow could pull it from. Everything is working as needed.

[Thailan Arthana]

Hi Ken,

Now I'm also working same as what you've worked on your requirement here. (Need to retrieve the CSV data from SFTP via MID Server).

Could you please provide me some details here?

1. How did you communicate SFTP via MID server?

2. Is that the Linux/Windows MID server? (Whatever it's or MID server should be Linux platform)

3. What about that third party solution? Pls send me your update sets to my email for this integration if you can provide.

thailansathi@gmail.com