yesterday
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!
Solved! Go to Solution.
yesterday
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
yesterday
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