Is there any way to connect to an FTP/SFTP server in a custom connector?

Reply
Highlighted
Visitor

Is there any way to connect to an FTP/SFTP server in a custom connector?

I am building a custom connector, and the API call to get the data I need will not return the data over HTTP, but instead generates a csv file that is placed on an external SFTP server. I know JavaScript does not have functionality to work with SFTP, but as this is using the Nashorn engine, I believe it should theoretically be possible to use Java classes to accomplish this, but I have not been able to figure it out. Any help finding a way to connect to this SFTP server and upload the csv file to Domo from the custom connector would be greatly appreciated.

 

Thanks

Moderator

Re: Is there any way to connect to an FTP/SFTP server in a custom connector?

Is anyone able to help out with this request?

Yellow Belt

Re: Is there any way to connect to an FTP/SFTP server in a custom connector?

@user06053 Not sure about exactly how to set up your custom connector, but if you're able to get the file deposited in an SFTP server, you could use the CSV-SFTP Connector to pull the file into Domo.

Visitor

Re: Is there any way to connect to an FTP/SFTP server in a custom connector?

@Jaketh13 Thanks for the response, and I had considered this as a solution. Unfortunately that won't quite work for two reasons:

1. The file is actually a csv in a compressed .zip folder.

2. The file does not always have the same name, and I get the file name from the response to the http request placed in the custom connector.

Announcements
Domopalooza 2018! Pre-conference training registration is now open! Click here!