cancel
Showing results for 
Search instead for 
Did you mean: 

Help in fetching array field using format_map in workato

amaan
Deputy Chef I
Deputy Chef I

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"}').

1 ACCEPTED SOLUTION

amaan
Deputy Chef I
Deputy Chef I

workato sol2.png

 

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.
workato sol.png

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

View solution in original post

6 REPLIES 6

amaan
Deputy Chef I
Deputy Chef I

workato sol2.png

 

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.
workato sol.png

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

shivakumara
Executive Chef III
Executive Chef III

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