topic Re: google drive to salesforce file upload in Talend Studio

google drive to salesforce file upload

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

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:

Re: google drive to salesforce file upload

Anonymous — Tue, 19 Mar 2019 10:17:15 GMT

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 🙂

Re: google drive to salesforce file upload

Anonymous — Tue, 19 Mar 2019 10:44:05 GMT

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

Re: google drive to salesforce file upload

Anonymous — Tue, 19 Mar 2019 10:51:00 GMT

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 🙂

Re: google drive to salesforce file upload

Anonymous — Tue, 19 Mar 2019 11:27:11 GMT

Hello,

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

Re: google drive to salesforce file upload

Anonymous — Tue, 19 Mar 2019 11:40:12 GMT

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 🙂

Re: google drive to salesforce file upload

Anonymous — Tue, 19 Mar 2019 13:14:26 GMT

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.

Re: google drive to salesforce file upload

Anonymous — Tue, 19 Mar 2019 14:51:06 GMT

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 🙂