json extract failing on valid json

aros1686738052 — Fri, 15 Nov 2024 21:41:01 GMT

I am reaching out to a restful API and its returning valid JSON but the tExtractJSONFields component is failing. I get the error:

net.minidev.json.parser.ParseException: Malicious payload, having non natural depths, parsing stoped on { at position 45050.

My json is

{

"984b67ee-dad9-45b4-8ea5-13210d3975ed"

: {

"meta"

: {

"lastactivity"

: {

"value"

1686725554895

"time"

1686725554895

"seq"

150725

"unique"

: {

"value"

"1ad028af5bcdcdcecad709ee5d686aec"

"time"

1655431220424

"seq"

"connections"

: {

"value"

"time"

1682531486185

"seq"

}

"142b67ee-dad9-45b4-8ea5-13210d3975ed"

: {

"meta"

: {

"lastactivity"

: {

"value"

1686725554895

"time"

1686725554895

"seq"

150725

"unique"

: {

"value"

"1ad028af5bcdcdcecad709ee5d686aec"

"time"

1655431220424

"seq"

"connections"

: {

"value"

"time"

1682531486185

"seq"

}

Re: json extract failing on valid json

Anonymous — Fri, 16 Jun 2023 07:56:55 GMT

A same issue has been reported to R&D team on Talend Bugtracker. Can you please try the below workaround?

The workaround is to customize the maven URI in order to use the version 2.4.10 or 2.4.11 of the jar file json-smart

Download the version 2.4.11 of the jar file

https://mvnrepository.com/artifact/net.minidev/json-smart/2.4.11

Customize the maven URI to use the version 2.4.11 instead of 2.4.9 as described in the article :

https://help.talend.com/r/en-US/7.3/studio-user-guide/customizing-maven-uri-for-external-module-deployment

Customizing the Maven URI for external module deployment

Regards

Shong

topic json extract failing on valid json in Talend Studio

json extract failing on valid json

Re: json extract failing on valid json