jolt concatenate array elements to single object

Question

I started with Jolt, but I can't concatenate the elements of the array to single string,

I have json like this:

{
  "partNb": "1234",
  "partDescriptions": [
    {
      "country": "GB",
      "language": "en",
      "content": "1 tool description in en_GB"
    },
    {
      "country": "GB",
      "language": "en",
      "content": "2 tool description in en_GB"
    }
  ]
}

and with jolt spec:

[
  {
    "operation": "shift",
    "spec": {
      "partNb": "id",
      "partDescriptions": {
        "*": {
          "content": "description"
        }
      }
    }
  }
]

For this I have this output:

{
  "id" : "1234",
  "description" : [ "1 tool description in en_GB", "2 tool description in en_GB" ]
}

but how to get result like this?:

{
  "id" : "1234",
  "description" :  "1 tool description in en_GB , 2 tool description in en_GB" 
}

Milo S · Accepted Answer · 2018-09-03 17:26:22Z

2

Spec

[
  {
    "operation": "modify-overwrite-beta",
    "spec": {
      "description": "=join(', ',@(1,description))"
    }
  }
]

answered Sep 3, 2018 at 17:26

Milo S

4,5861 gold badge22 silver badges22 bronze badges

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

1 Comment

Marek Over a year ago

Thanks for this answer, but the result is : "description" : "{country=GB, language=en, content=1 tool description in en_GB}, {country=GB, language=en, content=2 tool description in en_GB}"

Sergey Shcherbakov · Accepted Answer · 2019-12-19 17:34:47Z

2

To get only content fields concatenated into descriptions:

[
  {
    "operation": "shift",
    "spec": {
      "partDescriptions": {
        "*": {
          "content": {
            "@": "content"
          }
        }
      }
    }
  },
  {
    "operation": "modify-overwrite-beta",
    "spec": {
      "description": "=join(', ', @(2,content))"
    }
  }
]

Output:

{
  "content" : [ "1 tool description in en_GB", "2 tool description in en_GB" ],
  "description" : "1 tool description in en_GB, 2 tool description in en_GB"
}

answered Dec 19, 2019 at 17:34

Sergey Shcherbakov

4,8824 gold badges44 silver badges72 bronze badges

Collectives™ on Stack Overflow

jolt concatenate array elements to single object

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related