Concatenate 2 values in the JSON Path field of a External Lookup Workfront field

Question

Hi All,I'm experimenting with External Lookup custom form fields in Workfront.I wonder if there is a way to concatenate 2 (or more) values from the response of the external application so that they are both visible in the option list.For example, if the external lookup returnes a JSON that includes both ID and name values, what would I put in the JSON Path field instead of $.data[*].name, to display e.g. "Name (ID)" as option in the drop down.This would be useful in situations where I have no control over the external app, i.e. I can't make the API to return concatenated values in the first place (e.g. if the external URL points to the Workfront API).Thank you for your input.Tibor

Rafal_Bainie · Accepted Answer

Hi Tibor,I think JSON path don't have such functionality. For external lookup other Workfront areas I used what I think you might have already tried, a custom calculated field that would contain required concatenation.Good luck!Rafal

VynetaRy · Answer

I have played with this some and I can get close. Maybe someone can pick it up from here and get the rest of the way there.

If I put this in the JSON path, I get the full list of the first element concatenated with the full list of the second element.

$.concat($.data[*].name,' ',$.data[*].ID)

so I get, name1name2name3 ID1ID2ID3

I have tried several different ways of rearranging to get the concatenation to apply to each element, but I haven't gotten there quite yet. I would love for a JSON Path expert to find my glitch and get this working, because I could use it, too. I have tried $.data.name, .name, data[*].concat(.name,' ',.ID) and several others. No luck yet, but I'm not giving up.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded