You need to sign in to do that
Don't have an account?
Jon Sheldon 42
Is the Bulk API Appropriate for this scenario?
Here is my scenario:
The process would be roughly:
- Will receive several X12 834 files per day via SFTP to an on premise server. There is potential for dozens and long term possibly 100s of files each day that need to be processed/imported.
- Each file needs to be imported into a custom salesforce object
- Some files may contain only 5000 records and some may contain 100,000+ records
The process would be roughly:
- Transform an 834 file into a CSV file with upsert records for the custom object.
- Create a Bulk API job for importing the CSV file.
- Separate the CSV upsert file into separate chunks (10MB or 10000 rows, whichever comes first) submitting each as a batch to the job.
- Check the state of the job/result of each batch.