JSONObject text must begin with '{' at 1 [character 2 line 1]

WSyahirah21 — Fri, 15 Nov 2024 23:01:44 GMT

I am creating a workflow to extract the json string from spark job in the tSystem using tJava:

tSystem -> tJava

Expected output is, firstly, tSystem will give the string result in the form of log.info() and also in json format. Later, tJava will extract and only print out the json string while ignore the other string format.

Spark output from tSystem:

String output=((String)globalMap.get("tSystem_3_OUTPUT"));

JSONObject jsonObject = new JSONObject(output);

System.out.println(jsonObject);

String sourceCount=(jsonObject.getString("Source rows"));

System.out.println("Database Name: "+jsonObject.getString("DBName"));

globalMap.put("sourceCount",sourceCount.trim());

However, when I run my current workflow, the following error appears which I believe is because my java code in tJava tried to read the string in all format , instead of json string only.

Error in tJava:

FATAL] 11:18:46 nerve_ingestion.fullrefreshingestion_dev_0_15.FullRefreshIngestion_Dev- tJava_3 A JSONObject text must begin with '{' at 1 [character 2 line 1]

routines.system.JSONException: A JSONObject text must begin with '{' at 1 [character 2 line 1]

at routines.system.JSONTokener.syntaxError(JSONObject.java:1790) ~[routines.jar:?]

at routines.system.JSONObject.<init>(JSONObject.java:166) ~[routines.jar:?]

at routines.system.JSONObject.<init>(JSONObject.java:279) ~[routines.jar:?]

How should i change the java code to ensure tJava only capture the json string?

Re: JSONObject text must begin with '{' at 1 [character 2 line 1]

jzhao — Tue, 12 Apr 2022 04:13:57 GMT

Hello,

what's the content of "output" ?

Re: JSONObject text must begin with '{' at 1 [character 2 line 1]

WSyahirah21 — Tue, 12 Apr 2022 19:53:02 GMT

Hi jzhao,

Issue solved. Basically I did following step in tJava:

Use substring between “ingestion start” and “ingestion end” to capture that json line in spark job result.
Do some cleanup until u get that jsonobject only.

Thanks for responding!

topic Re: JSONObject text must begin with '{' at 1 [character 2 line 1] in Talend Studio

JSONObject text must begin with '{' at 1 [character 2 line 1]

Re: JSONObject text must begin with '{' at 1 [character 2 line 1]

Re: JSONObject text must begin with '{' at 1 [character 2 line 1]