google drive to salesforce file upload

[Anonymous]

Hello,

I am sending files from google drive to salesforce. Which is done.

But, I only sent content(drive) in version data(SF content version field). 

I want to map title, FileType, PathonClient etc with the drive. I only get content from Drive. How to get file type, title and other from the drive?

mapping:

[Anonymous]

Hi,

    Could you please try to use tGoogleDriveList component at the beginning if you are looking for more file related information?

Please refer the predefined schema which can be used for your reference.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

Hi Nikhil,

I have implemented tGoogleDriveList component at the beginning, but same result at mapping screen.

And if I remove tGoogleDriveGet component, then there is no byte[] type field in tGoogleDriveList component which I can map with version data  of salesforce

[Anonymous]

Hi,

    It will not be automatically reflected in the mapping. PLease give Control+Space and see the various values available for tGoogleDrive List component. Please see whether these details are sufficient for your use case.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

Hello,

If you talking about below screenshot, then it is not helping me in the mapping screen.

[Anonymous]

Hi,

    I did a minor change to connect tFlowtoIterate.

Now, if you want a value from list inside tMap (for example kind value from tGoogleDriveList), you can give Control+Space and it will be present in the list as shown below.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

Hello,

Thanks! This is working for me.

But 2 problems are still there.

1. I want file extension from the google drive. I only get these items:

2. tGoogleDriveList retrieve folders only. I have tried to retrieve file by specifying file name in this component and select file from file type dropdown. But at runtime, error: file not exist.

[Anonymous · Accepted solution]

Hi,

Could you please refer the below link?

https://help.talend.com/reader/OaKZ99QSgWd0vLeVo94Oeg/o62hypXfEly8_t3L40iZRA

I could see that file names (like csv, txt etc.) are being retrieved and displayed in this example.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂