[resolved] JSON parse errors on well-formed data

DaveL — Fri, 06 Sep 2013 16:53:03 GMT

I am using this JSON object which checked out as valid JSON on the JSONLint site.
{
"eventMode": "exit",
"eventInfo": {
"bundleHistoryId": "fca39967d82d427698f9425bb7e1ae96",
"exhibitId": "8db47cfe5e404e3689ad3ec868007dc7",
"exhibitType": "html",
"path": "read/jenis-splendid-ice-creams-home-jeni-britton-bauer-1st/spring/chamomile-chardonnay-ice-cream"
},
"eventType": "ExhibitView",
"datestring": "2013-05-19T06:49:08.222013",
"datetime": {
"$date": 1368946148222.013
},
"context": {
"sessionId": "wde1869d6c0e4ad2845303efebe265a7|1368945307.23",
"isIos": false,
"loggedIn": true,
"serverDatetime": {
"$date": 1368946148222.013
},
"accessToken": "01d79fa98a7b862454b891ab4dc80ef5",
"appVersion": "1.0",
"serverDatestring": "2013-05-19T06:49:08.222013",
"ip": "115.135.66.198",
"userId": "01ddad1ca1babaf4b7a89d3de55c2081152",
"robot": false,
"agent": "inkling-webclient",
"clientAPIVersion": 5,
"method": "POST",
"host": "api.inkling.com",
"APIVersion": 5,
"deviceId": "wde1869d6c0e4ad2845303efebe265a7",
"path": "/events/",
"userAgent": "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.31 (KHTML, like Gecko) Chrome/26.0.1410.64 Safari/537.31",
"openInkling": true,
"appIdentifier": "inkling-webclient",
"isMobile": false
},
"s9id": "a136ba594bdc46a6a00ce6124fbc642a"
}
But when I try to process this in Talend I get this error :
Exception in component tExtractJSONFields_2
net.sf.json.JSONException: Found starting '{' but missing '}' at the end. at character 0 of null
at net.sf.json.util.JSONTokener.syntaxError(JSONTokener.java:499)
at net.sf.json.util.JSONTokener.<init>(JSONTokener.java:85)
at net.sf.json.JSONObject._fromString(JSONObject.java:1201)
at net.sf.json.JSONObject.fromObject(JSONObject.java:165)
at net.sf.json.JSONObject.fromObject(JSONObject.java:134)
at rex.jsontest_0_1.JsonTest$1ConvertJSONString_tExtractJSONFields_2.isNeedAddRoot(JsonTest.java:697)
at rex.jsontest_0_1.JsonTest$1ConvertJSONString_tExtractJSONFields_2.generate(JsonTest.java:680)
at rex.jsontest_0_1.JsonTest.tFileInputFullRow_2Process(JsonTest.java:846)
at rex.jsontest_0_1.JsonTest.runJobInTOS(JsonTest.java:1407)
at rex.jsontest_0_1.JsonTest.main(JsonTest.java:1273)
What can be causing this problem? Attached image showing the job details.

Re: [resolved] JSON parse errors on well-formed data

DaveL — Fri, 06 Sep 2013 17:19:54 GMT

Seems like Talend doesn't like the '$' occurences as in:
"serverDatetime": {
"$date": 1368946148222.013
},"
If I take out the $ the parse error goes away.

topic Re: [resolved] JSON parse errors on well-formed data in Talend Studio

[resolved] JSON parse errors on well-formed data

Re: [resolved] JSON parse errors on well-formed data