Send Google drive files to salesforce

[Anonymous]

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.

[akumar2301]

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)

[Anonymous]

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

[akumar2301]

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

You can use the same name in tMap.

[Anonymous]

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

[akumar2301 · Accepted solution]

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

You could also put directly in expression window like 

[Anonymous]

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.