Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Date Transformation using JoltTransform

avatar
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

avatar
Expert Contributor

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

avatar
Expert Contributor

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

avatar
Master Guru

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