[resolved] JSON parse errors on well-formed data

Highlighted
Five Stars

[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.

Accepted Solutions
Highlighted
Five Stars

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

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


All Replies
Highlighted
Five Stars

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

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

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog