JSON string array to object array using JOLT

Question

For a student project I have to improve data quality. The first step is to request an API. Secondly, we have to edit the json structure.

This is the response from the API :

Now using jolt I want to have a result like that :

{
  "lists": [
    {
      "id": 0,
      "clientId": 451,
      "name": "test",
      "custom_value": "953"
    },
    {
      "id": 2,
      "clientId": 1010,
      "name": "hello",
      "custom_value": "610"
    }
  ]
}

Currently, I can access to data values but I don't know how to separate it into array with objects.

My 'code' :

[
  {
    "operation": "shift",
    "spec": {
      "lists": {
        "*": {
          "*": {
            "*": {
              "$0": "lists"
            }
          }
        }
      }
    }
  }
]

Where I'm wrong and how can I edit the structure of the original array properly?

Milo S · Accepted Answer · 2017-03-09 22:51:13Z

7

Spec

[
  {
    "operation": "shift",
    "spec": {
      "lists": {
        "*": { // lists array
          "0": "lists[&1].id",
          "1": "lists[&1].clientId",
          "2": "lists[&1].name",
          "3": "lists[&1].custom_value"
        }
      }
    }
  }
]

answered Mar 9, 2017 at 22:51

Milo S

4,5861 gold badge22 silver badges22 bronze badges

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

1 Comment

Alexandre Over a year ago

So many thanks!! I spent so many time and the answer is really simple... You make my day

Collectives™ on Stack Overflow

JSON string array to object array using JOLT

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