Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
}
}
}
}
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