How to figure out what XML was created with the JSON parser

[Q&A] General
1

Hi,

I’m trying to use a sequential import template to import a JSON file. In order to figure out the xpaths, I’ve first parsed the JSON file to an XML with an emulator and used that XML to use the sequential import successfully. Unfortunately, when I try it with the original JSON, it no longer works, it just says it’s imported 0/0 records. I’m guessing I’ve parsed the JSON differently than the Novulo plug-in has, is there a way to figure out what XML was created by the Novulo plug-in so I can adjust my xpaths accordingly?

Thanks!

Any other way to de-bug a sequential import are also welcome (other than the embedded import logs which are unfortunately not helpful).

2

Hi Mila,
You could store the XML in a textarea field.

Also, on 17 March, a NB version of the import engine (r250) has been made available with JSON-path support, eliminating the need for the XML intermediate step. Maybe that’s even a better option?

3

Hi Joost,

Thanks for responding and I’ll look into both options. How would you store the XML in a textarea field exactly?