File retrieval using SFTP data source

[charanpreet]

I have configured Data source using SFTP file retrieval method.

The file that will be kept in the path can be of any name which is not known before and there can be more than one file.

What should be specified in the 'File Path' and 'Connection URL'?

[Ankur Bawiskar]

Hi Charanpreet,

Any update on this?

Can you mark my answer as correct, helpful and hit like if you were able to achieve the requirement. This helps in removing this question from unanswered list and helps users to learn from your thread. Thanks in advance.

Regards

Ankur

[charanpreet · Accepted solution]

The issue is that the pattern of the file name is not known.

So the solution is that we can have Inbound action and in this way the user can send an email with the file attached to the ServiceNow. The inbound action will invoke the data source to load the data from the attachment in the mail.

[Nishant13]

Hi @Ankur Bawiskar ,

we have same type of implementation in place Do we need mid server for SFTP connection because everytime we are trying to load 20 records it is giving us an SSH authentication error .

kindly provide your insight on this .

Thanks ,

Nishant