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

[Siyou Li]

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

[scottl]

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.

[JoseI1156258720]

I'm excuting this comand in my script to create 'u_data' column:

import_set_table.addJSONColumn('u_data', 5000);

but column is still create as String, also length is ignore, and big max_size is set 42269.

[dd31]

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