Unable to get SFTP Writeback Connector to work

Each time it executes I get an error message "Invalid date - Last successful run"
Date SFTP dataset that is created when I configure the connector contains no schema.
Any suggestions?
Answers
-
That error normally means you have a data type wrong. Check the schema to make sure your date fields are proper date types. Check your data source. If it's an Excel file, make sure that column is formatted as date.
You can also override the schema under Admin menu…Governance Toolkit > Schema Management.
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
I don't think that is the issue. The DOMO SFTP Writeback connector automatically creates what appears to be a mirror of the dataset you are trying to send. (I am not sure because it is not documented well). It is during this process that I get the Invalid Date error. The automatically created dataset ends up with no scheme or data. My dataset, the source, had no date fields.
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 308 Workbench
- 7 Cloud Amplifier
- 10 Federated
- 3.8K Transform
- 661 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 819 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 84 App Studio
- 46 Variables
- 781 Automate
- 193 Apps
- 483 APIs & Domo Developer
- 84 Workflows
- 23 Code Engine
- 43 AI and Machine Learning
- 22 AI Chat
- 3 AI Projects and Models
- 18 Jupyter Workspaces
- 409 Distribute
- 116 Domo Everywhere
- 282 Scheduled Reports
- 11 Software Integrations
- 146 Manage
- 142 Governance & Security
- 8 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive