need Jolt Spec to convent JSON array key name to updated name

Question

Original JSON message:

[
  {
    "correlationId": "12345",
    "payloadFormat": "Money",
    "payload": {
      "stateName": "TX",
      "location": "south",
      "name": "Dallas",
      "pop": "2M"
    }
  },
  {
    "correlationId": "ed1e3",
    "payloadFormat": "Cash",
    "payload": {
      "stateName": "CA",
      "location": "west",
      "name": "LosAngeles",
      "pop": "4M"
    }
  }
]

Output should be in below format:

[
  {
    "correlationId": "12345",
    "payloadFormat": "Money",
    "payload": {
      "California": "TX",
      "MontGomery": "south",
      "City": "Dallas",
      "ID": "2M"
    }
  },
  {
    "correlationId": "ed1e3",
    "payloadFormat": "Cash",
    "payload": {
      "California": "CA",
      "MontGomery": "west",
      "City": "LosAngeles",
      "ID": "4M"
    }
  }
]

Jagadesh · Accepted Answer · 2020-10-22 09:34:58Z

2

Check this spec,

[
  {
    "operation": "shift",
    "spec": {
      "*": {
        "correlationId": "[&1].correlationId",
        "payloadFormat": "[&1].payloadFormat",
        "payload": {
          "stateName": "[&2].payload.California",
          "location": "[&2].payload.MontGomery",
          "name": "[&2].payload.City",
          "pop": "[&2].payload.ID"
        }
      }
    }
  }
]

answered Oct 22, 2020 at 9:34

Jagadesh

2,1162 gold badges20 silver badges32 bronze badges

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

1 Comment

Rajesh Kumar singh Over a year ago

Thanks A Lot, My issue gets resolved with this solution

Collectives™ on Stack Overflow

need Jolt Spec to convent JSON array key name to updated name

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