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
Comments
-
Is anyone able to help out with this request?
0 -
@AL-where 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.
Thanks,
Jake
**Say "Thanks" by clicking the "heart" in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
@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.
0 -
User06053,
Not sure if you figured this out, but the CSV Advanced should solve your problems.
Warm regards,
MH
0
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Connect
- 1.3K Connectors
- 309 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 663 Datasets
- 119 SQL DataFlows
- 2.3K Magic ETL
- 823 Beast Mode
- Visualize
- 2.6K Charting
- 86 App Studio
- 46 Variables
- Automate
- 194 Apps
- 483 APIs & Domo Developer
- 87 Workflows
- 23 Code Engine
- AI and Machine Learning
- 23 AI Chat
- 4 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 118 Domo Everywhere
- 283 Scheduled Reports
- 11 Software Integrations
- Manage
- 143 Governance & Security
- 11 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 116 Community Announcements
- 5K Archive