Json transformation from key value to nested array

Question

I was trying to have a key value pair mapped to an array, distinguishing each value as a type using jolt transform spec

Input json

{
"testurl": "someurl",
"website": "someurl2"
}

tried this spec



[
  {
    "operation": "shift",
    "spec": {
      "testurl": "Urls[].testurl",
      "website": "Urls[].website"
    }
  },
  {
    "operation": "shift",
    "spec": {
      "Urls": {
        "*": {
          "$": "Urls[&1].val"    
        }
      }
    }
  }
]

Expected result is like this

{
        "Urls": [{
            "url": "someurl",
            "val": "testurl"
        }, {
            "url": "someurl2",
            "val": "website"

        }]
    }

@Milo S can you answer this stackoverflow.com/questions/44144846/… — g. thornton
– g. thornton, Commented May 23, 2017 at 21:06

Milo S · Accepted Answer · 2017-01-22 19:16:51Z

3

Yes you can turn a set of Json key,value pair into an array.

It requires 2 shifts to be safe.

1st shift isolates all the properties you want to turn into an array.

2nd shift is able to use a "*" to then match all those items and place them an array.

Spec

[
  {
    "operation": "shift",
    "spec": {
      "testurl": "temp.testurl",
      "website": "temp.website"
    }
  },
  {
    "operation": "shift",
    "spec": {
      "temp": {
        "*": {
          "$": "Urls[#2].val",
          "@": "Urls[#2].url"
        }
      }
    }
  }
]

answered Jan 22, 2017 at 19:16

Milo S

4,5861 gold badge22 silver badges22 bronze badges

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

Collectives™ on Stack Overflow

Json transformation from key value to nested array

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related