Help in fetching array field using format_map in workato

[amaan]

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

[gary1]

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

[amaan]

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.
 

[shivakumara]

Hi @amaan ,
Here is one of the solution, 

Please let me know if you have any question.

Thanks and Regards,
Shivakumara K A

[amaan]

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.