Using JPATH in an import after REST call

Hi,

I want to import some data from a REST call, and since that call returns JSON and I heard Novulo supports JPATH I wanted to do that without transforming the JSON to XML. However, when I do that, I get an error that that says it can’t parse a “<” at line 0, position 0.

But since it is JSON, there is no “<” anywhere to be found. Has anybody successfully used the JPATH before and maybe has the Novulo way of working for it?

Thanks!

Hello Mila,

Correct that it is now possible to use JPATH.

Required/usefull components are:
M3448 r.249+ is a requirement for using JPATH in importing.
M7899 r.607+ Novulo basic calls and responses supports using JPATH
M3624 r.118+ Novulo sequential importV2 prevents unnecessary storing of duplicate data when using a sequential import.

For using the M7899 route it is important to set the “response content type” to JSON, the sequential import definition’s “import source” can be set to file or string, but all underlying importdefinitions should have the “import type” set to JSON.

When using your own solution for call/response you should be able to use N_Import - execute with arguments and return value. Input the JSON string or file into the “file” or “xmlstring” parameter. We are aware this suggests xml is required.

If you have any further questions let me know.