Add default field to Jolt JSON transformation

Question

I'm trying to make a JSON transformation using JOLT and I think I'm close, but what I can't do is add in a new field to each one which doesn't currently appear.

I have read quite a few tutorials and this code below is what I would have expected to have worked. However it doesn't seem to add in the new "Name" field.

{
  "totalElements": 168,
  "columns": {
    "dimension": {
      "id": "variables/daterangehour",
      "type": "time"
    },
    "columnIds": [
      "1"
    ]
  },
  "rows": [
    {
      "itemId": "119050300",
      "value": "00:00 2019-06-03",
      "data": [
        120
      ]
    },
    {
      "itemId": "119050805",
      "value": "05:00 2019-06-08",
      "data": [
        98
      ]
    },
    {
      "itemId": "119050923",
      "value": "23:00 2019-06-09",
      "data": [
        172
      ]
    }
  ]
}

This is my jolt:

[
  {
    "operation": "default",
    "spec": {
      "name": "chart1"
    }
  },
  {
    "operation": "shift",
    "spec": {
      "rows": {
        "*": {
          "value": "[&1].date",
          "data": {
            "*": "[&2].data"
          }
        }
      }
    }
  }
 ]

This was output:

[ {
  "date" : "00:00 2019-06-03",
  "data" : 120
}, {
  "date" : "05:00 2019-06-08",
  "data" : 98
}, {
  "date" : "23:00 2019-06-09",
  "data" : 172
} ]

I wanted it to be like this though:

[ {
  "name" : "graph1",
  "date" : "00:00 2019-06-03",
  "data" : 120
}, {
  "name" : "graph1",
  "date" : "05:00 2019-06-08",
  "data" : 98
}, {
  "name" : "graph1",
  "date" : "23:00 2019-06-09",
  "data" : 172
} ]

Can anyone please tell me where I am going wrong? Apparently default is used to add in a new item but it doesnt seem to do anything.

Magda · Accepted Answer · 2019-07-11 10:32:50Z

1

You should put sth like this: "#chart1": "[&1].name" Hash puts harcoded value and then you do not need operation default. Or if you want to use operation default:

[
  {
    "operation": "shift",
    "spec": {
      "rows": {
        "*": {
          "value": "[&1].date",
          "data": {
            "*": "[&2].data"
          }
        }
      }
    }
  },
  {
    "operation": "default",
    "spec": {
      "*": {
        "name": "chart1"
      }
    }
  }
]

answered Jul 11, 2019 at 10:32

Magda

4924 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

J.Zil Over a year ago

Superb! Thank you so much Magda. This is really helpful.

Collectives™ on Stack Overflow

Add default field to Jolt JSON transformation

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related