[resolved] JSON parse errors on well-formed data

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

All Replies
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.

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER 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

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch