Export Attachments from Salesforce using Teland?

[abdelhamed]

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

[manodwhb]

@abdelhamed,check below case may be useful.

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

[TRF]

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.

[abdelhamed]

Thanks @TRF, 

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

[TRF · Accepted solution]

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:

[abdelhamed]

 Hallo @TRF,

thanks so much it works like magic  

Merci de votre aide

[TRF]

That's not magic, that's Talend!

[Anonymous]

@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.

[TRF]

@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.

[RViswanath1674546562]

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?