Skip to Content
Former Member
Jul 31, 2014 at 12:55 PM

json input adapter root path


Hi all,

What should I set to roothpath fo JSON Input file adapter when json data do not include root? What I try is to get following json data into an ESP window.

{"sessionid":"14697550182","time":"2013-Nov-03 12:41:18","size":"2434","payload":"1902","medium":"1"}

{"sessionid":"14697550183","time":"2013-Nov-03 12:41:18","size":"1926","payload":"1394","medium":"1"}

When I wrote * to rootpath but I get following error:

jsonRootpath = '\"*\"' ,

jsonRootpath = '*' ,

jsonRootpath = '"*"' ,

all of them gives following error.

07-31-2014 12:46:34.440 ERROR [Thread-18] (JSONInFormatter.getMultiRecordsByRootPath) Error code:402305, Severity : 3 (Error)

Error message:Invalid rootpath, please check the JSON rootpath.

Error description:Invalid rootpath, please check the JSON rootpath.

07-31-2014 12:46:34.441 ERROR [Thread-18] (JSONInFormatter.convert) Exception is thrown

java.lang.Exception: Error code:402305, Severity : 3 (Error)

Do you have any ideas?

Thanks and regards,