topic Re: How to reference a list item in a data pill expression in Workato Pros Discussion Board

How to reference a list item in a data pill expression

Waldy — Wed, 16 Apr 2025 08:24:06 GMT

I'm trying to reference the ID property of a list item in a data pill expression. I could do a for each and loop through to get the relevant item, but I guess there must be a way to do this via the expression.

This expression gives me an error when I try to test the recipe.

Re: How to reference a list item in a data pill expression

Bhagya_pola — Wed, 16 Apr 2025 09:06:39 GMT

Hello @Waldy
you can give it a try using pluck formula
for example:

This is my json:

In the above json I'm trying to fetch the first person age using the name, here how I am doing it

Since I'm trying to fetch age from matching person which is Jhon and, I am using indexing to get first value in case of multiple records.
Once go through and modify this formula according to your requirement.

Re: How to reference a list item in a data pill expression

gary1 — Wed, 16 Apr 2025 18:37:09 GMT

The label of the data pill is often not the "API Name" which is the key need to you use in the expression. Hover over the data pill and you can see the API Name. It might just be a casing thing, like "Name" versus "name", or it might be something entirely different.

Re: How to reference a list item in a data pill expression

Waldy — Thu, 17 Apr 2025 13:19:07 GMT

Thanks @Bhagya_pola, yes that worked.

Re: How to reference a list item in a data pill expression

Waldy — Thu, 17 Apr 2025 13:19:44 GMT

Thanks @gary1 , yes I needed to change to lower case