topic Re: Passing json to tJava in Talend Data Catalog

Passing json to tJava

pthomas — Mon, 06 Oct 2025 17:20:09 GMT

I have a valid chunk of json from a tMap and the chunk is named "children." I am trying to pass that into a tJava component. The job won't even compile. I get the error...

"Type mismatch: cannot convert from JSONArray to childrenStruct."

JSONObject currentNode = (JSONObject) globalMap.get("children");

JSONArray children = new JSONArray();

Stack<JSONArray> stack = new Stack<>();

if (currentNode.has("relationshipList")) {

stack.push(currentNode.getJSONArray("relationshipList"));

}

while (!stack.isEmpty()) {

JSONArray list = stack.pop();

for (int i=0; i<list.length(); i++) {

JSONObject currentChildNode = list.getJSONObject(i);

if (currentChildNode.has("unit")) {

JSONObject unit = currentChildNode.getJSONObject("unit");

if(currentChildNode.has("parentID")) {

unit.put("parentID", currentChildNode.getString("parentID"));

}

if(currentChildNode.has("level")) {

unit.put("level", currentChildNode.getString("level"));

}

children.put(unit);

}

if(currentChildNode.has("relationshipList")){

stack.push(currentChildNode.getJSONArray("relationshipList"));

}

globalMap.put("allSubordinates", children);

JSONArray retrievedList = (JSONArray) globalMap.get("allSubordinates");

Re: Passing json to tJava

Shicong_Hong — Wed, 15 Oct 2025 00:00:55 GMT

Hello @pthomas

Check this article https://community.qlik.com/t5/Official-Support-Articles/What-is-the-difference-between-tJava-tJavaRow-and-tJavaFlex/ta-p/2151892

I think you should use tJavaRow instead of tJava component in this case.

Regards

Shicong

Re: Passing json to tJava

pthomas — Tue, 14 Oct 2025 17:31:40 GMT

@Shicong_Hong - tJavaRow worked.

I can't get to the article in your link though.

Re: Passing json to tJava

Shicong_Hong — Wed, 15 Oct 2025 00:03:16 GMT

I'm glad you got it working! I have corrected the article link, thanks for pointing it out.