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
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 659 Datasets
- 116 SQL DataFlows
- 2.2K Magic ETL
- 816 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 82 App Studio
- 45 Variables
- 776 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 82 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 411 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 11 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive