Can a JSON response be modified prior to XML conversion in TIBCO DV

[Dave Richardson]

The REST data source I am using provides data in JSON format.In JSONit is valid to have keys with spaces, and this is the problem. Spaces in key namesare not allowed in XML as the space is a delimiter.

Is there anyway to replace spaces in key names with, say, an underscore prior to converting to XML(i.e. "Business Unit" --> "Business_Unit") either in the data source or later on

It would be hugely beneficial for TDV to handle all valid JSON responses if the proper procedure is to convert a JSON response to XML directly in the data source.

[Motsu Aboshi]

There's a server-wide configuration setting for this, I forget what it's actually called. Search for JSON in Administration -> Configuration (or have your admin search for it).

[Donald Johnson]

Dave, Your jpg's are on your 'C' drive.

 

<p>
<img alt="" src="C:UsersrichadavOneDrive - Husky EnergyDocumentsaaa_CCP Data Hub.jpg">
<img alt="" src="C:UsersrichadavOneDrive%20-%20Husky%20EnergyDocumentsaaa_CCP%20Data%20HubJSON%20to%20XML%20required%20configuration%20change.jpg">
<img alt="" src="C:UsersrichadavOneDrive%20-%20Husky%20EnergyDocumentsaaa_CCP%20Data%20HubJSON%20to%20XML%20required%20configuration%20change.jpg">
<img alt="" src="C:tempJSON_to_XML_required_configuration_change.jpg">
</p>

We can't see them.

[Dave Richardson]

You are correct.  Thank-you for your quick response!

 

For future reference, in TDV Studio 7.0 it can be found here under Administration --> Configuration:

 

Data Sources

REST Sources

 

Replace Invalid JSON Name for XML Conversion: True or False

 

 

[Dave Richardson]

I've attached the image which simply shows the actual configuration change location that I mentioned in my previous post.