topic Re: Upload CSV format file into Salesforce using content versionobject through Talend in Talend Studio

Upload CSV format file into Salesforce using content versionobject through Talend

Priyank2 — Fri, 15 Nov 2024 23:26:59 GMT

Hello,

I have an requirement to attach csv format file in salesforce using content version object.

can anyone please help me to know how it can be achieve using Talend?

Thank you in advance!

Re: Upload CSV format file into Salesforce using content versionobject through Talend

Anonymous — Fri, 03 Dec 2021 15:37:15 GMT

You can do this using a tSalesforceOutput component and a bit of code (maybe used in a tMap) to convert your file to a Base64 byte array. Try this out in a sandbox first.

My tMap connected to my tSalesforceOutput component looks like this......

The "Lithium_Href__c" is a bespoke field that I added for other purposes (tracing between environments).

The routine I used to convert the file to a byte array is below....

package routines;

import java.io.File;

import java.io.IOException;

import java.nio.charset.StandardCharsets;

import java.nio.file.Files;

import org.apache.commons.codec.binary.Base64;

public class Base64File {

public static byte[] encodeFileToBase64Binary(String fileName) throws IOException {

File file = new File(fileName);

byte[] encoded = Base64.encodeBase64(Files.readAllBytes(file.toPath()));

return encoded;

}

Re: Upload CSV format file into Salesforce using content versionobject through Talend

Priyank2 — Mon, 06 Dec 2021 07:25:03 GMT

Hello Rhall,

I tried but facing error shown below :

This is my flow design:

Can you please me by correcting in flow?

thanks and regards,

Anjali Kumari

Re: Upload CSV format file into Salesforce using content versionobject through Talend

Anonymous — Mon, 06 Dec 2021 10:44:17 GMT

Did you create the Routine that I posted? The code in my previous post.

Re: Upload CSV format file into Salesforce using content versionobject through Talend

Priyank2 — Mon, 06 Dec 2021 12:01:02 GMT

Yes I created routine as you mentioned earlier( and for help I am using 7.2 talend version).

Re: Upload CSV format file into Salesforce using content versionobject through Talend

Anonymous — Mon, 06 Dec 2021 12:13:31 GMT

Your Routine is called Base64File, but your use of it refers to Base64 and not Base64File. This is my fault. When I showed a screenshot, my Routine was called differently the to example I shared in code. Adjust this in your tMap and you should get a bit further.

Re: Upload CSV format file into Salesforce using content versionobject through Talend

Priyank2 — Tue, 07 Dec 2021 03:40:13 GMT

Hello Rhall,

Yes it worked now Many Thanks 🙂 but now I am getting NoSuchFileException can you also help me know how to pass file in versiondata field? For example I have a File named Testrecords.csv (It contains 2 columns : Id,Name).

Re: Upload CSV format file into Salesforce using content versionobject through Talend

Anonymous — Tue, 07 Dec 2021 10:50:04 GMT

I missed this in your screenshot. You are not meant to read the file, you just need to pass the path to the file and filename. The routine reads the file and does the work there. Essentially, the value you get from the tFileList should be sufficient.

Re: Upload CSV format file into Salesforce using content versionobject through Talend

Priyank2 — Tue, 07 Dec 2021 16:04:50 GMT

I understand you but how to implement it in job facing difficulty,now tMap part is OK but how to design flow before it? can you please share full job to know exactly which component to use in order to pass filepath?

For an example : I used tFileList to select file ---->this is OK

now what is right approach after this before tmap?

Many Thanks!

Re: Upload CSV format file into Salesforce using content versionobject through Talend

Anonymous — Tue, 07 Dec 2021 16:48:47 GMT

If you connect a tFixedFlowInput to your tFileList, then use the globalMap variable from the tFileList in the schema of your tFixedFlowInput, you can pass the file path to the routine. It would look somewhat like this....

Re: Upload CSV format file into Salesforce using content versionobject through Talend

Priyank2 — Wed, 08 Dec 2021 04:35:08 GMT

Yes It worked 🙂

I am grateful for your support, Thank you very much Rhall

Re: Upload CSV format file into Salesforce using content versionobject through Talend

AGHADI1661012061 — Sat, 20 Aug 2022 16:48:27 GMT

Hello ,

i am trying to do the same, but converting my txt file it return a null value

Re: Upload CSV format file into Salesforce using content versionobject through Talend

talend_learner — Mon, 10 Oct 2022 07:12:51 GMT

Hi Priyank,

I have a similar requirement. I need to attach files as into salesforce. Can you please share the screenshot of your job and the tmap?

Thanks in Advance

Kumar

Re: Upload CSV format file into Salesforce using content versionobject through Talend

talend_learner — Mon, 10 Oct 2022 07:13:27 GMT

Hi Priyank,

I have a similar requirement. I need to attach files as into salesforce. Can you please share the screenshot of your job and the tmap?

Thanks in Advance

Kumar

Re: Upload CSV format file into Salesforce using content versionobject through Talend

Anonymous — Mon, 10 Oct 2022 10:55:49 GMT

I believe that is everything required in the job. I do not have a copy of this job anymore so cannot show you the tMap I am afraid.