Support Questions

Find answers, ask questions, and share your expertise

Date Transformation using JoltTransform

Contributor

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

1 ACCEPTED SOLUTION

Rising Star

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

View solution in original post

2 REPLIES 2

Rising Star

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

Super Guru

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