I need to create a client application where users can upload CSV files, which will then be used to populate Custom Big Objects.
My problem is I'm not sure which API to use. The Salesforce documentation for "Populate a Custom Big Object" says "You can use a CSV file to load data into a custom big object via SOAP API Bulk AP". I'm assuming this is a typo and it means we can use SOAP or Bulk API.
I'll be uploading around 300,000 records at once. With that being said, would it be better for the application to use Bulk API or SOAP API?
Are there any examples of this being done? I tried Googling this topic and couldn't find much relevant information. Even the Salesforce documentation is lacking when it comes to explaining how to populate Big Objects.
Also, before it's mentioned, we're not able to use the Data Loader, hence the need for this application