Break down JSON properties to array of objects

Question

I am trying to transform a simple JSon object into an array of objects with keys and values broken out, but I'm not sure how to quite get there.

I have tried this a number of ways but the closest I got was to create an object with two arrays, instead of an array with multiple objects with two properties each:

EDIT: I am trying to write a spec which would take any object, not this specific object. I do not know what the incoming object will be other than it will have simple properties (values will not be arrays or other objects).

Sample Input:

{
  "property": "someValue",
  "propertyName" : "anotherValue"
}

Expected Output:

{
    "split_attributes": [
        {
            "key" : "property",
            "value": "someValue"
        },
        {
            "key" : "propertyName",
            "value" : "anotherValue"
        }
    ]
}

My spec so far:

{ 
  "operation": "shift",
    "spec": {
       "*": {
        "$": "split_attributes[#0].key",
        "@": "split_attributes[#0].value"
      }
    }
  }

Produces

{
  "split_attributes" : [ 
     {
      "key" : [ "property", "propertyName" ], 
      "value" : [ "someValue", "anotherValue"]
     }
  ]
}

davdic · Accepted Answer · 2018-05-10 17:36:20Z

1

SOLUTION

I was pretty close, and after looking at the tests, the solution was obvious (it's identical to one of the tests)

{ 
  "operation": "shift",
    "spec": {
       "*": {
        "$": "split_attributes[#2].key",
        "@": "split_attributes[#2].value"
      }
    }
  }

From what it seems, I was creating an array but I was looking at the wrong level for an index to the new array. I'm still fuzzy on the whole # level (for example where in the "tree" (and of which object) is #0, #1 and #2 actually looking).

answered May 10, 2018 at 17:36

davdic

2591 gold badge3 silver badges10 bronze badges

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

Collectives™ on Stack Overflow

Break down JSON properties to array of objects

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related