Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
aros1686738052
Contributor
Contributor

json extract failing on valid json

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"

:

1

},

"connections"

: {

"value"

:

0

,

"time"

:

1682531486185

,

"seq"

:

30

}

}

},

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

: {

"meta"

: {

"lastactivity"

: {

"value"

:

1686725554895

,

"time"

:

1686725554895

,

"seq"

:

150725

},

"unique"

: {

"value"

:

"1ad028af5bcdcdcecad709ee5d686aec"

,

"time"

:

1655431220424

,

"seq"

:

1

},

"connections"

: {

"value"

:

0

,

"time"

:

1682531486185

,

"seq"

:

30

}

}

}

}

Labels (2)
1 Reply
Anonymous
Not applicable

Hi

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