force:data:bulk:upsert is a really convenient way to use the Salesforce bulk api
BUT there isn't a command to fetch the results once your job has finished, you have to go into the Salesforce UI and download them (batch by batch) or use some other method like the REST API to retrieve them
When doing a serious data import into Salesforce (several objects, hundreds of thousands of records etc) the Results of a Bulk API job are very important because:
a) for your successful rows, you want to know the Salesforce Id that got allocated (because you might well need that for a child object you're going to import next, etc. You cant always use externalids in all situations to relate objects)
b) for your failed rows (and in real life there are always failed rows) you want to know what the errors are - locking, invalid picklists, valdiation rules etc
So a new command something like ...
sfdx force:data:bulk:results --jobid 750xx000000005sAAA
... which then gives you all the results files (from each batch) concatenated together into one big CSV would be REALLY useful
Many thanks
force:data:bulk:upsert is a really convenient way to use the Salesforce bulk api
BUT there isn't a command to fetch the results once your job has finished, you have to go into the Salesforce UI and download them (batch by batch) or use some other method like the REST API to retrieve them
When doing a serious data import into Salesforce (several objects, hundreds of thousands of records etc) the Results of a Bulk API job are very important because:
a) for your successful rows, you want to know the Salesforce Id that got allocated (because you might well need that for a child object you're going to import next, etc. You cant always use externalids in all situations to relate objects)
b) for your failed rows (and in real life there are always failed rows) you want to know what the errors are - locking, invalid picklists, valdiation rules etc
So a new command something like ...
sfdx force:data:bulk:results --jobid 750xx000000005sAAA... which then gives you all the results files (from each batch) concatenated together into one big CSV would be REALLY useful
Many thanks