topic Re: tjava parse json in Talend Studio

tjava parse json

talend777 — Sat, 24 May 2025 15:27:59 GMT

I have a file input in Talend studion that contains below type of syntax and i need to extract userid, password from it

"{\"password\":\"aaa\",\"username\":\"aaab\"}"

any suggestion how to parse this json looking kind of field.

i tried tjsonextract but its not working correctly.

i am trying tjava and json.parse but that is also not working.

any suggestions/recommendations ?

Dave_Simo — Sat, 24 May 2025 15:50:17 GMT

To parse this json, you would need to replace the \ with "" and then pass it to the tExtractJSONFields component.

tJavaRow Config

tExtractJSONFields Config

Best Regards

talend777 — Tue, 27 May 2025 13:17:46 GMT

may i know how does your schema looks like for tjsonExtract fields

i tried like below and passed it as string and it removed the / but for some reason its not working for tjsonExtract

String json = String.valueOf("{\"password\":\"bbbb\",\"username\":\"aaaa\"}");

globalMap.put("json", json );

System.out.println("json :" +globalMap.get("json"));

Dave_Simo — Tue, 27 May 2025 14:14:34 GMT

talend777 — Tue, 27 May 2025 14:53:55 GMT

Thank you so much @Dave_Simo for your help , it is working