topic Re: Export Attachments from Salesforce using Teland? in Talend Studio

Export Attachments from Salesforce using Teland?

abdelhamed — Fri, 14 Dec 2018 12:50:24 GMT

please can any one tell me how to export attachments like (xml,pdf....) from Salesfroce using Talend?

Re: Export Attachments from Salesforce using Teland?

manodwhb — Fri, 14 Dec 2018 12:55:41 GMT

@abdelhamed,check below case may be useful.

https://community.talend.com/t5/Design-and-Development/resolved-Upload-Attachment-into-Salesforce/td-p/64490

Re: Export Attachments from Salesforce using Teland?

TRF — Fri, 14 Dec 2018 13:36:15 GMT

The link provided by @manodwhb is for upload, not for download but you can found many links on Google searching for "java salesforce attachment dowload".

The principle is derived from the upload process: query the attachment objet - decode64 the body content - create the output file.

Hope this helps.

Re: Export Attachments from Salesforce using Teland?

abdelhamed — Fri, 14 Dec 2018 14:54:15 GMT

Thanks @TRF,

can you please help me more i dont know from where i can start.

Re: Export Attachments from Salesforce using Teland?

TRF — Sun, 16 Dec 2018 13:55:18 GMT

As a minimalist solution, connect your tSalesforceInput component to a tJavaRow with the following code:

if(input_row.BodyLength > 0) {
    File f = new File(context.YourOutputPath + "/" + input_row.Name);
    FileOutputStream output = new FileOutputStream(f);
    byte[] decoded = Base64.decodeBase64(input_row.Body);
    output.write(decoded);
}

Include the these lines into the advanced settings tab of the tJavaRow component:

import java.io.File;
import java.io.FileOutputStream;
import org.apache.commons.codec.binary.Base64;

The schema for the tSalesforce component should look like this:

Re: Export Attachments from Salesforce using Teland?

abdelhamed — Mon, 17 Dec 2018 12:31:06 GMT

Hallo @TRF,

thanks so much it works like magic

Merci de votre aide

Re: Export Attachments from Salesforce using Teland?

TRF — Mon, 17 Dec 2018 16:45:55 GMT

That's not magic, that's Talend!

Re: Export Attachments from Salesforce using Teland?

Anonymous — Thu, 26 Sep 2019 17:24:55 GMT

@TRF Is there a way to simply pass the file to the next component instead of writing to your local drive?

Ideally I'd like to be passing the created file to a Box folder, therefore using the tBoxInput component which should be accepting the output row.

Re: Export Attachments from Salesforce using Teland?

TRF — Thu, 26 Sep 2019 18:00:30 GMT

@IanJones, add an output field (let say "decoded") with datatype Object for the tJavaRow component and push the result of decodeBase64 to this field.

Then, select "Upload Incoming Content" for the Upload mode.

This should work (sorry, not tried).

If this is not enough, open a new topic.

Re: Export Attachments from Salesforce using Teland?

RViswanath1674546562 — Tue, 24 Jan 2023 18:18:09 GMT

Hi @Fred Trebuchet

How can I convert ContentVersion into a file in Talend? I believe the body of an attachment and Version Data of a content version are different. Please let me know if you have any workarounds?