How to handle failed records separately in Workato Batch Processing?

[dawidleman]

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!

[shivakumara · Accepted solution]

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