The Zurich release has arrived! Interested in new features and functionalities? Click here for more

IH-ETL FAQ - Unable to find format of the single column

Siyou Li
ServiceNow Employee
ServiceNow Employee

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."

6 REPLIES 6

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.

dd31
Kilo Guru

@Siyou Li  i am facing a similar issue, were your able to resolve the issue?