Some data might get lost when retrieving result using the REST JSON URL compared to REST XML URL in TIBCO Data Virtualization
Article ID: KB0074609
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | All Supported Versions |
Description
In TIBCO Data Virtualization when retrieving the data from a web service using a REST/JSON URL, the data may get lost as compared to when the data is retrieved using the REST/XML.
Root cause
In TDV, the schema definition affects the JSON output if by default any definition set is bind with the resource. The "bad" schema definition breaks the JSON output and the expected output will not be returned.
Environment
All supported Operating Systems
Resolution
Follow the below steps to resolve the issue:
1. Login to TDV Studio.
2. Open the web service where the resource belongs.
3. Navigate to the REST tab of the web service.
4. In the configuration window of the REST tab look for the configuration JSON Format-->Validate XML Schema Definition Set.
The value is set to TRUE by default. Change the value "FALSE".
5. Save the changes.
6. Browse the URL and verify if the correct data is returned.
1. Login to TDV Studio.
2. Open the web service where the resource belongs.
3. Navigate to the REST tab of the web service.
4. In the configuration window of the REST tab look for the configuration JSON Format-->Validate XML Schema Definition Set.
The value is set to TRUE by default. Change the value "FALSE".
5. Save the changes.
6. Browse the URL and verify if the correct data is returned.
Issue/Introduction
Some data might get lost when retrieving result using the REST JSON URL compared to REST XML URL in TIBCO Data Virtualization
Additional Information
Feedback
Yes
No
Powered by
