Concatenation of JSON Arrays/Objects using Groovy

Question

How can two independent different JSON Arrays or JSON Objects be merged or concatenated and treated as a single JSON Object using Java or Groovy.

See below sample JSON independent Objects i have First one holds Duties information

[
  {
    "code": "A0001",
    "description": "Do strategic planning for long range goals of the university"
  },
  {
    "code": "A0002",
    "description": "Administer budgets in excess of 1,000,000"
  }]

Second JSON object holds Certificates infomation

 [
  {
    "code": "CPA",
    "description": "Certified Public Accountant"
  },
  {
    "code": "CPR",
    "description": "Cardiopulmonary Resuscitation"
  },
  {
    "code": "ELE",
    "description": "Electrician's License"
  }]

I need to concatenate and access both the JSONs in below format `

{
  "duties":
  [{
    "code": "A0001",
    "description": "Do strategic planning for long range goals of the university"
  },
  {
    "code": "A0002",
    "description": "Administer budgets in excess of 1,000,000"
  }],
  "Certificates":
  [
  {
    "code": "CPA",
    "description": "Certified Public Accountant"
  },
  {
    "code": "CPR",
    "description": "Cardiopulmonary Resuscitation"
  },
  {
    "code": "ELE",
    "description": "Electrician's License"
  }
  ]
  }

Please let me know the option available to get this done. Thanks

given the trivial structure you could just concat the strings and plaster the wrapping two structures in between. — cfrick
– cfrick, Commented Mar 4, 2015 at 8:44

Opal · Accepted Answer · 2015-03-04 10:04:20Z

3

It can be done e.g. in the following way:

import groovy.json.*

def json1 = """[
  {
    "code": "A0001",
    "description": "Do strategic planning for long range goals of the university"
  },
  {
    "code": "A0002",
    "description": "Administer budgets in excess of 1,000,000"
  }]"""

 def json2 = """[
  {
    "code": "CPA",
    "description": "Certified Public Accountant"
  },
  {
    "code": "CPR",
    "description": "Cardiopulmonary Resuscitation"
  },
  {
    "code": "ELE",
    "description": "Electrician's License"
  }]"""

  def duties = new JsonSlurper().parseText(json1)
  def certs = new JsonSlurper().parseText(json2)  

  println JsonOutput.prettyPrint(JsonOutput.toJson ([duties: duties, certificates: certs]))

edited Mar 4, 2015 at 10:04

answered Mar 4, 2015 at 5:44

Opal

85.6k29 gold badges201 silver badges220 bronze badges

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

1 Comment

MaSu Over a year ago

Thanks Opal. Super. The solution looks great and works like a char,

Collectives™ on Stack Overflow

Concatenation of JSON Arrays/Objects using Groovy

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