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
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive