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