Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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.