SFTP Connector - Any way to read files from a specific folder?
Is there a way to bring in data from a specific folder via the SFTP connector? I set up an SFTP connection and I could only access files in the root directory.
If this isn't possible, could someone recommend an alternative way to bring in this data? We do not have Workbench set up yet since we are relatively new to Domo and use Macs exclusively.
Comments
-
Can anyone help out with this request?
0 -
Bump - anybody figure this out yet, or have ideas on alternatives [without switching to a different SFTP hostname?]
.....................................................................................................………….
ANDY BATTEN / red door interactive
Sr. Director, Data Analytics
.....................................................................................................………….0 -
This worked for me. Select the Excel SFTP Connector.
In the credentials section, set the Hostname to root directory. In the Details section, locate textfield labeled file name or portion of file name to search for and type the path for the document you want to pull. For example: ./<Folder Name>/<File Name>
Note, there is another useful dropdown in the Details section labeled as Mode. It is set to Auto by default. You might need to switch Mode from Auto to Manual if your headers start after row 1. For example if headers are located on row 3, and data begins on row 4, you might use the following settings (image below). Also, A1 notation can include columns that don't have data. This is useful if you plan to include additional fields to dataset in the future.
0
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 282 Workbench
- 3 Cloud Amplifier
- 4 Federated
- 2.8K Transform
- 86 SQL DataFlows
- 548 Datasets
- 2.2K Magic ETL
- 3.2K Visualize
- 2.3K Charting
- 544 Beast Mode
- App Studio
- 26 Variables
- 566 Automate
- 134 Apps
- 411 APIs & Domo Developer
- 21 Workflows
- DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 345 Distribute
- 87 Domo Everywhere
- 257 Scheduled Reports
- 1 Software Integrations
- 85 Manage
- 84 Governance & Security
- 8 Product Release Questions
- Community Forums
- 41 Getting Started
- 27 Community Member Introductions
- 81 Community Announcements
- 4.8K Archive