Fetching the nth element of array

Question

I'm having a json with input:

{
  "customerId": "12345",
  "customerStatusTrail": [
    "INITIATED",
    "PENDING",
    "COMPLETED"
  ],
  "segment": "S1"
}

which I want to convert it to:

{
  "customerId": "12345",
  "customerStatusTrail": "COMPLETED",
  "segment": "S1"
}

The list of customerStatusTrail would not always be of size 3. It would always be different. I want to fetch the last element of list and use that in the output.

I'm not sure if there is facility in JOLT for such transformation to fetch the last element of list.

score 1 · Answer 1 · edited Sep 09 '21 at 14:10

1

Yes it is possible with JOLT with spec like this

[
  {
    "operation": "modify-overwrite-beta",
    "spec": {
      "customerStatusTrail": "=lastElement(@(1,&))"
    }
  }
]

You can refer Jolt List functions for more default methods

edited Sep 09 '21 at 14:10

Barbaros Özhan

59,113
10
31
55

answered Jul 19 '18 at 15:35

Samarth

773
1
6
14

Fetching the nth element of array

1 Answers1