CODEWITHSUNDEEP
jsonapache-nifijolt
Grigory Skvortsov
Grigory Skvortsov

Reputation: 463

Apache Nifi Transfrom json field to timestamp

I have the json with unix-timestamp field. I like to extract year from it.

So, for example:

{"eventno": "event1",
"unixtimestamp": 1589379890}

Expected result:

{"eventno": "event1",
"unixtime": 2020}

I try to do this using JoltTransfromJSON and NiFi expression language, but my attempts failed. One of them:

[
  {
    "operation": "shift",
    "spec": {
      "unixtime": "${unixtimestamp:multiply(1000):format('yyyy', 'GMT')}"
    }
  }
]

How can I transform it?

Upvotes: 0

Views: 1356

Answers (1)

steven-matison
steven-matison

Reputation: 1659

@GrigorySkvortsov

The Expression Language syntax should be:

${attribute:expressionLanguage():functions()}

If what you have above isn't just a typo retest after removing the } after unixtimestamp.

Unit Test outside of Jolt Transform with updateAttribute Processor to dial in the correct Expression Language chain. Here is an example I made to test it:

enter image description here

Then the 4 values are: d

Upvotes: 2

Related Questions