tWriteJsonField long data type support

Anonymous — Tue, 06 Feb 2018 05:33:40 GMT

I am getting below error if I use integer attribute in tWriteJsonField for a long data type. my input value is 1517461200000. I want this as number not as string(not in enclosed in double quotes). please suggest how could this be achieved.

Exception in component tWriteJSONField_2_In (ReadIntField)
net.sf.json.JSONException: java.lang.NumberFormatException: For input string: ""
at net.sf.json.xml.XMLSerializer.read(XMLSerializer.java:331)
at syncgatewaytorestapialertupdates.readintfield_0_1.ReadIntField.tWriteJSONField_2_InProcess(ReadIntField.java:1812)
at syncgatewaytorestapialertupdates.readintfield_0_1.ReadIntField$1ThreadXMLField_tWriteJSONField_2_Out.run(ReadIntField.java:740)
Caused by: java.lang.NumberFormatException: For input string: ""
at java.lang.NumberFormatException.forInputString(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)
at java.lang.Integer.valueOf(Unknown Source)
at net.sf.json.xml.XMLSerializer.setValue(XMLSerializer.java:1246)
at net.sf.json.xml.XMLSerializer.processObjectElement(XMLSerializer.java:1095)
at net.sf.json.xml.XMLSerializer.read(XMLSerializer.java:322)
... 2 more
[statistics] disconnected
Job ReadIntField ended at 12:47 05/02/2018. [exit code=1]

Re: tWriteJsonField long data type support

manodwhb — Tue, 06 Feb 2018 05:36:27 GMT

Use tMap/tConvert to conver the data type between source and tWriteJsonField.

topic Re: tWriteJsonField long data type support in Talend Studio

tWriteJsonField long data type support

Re: tWriteJsonField long data type support