question Re: toNumber() function NOT returning a number in Support Questions

toNumber() function NOT returning a number

ChuckE — Wed, 08 Feb 2023 22:44:59 GMT

When attempting to insert a timestamp in milliseconds into a flowfile using the UpdateRecord processor, the timestamp comes out expressed as a string (first image) despite the fact that I've explicitly cast it as a number (second image). How can I get this expressed as a number like it is supposed to?

Re: toNumber() function NOT returning a number

ChuckE — Thu, 09 Feb 2023 02:02:51 GMT

I resorted to using an Avro schema with the RecordsetWriter in order to coerce the values into numbers. So even though the documentation says toNumber's return type is "Number", it doesn't get expressed that way. But the schema fixes it so its all good.