Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
DaveL
Contributor III
Contributor III

[resolved] JSON parse errors on well-formed data

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.
0683p000009MB8h.jpg
Labels (4)
1 Solution

Accepted Solutions
DaveL
Contributor III
Contributor III
Author

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

View solution in original post

1 Reply
DaveL
Contributor III
Contributor III
Author

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