topic Re: Upload content (files) into Salesforce using ContentVersion object in Talend Studio

Upload content (files) into Salesforce using ContentVersion object

TRF — Sat, 16 Nov 2024 09:43:10 GMT

Hi,
Has anyone ever tried to upload content into Salesforce using ContentVersion object?
 
Using DataLoader, you have to activiate the "Upload Bulk API as Zip File (enable to upload binary attachments)" option and it works fine.
With this option activated, DataLoader automatically construct a zip file in which you can found:
- 1 file per document to load with the name "#attachment_000", "#attachment_001" and so on
- 1 file called "request.txt" corresponding to the input csv file with the content of the field VersionData has been changed to the corresponding entry in the archive file (#attachment_001 for example)
 
In tSalesforceOutptuBulkExec (TOS 6.3.1), this option doesn't exists in the settings and trying to run the job with the same input csv file produce the following error message (catched on Salesforce side):
InvalidBatch : Binary field VersionData is only supported for content types ZIP_XML and ZIP_CSV
Thank's.
 

Re: Upload content (files) into Salesforce using ContentVersion object

Anonymous — Mon, 05 Jun 2017 13:40:33 GMT

Hi TRF
I have checked with our developers, tSalesforceOutptuBulkExec component does not support this option yet, he suggested to create a feature request on our bugtracker.

Regards
Shong

Re: Upload content (files) into Salesforce using ContentVersion object

Anonymous — Thu, 20 Sep 2018 10:10:10 GMT

Hi,
how's progress with this option? Did u guys implemented it?
Have similar problem with tSalesforceOutptuBulkExec.

Re: Upload content (files) into Salesforce using ContentVersion object

Stamen_Nikolov — Wed, 10 Oct 2018 20:23:39 GMT

Hi, I`m currently doing this. This is how the flow looks like, if you have any question please do let me know.

In my case i have attachments from a legacy system that have been linked to customers. It`s a 2 step flow and it`s using context - 1st step is inserting files into SFDC (using ContentVersion object), 2nd step is quering the imported versions and adding them to a library that is being manually created in advance and sharing to all users through a Public group (Using ContentDocumentObject).

In the first part I`m reading the files from a folder, then i have two csv files where i`m doing two lookups - one for the filename and one for the customer.

Re: Upload content (files) into Salesforce using ContentVersion object

Anonymous — Wed, 28 Nov 2018 16:54:46 GMT

Hi,

I am trying ton insert PDF File in salesForce (ContentVersion), and i know that i must convert the File in 64 base's, is it possible to show the java code in your tjavarow component.

Thank's

Re: Upload content (files) into Salesforce using ContentVersion object

Anonymous — Thu, 29 Nov 2018 11:19:02 GMT

Hi, arezki
Here some sapmle may be proper to u:

FileInputStream pdfDocument = new FileInputStream(file);
    byte[] documentData = new byte[(int)file.length()];
    
    //fill array with some bytes
    pdfDocument.read(documentData);
    
    // Convert bytes array to Base64 string to fill Body field
    output_row.Body = new String(Base64.encodeBase64(documentData));

You should import the org.apache.commons.codec.binary.Base64 first which is lay in commons-codec-1.11.jar

Re: Upload content (files) into Salesforce using ContentVersion object

Anonymous — Tue, 04 Dec 2018 15:21:27 GMT

thank's F uncleYar. It ok form me

Re: Upload content (files) into Salesforce using ContentVersion object

freebirdSFDC — Tue, 01 Sep 2020 13:57:21 GMT

Has anyone tried uploading zip files to Salesforce? I am having this requirement where I need to populate multiple zip files from a remote location to Salesforce. My doubt is do I have to convert it to Blob and is it possible to do so using Talend Open studio? Thanks in advance.

Re: Upload content (files) into Salesforce using ContentVersion object

kholio_ak — Sun, 28 Mar 2021 16:04:52 GMT

Hello @Stamen Nikolov,

I'm trying to achieve the same use case.

However, the snapshots you've posted are somehow not active.

Could you pls share them again ?

Thanks!

Beste regards

Re: Upload content (files) into Salesforce using ContentVersion object

VRagothaman — Tue, 06 Jul 2021 12:07:58 GMT

Hi All,

I am getting the same error (InvalidBatch : Binary field VersionData is only supported for content types ZIP_XML and ZIP_CSV) while trying to upload the file using tSalesforceOutptuBulkExec? Is the support still not available?

Re: Upload content (files) into Salesforce using ContentVersion object

VRagothaman — Thu, 08 Jul 2021 09:50:18 GMT

Thank you for the info, But I want to upload the files using talend not using Data loader.

Re: Upload content (files) into Salesforce using ContentVersion object

larasc — Wed, 23 Mar 2022 16:11:42 GMT

Hi all, I'm attempting to do exactly as the original post detailed to upload photos for Contacts via ContentVersion object. I have successfully tested via DataLoader. In Talend, I think I'm having trouble with the part where it needs to be zipped/encoded properly. When I send to Salesforce, it looks to me like Salesforce doesn't recognize it as a zip and so it fails when trying to read it. Has anyone had success and can provide additional details? Thanks