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

[tibormolnar]

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 solution]

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