Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tWriteJsonField long data type support

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]

Labels (6)
1 Reply
manodwhb
Champion II
Champion II

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