Support Questions
Find answers, ask questions, and share your expertise

ConvertRecord JsonRecrodSetWriter everything as string

Expert Contributor

Hi,

 

Is there a way for the convertRecord with JsonRecordSetWrite to to produce the json values as string (i.e dont infer any schema). Im having an issue where some the fields are read as number type but when the conversion happens it fails because there are some hidden characters (possible unicode or carriage return) that causes the conversion to fail with exception java.lang.NumberFormatException!

Input (XML): Notice the whitesapce at the end

...

<reference_number>101752598 </reference_number>

...

Expected Json Outputl

{

...

"reference_number":"101752598 "

...

}

 

and not

 

{

...

"reference_number":101752598

...

}

0 REPLIES 0
; ;