topic Re: Send Google drive files to salesforce in Talend Studio

Send Google drive files to salesforce

Anonymous — Sat, 16 Nov 2024 06:18:40 GMT

I am using Talend Studio to transfer Google drive data to Salesforce content version.

I retrieve file from the drive and make salesforce connection.

While mapping drive data to Salesforce content version's field, I mapped content(drive data) to version data(SF object) of salesforce.

But in Content Version(Salesforce), Title field is required but I do not have title value from google drive. I am attaching a screenshot for that.

Re: Send Google drive files to salesforce

akumar2301 — Mon, 18 Mar 2019 11:00:57 GMT

If you are using tGoogleDriveList before tGoogleDriveGet , you could use below GlobalVar as Title.

((String)globalMap.get("tGoogleDriveList_1_TITLE"))

Or Name of File used in tGoogleDriveGet ( Hardcoded)

Re: Send Google drive files to salesforce

Anonymous — Mon, 18 Mar 2019 11:31:16 GMT

I am directly using tGoogleDriveGet and specifying the file name.

Please check the screenshot.

And if i am giving file name hardcoded, it will give runtime exception

version.png

Re: Send Google drive files to salesforce

akumar2301 — Mon, 18 Mar 2019 12:04:07 GMT

In this case , "Name Of File" used in tGoogleDriveGet is your title.

You can use the same name in tMap.

Re: Send Google drive files to salesforce

Anonymous — Mon, 18 Mar 2019 12:43:15 GMT

When I hardcode name of file in tMap it will give me this error:

Error Line: 2396
Detail Message: Syntax error on token "Name", delete this token
There may be some other errors caused by JVM compatibility. Make sure your JVM setup is similar to the studio.

Please check screenshot of mapping

mapping.png

Re: Send Google drive files to salesforce

akumar2301 — Mon, 18 Mar 2019 12:46:55 GMT

put - test name - in double quotes like "test name".

You could also put directly in expression window like

Re: Send Google drive files to salesforce

Anonymous — Mon, 18 Mar 2019 13:07:00 GMT

Thanks!

Working now.

One more help in the same.

How can I get File Type, Title and other value from the drive? So that I will map it to salesforce dynamically.