JSON to Tabular – Returning NULL values in Output
Article ID: KB0079948
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | TDV 7.0.6 |
Description
In TDV 7.0.6 version while converting JSON data to tabular using XSLT transformation the output results in NULL values instead of actual values.
This issue has been identified as bug and fixed in TDV 7.0.8 version and available for download.
Issue/Introduction
Resolution
1. Make a copy of definition created.
2. Create a new definition and paste the earlier created definition.
3. identify "Choice" element and remove it from the definition.
4. Now there will be an error "Element 'element' is invalid, misplaced, or occurs too often" when you validate the XML definition.
5. Add <xs:sequence> after complextype and close it and save in order to resolve the above error.
6. Once you save it go to Data source and click on data type under "Header/Body Parameters" and browse for new XML definition Created and select it.
7. Now create new transformation and the NULL values will be removed.
Feedback
