1

I have requirement to upload files to SFDC attachments object. I am making REST call from my Java code to SFDC with required details.

curl -X POST \
  https://ap.salesforce.com/services/data/v29.0/sobjects/Attachment/ \
  -H 'authorization: Bearer sessionId' \
  -H 'cache-control: no-cache' \
  -H 'content-type: application/json' \
  -d '{
    "ParentId":"00T0K0000243CvXXX",
    "Name":"Test123.txt",
    "body":"base64Coded"
}'

But above REST call support only single Attachment at a time. Is there any way I can upload multiple files in a single shot. Or can we leverage SFDC Bulk API anyhow?

  • What is the MAX file size I can upload using REST API calls. I tried and Salesforce threw exception on 25MB but I did not find any doc which confirm on the size limit. Can someone point me to the relevant doc link. – San Jul 4 '18 at 7:03
  • size limit (from this developer.salesforce.com/docs/atlas.en-us.api_rest.meta/…) is You can insert or update blob data using a non-multipart message, but you are limited to 50 MB of text data or 37.5 MB of base64–encoded data. – davejagoda Mar 22 at 0:35
3

You can use Bulk API here to upload attachment in bulk.

  • First, you need to Create a request.txt File which will include details of files.
  • Then Create a Zip Batch File with Binary Attachments

  • Then Create a Job for Batches with Binary Attachments

  • Finally, Create a Batch with Binary Attachments.

You can follow the details steps from here: Load Binary Attachments

  • Thanks Tushar. As far I understood, this will create a batch job in Saleaforce and will execute as soon as it get CPU. I can use batch Job id returned in the response for checking the completion status but once the job is completed how to check what are the attachments which got failed and what was the cause of failure. – San Jun 26 '18 at 14:10
  • @San You can use Get Batch Results to check the status. – Tushar Sharma Jun 27 '18 at 4:53
  • As per the link, in request.txt file each row will represent one record, in my case it will be attachment file details including the content of file being uploaded under body column. Do we have size limit on request.txt because I could see SF doc says Batches size should not be more than 10MB? In my case individual file can go up to 25MB. – San Jun 27 '18 at 6:45
  • @San you need to give path here of your file. – Tushar Sharma Jun 27 '18 at 6:52
  • Ohh, I did not understand. if I give path rather than content will SF take care of downloading from the source location and upload to SF Attachment. (we have our files stored at Amazon S3) – San Jun 27 '18 at 6:58

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.