Jolt transform for nested json unexpected output

Question

I have the below JSON and need to filter based on field

[
  {
    "firstname": "ABC",
    "lastname": "PQR",
    "id": 1,
    "address": {
      "city": "LA",
      "zipcode": "123",
      "addressType": "Home",
      "status": "Active"
    },
    "department": {
      "id": "12",
      "manager": "tyx",
      "extraInfo": "N/A"
    }
  },
  {
    "firstname": "MNO",
    "lastname": "LLL",
    "id": 2,
    "address": {
      "city": "TX",
      "zipcode": "234",
      "addressType": "Home",
      "status": "Active"
    },
    "department": {
      "id": "123",
      "manager": "tyxx",
      "extraInfo": "N/A"
    }
  }
]

I use the below jolt spec

[
  {
    "operation": "shift",
    "spec": {
      "*": {
        "address": {
          "status": {
            "Active": {
              "@2": "[]"
            }
          }
        }
      }
    }
  }
]

which gives

I need the whole JSON not only field from address, I would like to have first name, last name,id and department in output ,please help.

Barbaros Özhan · Accepted Answer · 2025-01-15 15:17:33Z

1

You can start with nesting other elements within an others object, and go on like this :

[
  {
    "operation": "shift",
    "spec": {
      "*": {
        "*": "[&1].others.&",
        "address": "[&1].&"
      }
    }
  },
  {
    "operation": "shift",
    "spec": {
      "*": {
        "address": {
          "status": {
            "Active": {
              "@3,others": { "*": "&5.&" },
              "@2": "&4.&3"
            }
          }
        }
      }
    }
  },
  {
    "operation": "shift",
    "spec": {
      "*": "[]"
    }
  }
]

the demo on the site Jolt Transform Demo Using v0.1.1

( Notice below that the second status is Inactive within my demo example ) :

edited Jan 15 at 15:17

answered Jan 15 at 13:17

Barbaros Özhan

65.9k11 gold badges36 silver badges64 bronze badges

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

3 Comments

Dot Net Dev 19 Jan 15 at 13:47

Thanks , but If do with 3 json records I get null for InActive status

Dot Net Dev 19 Jan 15 at 14:09

can you pls have a look?

Barbaros Özhan Jan 15 at 15:18

Yes, you're right @DotNetDev19 , just fixed it.

Collectives™ on Stack Overflow

Jolt transform for nested json unexpected output

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related