Combine two values of an array

App Building
1

I have an query that is returning a simple array:

[
  {
    "id": "C0101",
    "type": "AIRLINK",
    "description": "BACKHAUL"
  },
  {
    "id": "C0102",
    "type": "AIRLINK",
    "description": "CABLE END"
  },
  {
    "id": "C0103",
    "type": "AIRLINK",
    "description": "CPE"
  }
]

And on a select box component, I am using the ID as my 'values' field, like this:
{{formatDataAsObject(CauseCodes.data).id}}

But for the 'labels' field, how can I join the "type" and "description" values into a single line?
For instance, I would each label to look like:

AIRLINK - BACKHAUL
AIRLINK - CABLE END
AIRLINK - CPE

Currently, I only have the 'description' field set as my 'label', like this:
{{formatDataAsObject(CauseCodes.data).description}}

Any suggestions would be appreciated!
Thanks

2

Good morning @leviself56

Is using Query JSON with SQL useful here?

Andrew

3

The API endpoint where I am gathering my data is set and I am not using SQL.

4

Try using this:

{{formatDataAsObject(CauseCodes.data.map(obj => ({combined: obj.type + " - " + obj.description }))).combined }}

I did not test it. Hope it works

5

Perfect! Thanks so much!