How to convert array to String using JSON Query

Question

{
   "pull_request": {
     "patch_url": null,
   },
   "created_at": "2012-11-14T15:25:33Z",
   "comments": 0,
   "labels": [
     {
       "color": "ededed
     }
   ],
   "id": 8356941,
   "assignees": [
      {
        "login": "Paul",
        "id": 444
      },
      {
        "login": "Steve",
        "id": 222
       }
    ]

By JSON Query

assignees[*].login, getting below output.

["Paul","Steve"]

But required as comma separated string without quotes as below,

Paul, Steve

How to do this in JSON Query?

assignees[*].login.join(',') – Nikhilesh K V Jul 14 '21 at 06:02 — Nikhilesh K V, Jul 14 '21 at 06:02

mk23 · Answer 1 · 2021-07-14T06:09:45.980

0

You can use JSON.stringify as below:

JS

const obj = {
  "pull_request": {
    "patch_url": null,
  },
  "created_at": "2012-11-14T15:25:33Z",
  "comments": 0,
  "labels": [{
    "color": "ededed"
  }],
  "id": 8356941,
  "assignees": [{
      "login": "Paul",
      "id": 444
    },
    {
      "login": "Steve",
      "id": 222
    }
  ]
}
const myJSON = JSON.stringify(obj);
console.log(myJSON);

If you would like to get comma seperated string for the array it can be done using join()

const names = ["Paul","Steve"];
console.log(names.join(", "));

edited Jul 14 '21 at 06:09

answered Jul 14 '21 at 06:02

mk23

1,257
1
12
25

that's not what he asked for. – Always Helping Jul 14 '21 at 06:06
This is in Javascript, my use case is to take value from JSON Query alone. Using below site jsonquerytool.com, how to get the string values – Jegan Muthu Jul 17 '21 at 09:37

score 0 · Answer 2 · answered Jul 14 '21 at 06:02

0

As long as your title "How to convert array to String" is right, this will work:

assignees[*].login.toString()

answered Jul 14 '21 at 06:02

sandrooco

8,016
9
48
86

How to convert array to String using JSON Query

2 Answers2