topic Re: Unable to see formula mode in Add items to List Batch Action in Workato Pros Discussion Board

Unable to see formula mode in Add items to List Batch Action

amit_mohanty88 — Fri, 17 Oct 2025 03:33:08 GMT

I have a usecase where i need to call a rest service get response which contains repeating element node so i am capturing the response in Add items to List (Batch) Action . While adding the source list in Add Item to list one of the repeating element i want to put a condition if source repeating element size is zero loop should not happen . how to do this . Currently issue am getting is if source element node size is zero then in Add items to List (Batch) Action the output of the element is coming [] . Screenshot attached . Basially i dont need the elment itself instead of elment coming as []

Re: Unable to see formula mode in Add items to List Batch Action

gary1 — Fri, 17 Oct 2025 03:41:03 GMT

I'm not totally sure I understand the situation, but there's no way to use formula mode on a list items. Workato simply doesn't allow it.

If you want to avoid the loop on the root array, you can use a conditional before have to test if the list size is zero.

If you want to do this on a nested array within the root array, you can't do it formulaically.

There are ways to do this without using formulas, but I would need more information and examples to understand the situation and offer a solution.

Re: Unable to see formula mode in Add items to List Batch Action

rajeshjanapati — Fri, 17 Oct 2025 06:21:30 GMT

Hi @amit_mohanty88,

try once with PARSE JSON by passing complete API response into PARSE JSON step, where you can extract each field as a data pill and you can easily check the condition, hope it will be helpful.

Thanks & Regards,

J Rajesh Kumar.

Re: Unable to see formula mode in Add items to List Batch Action

Bhagya_pola — Sat, 18 Oct 2025 14:35:48 GMT

Hello @amit_mohanty88 ,

I still don't get why you are using add items to list if the response is of repeating items like list of objects or something, since the response schema is consistent, you can define the response schema in the http step itself

Re: Unable to see formula mode in Add items to List Batch Action

harish_t_reddy — Tue, 21 Oct 2025 04:21:12 GMT

I totally understand your situation, Workato won't allow you to define the formula mode for the list data pill. So, I will suggest you create one list on the above step and then you can use the Repeat action based on the requirement.

Re: Unable to see formula mode in Add items to List Batch Action

amit_mohanty88 — Mon, 03 Nov 2025 12:36:07 GMT

Thank you all for your Response i created Response as text/plain so using string formula gsub able to remove [] . The caller system accepts text/plain and converts to application/json to the source .