IH-ETL FAQ - Unable to find format of the single column
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-26-2024 02:17 PM - edited ‎03-26-2024 02:18 PM
1. Create a nested payload JSON format data source using custom script type, mark "data in single column" option to true
2. Pull an import set from this data source
3. Go to IH-ETL, create a new mapping base on this data source
4. Go to IH-ETL second step "Preview and prepare data"
5. Error shows "Unable to find format of the single column. Verify Data Source configuration is correct or contact your CMDB Admin for help."
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-01-2024 06:10 PM - edited ‎10-01-2024 06:18 PM
And when it comes to an ETL, how it is meant to map against that JSON field? Because this "solution" fails to parse that field into a Data object to be used in the ETL mapping.
No one should be having to manually build out "Output" payloads in a Data Stream for this to work, esp. when an entire payload is needed for transformation.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
a month ago
@Siyou Li i am facing a similar issue, were your able to resolve the issue?