Identifying failed records on Salesforce Bulk Insert

💬 Queries and Resources
1

Hey Retool Community!

  1. My goal: Performing a bulk insert with Salesforce while being able to identify exactly which records succeeded and which failed.
  2. Issue: No matter which properties are passed to the bulk load, it only responds with id, success, and errors. No way to identify which of our original records it were

According to some online research, Salesforce Bulk API v1 guarantees to respond in the same order - meaning we should be able to simply map the insert results by index directly.
Salesforce Bulk API v2 does not, as far as we can tell, but it SHOULD echo back any additional properties provided.

Given that - are we safe to assume that Retool uses v1?
If not - how can we be certain of our success/fail records?

Thanks for any help!

3

So just updating here for any future reference -
Retool Support have updated me by email that:

We took a look, and it appears that Salesforce Bulk API v1 is being used for bulk operations, so it may be possible to map errors by index.