topic Re: Help in fetching array field using format_map in workato in Workato Pros Discussion Board

Help in fetching array field using format_map in workato

amaan — Thu, 22 Jan 2026 12:21:52 GMT

Scenario is like -
Input array : [name, error: [code: "test", detail : "missing test"]]
So im currently querying like Input array.format_map('Name : %{name}, Error Detail : %{"what should be the query here to get detail field from error list in input array"}').

Re: Help in fetching array field using format_map in workato

gary1 — Thu, 22 Jan 2026 19:45:06 GMT

Your input array looks incorrectly formatted. Can you provide an actual example, something that is correctly formatted?

Re: Help in fetching array field using format_map in workato

amaan — Fri, 23 Jan 2026 05:19:59 GMT

Below is the exact data for reference @gary1

"results": [ { "external_id": "xyz", "index": 0, "errors": [ { "code": "CustomObjectRecordCreateOrUpdateByExternalIdFailed", "title": "Record validation errors", "detail": "Name cannot be blank" } ], "status": "Failed" } ]

So i need to use format_map on result array and pluck detail field from errors list.

Re: Help in fetching array field using format_map in workato

shivakumara — Fri, 23 Jan 2026 08:00:09 GMT

Hi @amaan ,
Here is one of the solution,

Please let me know if you have any question.

Thanks and Regards,
Shivakumara K A

Re: Help in fetching array field using format_map in workato

amaan — Fri, 23 Jan 2026 08:43:11 GMT

Hi @shivakumara , thanks for the input but this approach does not solve the requirement i want each object to aligned with proper external id along with its error detail , the solution you posted will give first object detail of errors list only and that too at the end, not along the external ids.

Re: Help in fetching array field using format_map in workato

amaan — Fri, 23 Jan 2026 09:48:46 GMT

I got the solution for the problem , we just need to extract both the field in array format then use format_map %s notation to fetch the value from nested array.

You can check out the documentation as well herehttps://docs.workato.com/en/formulas/array-list-formulas.html#format-map

Re: Help in fetching array field using format_map in workato

shivakumara — Fri, 23 Jan 2026 14:11:04 GMT

Glad to know that, @amaan please kindly specify the problem/ requirements clearly which help us to provide required solutions.
In your requirement it is not mentioned. But anyway, happy to hear that you received the solution.

Thanks