How to handle failed records separately in Workato Batch Processing?

dawidleman — Tue, 02 Sep 2025 14:26:55 GMT

Hi,

Is it possible to separate failed record from a batch action and perform logic on it? What I want to achieve is to process all successful records in the batch and separate the failed ones. Wondering if it's possible with Workato Batch Processing, or do I need to go through each record one by one.

Thanks!

Re: How to handle failed records separately in Workato Batch Processing?

shivakumara — Tue, 02 Sep 2025 16:18:20 GMT

Hi @dawidleman ,

In Workato, whether you can separate failed records from successful ones in a batch really depends on the connector:

If the connector returns per-record results in the batch response (for example, some database/Salesforce bulk actions or APIs that return an array of statuses), then you can directly filter the output list into successes and failures and handle them separately.
Reference: Salesforce batch operations | Workato Docs
If the connector only returns aggregate success/failure ( where the whole batch may fail without giving individual record details), then Workato won’t let you directly differentiate between failed and successful records. In this case, you need a workaround, such as:
- Running smaller batch sizes to isolate bad records.
- Falling back to record-by-record processing when the batch fails.

So, the short answer is: Yes, it’s possible if the connector supports record-level batch results. If not, you’ll need to design a workaround since Workato can’t inherently split failed vs successful records in those cases.

I hope this gives you a clarity on processing batch records.

Thanks and Regards,
Shivakumar K A

topic Re: How to handle failed records separately in Workato Batch Processing? in Workato Pros Discussion Board

How to handle failed records separately in Workato Batch Processing?

Re: How to handle failed records separately in Workato Batch Processing?