Question 110220 in Json Question posted in
Our archive of expertly curated questions and answers provides insights and solutions to common problems related to this popular data interchange format. From parsing and manipulating JSON data to integrating it with various programming languages and web services, our archive has got you covered. Start exploring today and take your JSON skills to the next level

Json – Pull elements out of two arrays to make a "flat" item list

I need to merge array data from two different arrays from the Input JSON and make a flat list of items in the Output JSON. The first array contains the key required for the output and the second array contains the value.

So far, all my attempts at a spec haven’t even come close, which is why I haven’t listed one. Please see the Input and Desired Output below. Thanks for any help!!

Input JSON :

{
  "data": [
    {
      "2": {
        "value": "DC1"
      },
      "3": {
        "value": 5
      }
    },
    {
      "2": {
        "value": "DC2"
      },
      "3": {
        "value": 10
      }
    }
  ],
  "fields": [
    {
      "id": 2,
      "label": "DataCenter",
      "type": "text"
    },
    {
      "id": 3,
      "label": "CCount",
      "type": "numeric"
    }
  ],
  "metadata": {
    "numFields": 2,
    "numRecords": 2,
    "skip": 0,
    "totalRecords": 2
  }
}

Desired Output JSON:

[
  {
    "DataCenter": "DC1",
    "CCount": "5"
  },
  {
    "DataCenter": "DC2",
    "CCount": "10"
  }
]
Tags:

2

Answers


  1. 0

    You can use this spec:

    [
  {
    "operation": "shift",
    "spec": {
      "data": "&",
      "fields": {
        "*": {
          "label": "fields.@(1,id)"
        }
      }
    }
  },
  {
    "operation": "shift",
    "spec": {
      "data": {
        "*": {
          "*": {
            "*": "[&2].@(4,fields.&1)"
          }
        }
      }
    }
  }
]

    In your desired output CCount value is a string, You can add the below spec to change an integer to a string.

    ,
  {
    "operation": "modify-overwrite-beta",
    "spec": {
      "*": {
        "CCount": "=toString"
      }
    }
  }

    enter image description here

    Login or Signup to reply.
  2. 0

    You might reciprocally match id value of fields array vs. the object keys of the data array within a common object within the first shift transformation spec in order to prepare for the second one in which we tile the attributes into their individual objects such as

    [
  {
    "operation": "shift",
    "spec": {
      "*": { // represents the node for both "data" and "fields" arrays
        "*": {
          "*": {
            "value": "&1.&",
            "@1,label": "@2,id.&"
          }
        }
      }
    }
  },
  {
    "operation": "shift",
    "spec": {
      "*": {
        "value": {
          "*": "[&].@2,label"
        }
      }
    }
  }
]

    the demo on the site http://jolt-demo.appspot.com/ is

    enter image description here

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search