tServiceNowOutput

[mcfarlandt]

I am getting a JSON exception as follows when I try to write to a tServiceNowOutput. Everything up until that point is working, data exists, and I have validated that the column I am trying to update (title) on the custom table exists.

Exception in component tServiceNowOutput_1 (SNOW_update)

java.lang.RuntimeException: Could not execute org.json.JSONException: A JSONObject text must begin with '{' at 1 [character 2 line 1]

at project.snow_update_0_1.SNOW_update.tDBInput_2Process(SNOW_update.java:3283)

[Anonymous]

1-Version

2-Patches applied so far

3-Stack trace?

[mcfarlandt]

1-Talend Version 7.2

2-Not sure what you mean?

3

Exception in component tServiceNowOutput_1 (SNOW_update)

java.lang.RuntimeException: Could not execute org.json.JSONException: A JSONObject text must begin with '{' at 1 [character 2 line 1]

at wdr_git.snow_update_0_1.SNOW_update.tDBInput_2Process(SNOW_update.java:3285)

at wdr_git.snow_update_0_1.SNOW_update.tServiceNowConnection_1Process(SNOW_update.java:1864)

at wdr_git.snow_update_0_1.SNOW_update.tDBConnection_1Process(SNOW_update.java:1686)

at wdr_git.snow_update_0_1.SNOW_update.tFileInputProperties_1Process(SNOW_update.java:1523)

at wdr_git.snow_update_0_1.SNOW_update.tPrejob_1Process(SNOW_update.java:1054)

at wdr_git.snow_update_0_1.SNOW_update.runJobInTOS(SNOW_update.java:4489)

at wdr_git.snow_update_0_1.SNOW_update.main(SNOW_update.java:4291)

[statistics] disconnected

Also found:

https://stackoverflow.com/questions/22062056/a-jsonobject-text-must-begin-with-at-1-character-2-line...

The payload being generated is:

{"data":[{"title":"Java Developer","sys_id_1":"27bbbfa5dbfdc090f76c308f7c9619fe"}]}