Skip to main content
Griggsy
Gold ⭐️
Nov 2, 2022 8:57 AM UTC
Solved

Date Transformation using JoltTransform

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.

 

Griggsy_0-1667379148290.png

 

Thanks in advance.

 

Andy

Faerballert
Gold ⭐️
Nov 2, 2022 9:51 AM UTC

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

2 replies

Faerballert
Gold ⭐️
Nov 2, 2022 9:51 AM UTC

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

Translate
mburgess
Gold ⭐️⭐️⭐️
Gold ⭐️⭐️⭐️
Nov 2, 2022 12:37 PM UTC

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

Translate