question Re: Date Transformation using JoltTransform in Support Questions

Date Transformation using JoltTransform

Griggsy — Wed, 02 Nov 2022 08:57:57 GMT

Hello all, NiFi Jolt question

Does anyone know if it's possible to convert timestamp formats using Jolt using 'field.value' the way you can using update Record?

I'm aware that I can use an attribute value in Jolt to convert a field, like:

"date" : "${timestamp:toDate('yyyy-MM-dd HH:mm:ss'):toNumber()}"

but I was wondering if this function can be done using Jolt on incoming 'field.values', have tried using the default spec as below but it doesn't change the format.

Thanks in advance.

Andy

Re: Date Transformation using JoltTransform

Faerballert — Wed, 02 Nov 2022 09:51:49 GMT

Hello,

this does not seem to be possible for me.

You can use before JOLTTransformation the Processor EvaluateJsonPath to store the date to an attribute and afterwards you could do your convertation with expression language function in JOLT.

Greetings

Re: Date Transformation using JoltTransform

mburgess — Wed, 02 Nov 2022 12:37:31 GMT

Agreed, you do not have access to the fields in either the incoming or outgoing JSON objects using Expression Language in the spec.