RPE is designed to work with XML data only but with JSON gaining ground more and more tools switched to JSON for exporting their data.
For such scenarios you need to use one of the multiple offline and online tools that can convert JSON to XML. Next you need to create an XML schema (XSD) for the generated XML in order to build a template for the data.
Online tools have a number of shortcomings, data security and privacy first and foremost. To avoid this I have assembled a tool that does that conversion on my local machine. Note that there are multiple commercial tools that are better and more flexible my tool but this is a good, fast alternative to manual conversion.
The transformation route is:
JSON ----> XML ---> XSD
java -jar json2xml.jar d:\test\test1.json d:\test\
The tool’s source code and the latest build is available on Github: https://github.com/dragoscojocari/json2xml You can fork it and change it in any way you need.
The software is not provided or supported by IBM and it’s not associated with RPE.
DISCLAIMER: THE SOFTWARE IS PROVIDED “AS IS”, WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.