topic Re: tServiceNowOutput in Talend Studio

tServiceNowOutput

mcfarlandt — Sat, 16 Nov 2024 01:35:09 GMT

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)

Re: tServiceNowOutput

Anonymous — Thu, 27 Aug 2020 07:49:44 GMT

1-Version

2-Patches applied so far

3-Stack trace?

Re: tServiceNowOutput

mcfarlandt — Thu, 27 Aug 2020 13:18:52 GMT

1-Talend Version 7.2

2-Not sure what you mean?

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-1-with-error

The payload being generated is:

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