JMESPath join output and strip unwanted chars

Since you do have an array, you will first need to target the first element of the array, to get rid of it. Since an array is 0-based, this can easily be achieved via:

data[0]

which gives

{
  "compartment-id": "CompartmentID-123",
  "defined-tags": {},
  "display-name": "Test-123",
  "freeform-tags": {},
  "id": "ID-ABC",
  "kms-key-id": "",
  "lifecycle-state": "ACTIVE"
}

Then, in order to create the string you are looking for, you can use the join function, that accepts, as parameter, a glue character and array.

You can get the array you look for pretty easily, using filters and multiselect lists:

data[0].[id, "display-name"]

which gives

[
  "ID-ABC",
  "Test-123"
]

Now we just need to apply the join function on top of all this:

data[0].join(',', [id, "display-name"])

which finally gives:

"ID-ABC,Test-123"

Additional notes on quoting in JMESPath:

• 'some-string'
  

  is a raw literal string and won't be interpreted

• `some-string`
  

  is another form of raw literal string and won't be interpreted

• "some-string"
  

  is a literal expression and will be interpreted

So:

data[0].join(',', [id, "display-name"])

and

data[0].join(`,`, [id, "display-name"])

are two strictly equals queries.

While

data[0].join(',', [id, 'display-name'])

has a totally different meaning and would end you with the string display-name being the second element of your array, so it will result in

"ID-ABC,display-name"

All of this based on the JSON structure:

{
   "data":[
      {
         "compartment-id":"CompartmentID-123",
         "defined-tags":{},
         "display-name":"Test-123",
         "freeform-tags":{},
         "id":"ID-ABC",
         "kms-key-id":"",
         "lifecycle-state":"ACTIVE"
      }
   ]
}