topic Re: Global Variables Not Accessible tGoogleDriveList in Talend Studio

Global Variables Not Accessible tGoogleDriveList

Dominik_G — Sat, 16 Nov 2024 04:31:01 GMT

Hi all,

I went all through the forum and cannot find the answer, so I ask.

According to the documentation available, I should be able to access global variables for tGoogleDriveList like ID (of the file) and TITLE (of the file).

However I do not see those in my Talend Studio in the outline nor can I access them using command (String)globalMap.get("tGoogleDriveList_2_TITLE").

What I am aiming to do is my job to pick up some files from google drive and load them to Snowflake. In order to do that I wanted to iterate on the files on Drive and using globalMap.get + global variable ID or TITLE in component tFileInputExcel select the file to be loaded to Snowflake with tdbOutput.

In the meantime I tried just to print the IDs and TITLEs using tIteratetoFlow and tLogRow, but all I am getting is null values. The count of rows returned is correct, corresponds to the quantity of files in folder, but all values returned are null.

Would anybody have an idea how to access those global variables?

Re: Global Variables Not Accessible tGoogleDriveList

Anonymous — Tue, 01 Oct 2019 15:53:49 GMT

Hi,

Could you please share screen shots of your job flow and component details where you are having error? It will give us better idea about the possible root cause of the error.

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: Global Variables Not Accessible tGoogleDriveList

Dominik_G — Mon, 07 Oct 2019 08:41:55 GMT

Hi Nikhil,

See below some screenshots.

I only attach the relevant part of the job.

In the component tGoogleDriveGet I wanted to save all the files from a folder on which tGoogleDriveList iterates.

In order to do that I would put ((String)globalMap.get("tGoogleDriveList_1_TITLE")) into the 'File' field of tGoogleDriveGet component.

However it seems that the Global Variable 'TITLE' is not available, as you can see in the screen show from the 'Outline' of my TOS. And according to the documentation it should be there.

I have used the above described process before, therefore I do not know why it is not working now.

I appreciate your support on this.

Thank you,

Dominik

Part of the job with the tGoogleDriveList component.Outline in TOS showing the global variables available for the componentGlobal variables which should be available for the tGoogleDrive component, according to Talend support documentation

Re: Global Variables Not Accessible tGoogleDriveList

Anonymous — Mon, 07 Oct 2019 14:44:53 GMT

Hi Dominik,

Could you please try to get the list by using Control+Space? I could see the file name in the drop down 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: Global Variables Not Accessible tGoogleDriveList

Dominik_G — Mon, 07 Oct 2019 16:12:35 GMT

Hi Nikhil,

You are looking at the variables for component tGoogleDriveGet, which I see also.

I meant the ones for component tGoogleDriveList.

I did try space + ctrl, but I don't see them there either.

Best,

Dominik

Re: Global Variables Not Accessible tGoogleDriveList

Anonymous — Mon, 07 Oct 2019 16:21:07 GMT

Hi,

Could you please assign the values to a context variable or set the global variable and see whether its available after that step?

For example, I could see both context variable and global variable in drop down after setting values.

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: Global Variables Not Accessible tGoogleDriveList

Dominik_G — Tue, 08 Oct 2019 07:41:17 GMT

Hello,

Of course I can do that and then they work. I can access variables which I pre-set either using tJava or tSetGlobalVar, but that is not what my issue is.

The values of global variable tGoogleDriveList_TITLE or tGoogleDriveList_ID cannot be pre-set, as they are dynamically set when the job runs, basing on the name and id of the file on which the component tGoogleDriveList iterates.

I hope that clarifies..

Best,

Dominik

Re: Global Variables Not Accessible tGoogleDriveList

Anonymous — Tue, 22 Oct 2019 15:59:29 GMT

have you solved this problem?

I have same situation...

Re: Global Variables Not Accessible tGoogleDriveList

Dominik_G — Tue, 22 Oct 2019 16:04:50 GMT

Hey Stefano,

No I didn't. I just created a workaround, which was possible for my purpose, but the functionality I was looking for still seems unavailable.

I am still hoping for an answer in this topic from somebody who knows how to solve our issue...

Re: Global Variables Not Accessible tGoogleDriveList

Anonymous — Tue, 22 Oct 2019 16:09:08 GMT

Tks for your reply,

I hope Tanlend Studio can find a solution.

In previous Talend version (6.1 and 6.5), it work correctly.

In latest version (now 7.2.1), this code is missing...

globalMap.put("tGoogleDriveList_1_ID", tGoogleDriveList_1_temp.getId());
globalMap.put("tGoogleDriveList_1_TITLE", tGoogleDriveList_1_temp.getTitle());

Re: Global Variables Not Accessible tGoogleDriveList

Dominik_G — Tue, 22 Oct 2019 16:12:37 GMT

@talend Team

Will these variables be available in the new versions of the Talend Studio at any point? I think it would make sense …

Re: Global Variables Not Accessible tGoogleDriveList

Anonymous — Thu, 24 Oct 2019 15:25:51 GMT

@Dominik_G

I would recommend you to create a JIRA ticket regarding this query.

https://jira.talendforge.org

If you are an Enterprise customer, please create a support case and support team will followup on your query with Product team.

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: Global Variables Not Accessible tGoogleDriveList

dwhdeveloper — Tue, 04 Jan 2022 10:19:33 GMT

Is that been solved?

I also have the same issue since upgrading to latest Talend.

Cannot access global variables for tGoogleDriveList.

I need that to iterate over the files in google drive and get them.