Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Get all value in FlowToIterate then pass it all to GoogleGet

Hi,

 

 Would like to know the how to get all the value from FlowToIterate then Pass it to GoogleGet. I can download it to my local folder when I only have 1 result but when I have multiple result then it gives me error (see error message below) : 

 

[statistics] connecting to socket on port 3957
[statistics] connected
Exception in component tGoogleDriveGet_2 (jobGoogleDload)
java.lang.IllegalArgumentException: java.net.MalformedURLException
at com.google.api.client.http.GenericUrl.parseURL(GenericUrl.java:638)
at com.google.api.client.http.GenericUrl.<init>(GenericUrl.java:114)
at test.jobgoogledload_0_1.jobGoogleDload.tIterateToFlow_2_AIProcess(jobGoogleDload.java:2855)
at test.jobgoogledload_0_1.jobGoogleDload.tGoogleDriveList_3Process(jobGoogleDload.java:1039)
at test.jobgoogledload_0_1.jobGoogleDload.tGoogleDriveConnection_1Process(jobGoogleDload.java:589)
at test.jobgoogledload_0_1.jobGoogleDload.tRESTClient_1Process(jobGoogleDload.java:2159)
at test.jobgoogledload_0_1.jobGoogleDload.runJobInTOS(jobGoogleDload.java:3284)
at test.jobgoogledload_0_1.jobGoogleDload.main(jobGoogleDload.java:3099)
Caused by: java.net.MalformedURLException
at java.net.URL.<init>(Unknown Source)
at java.net.URL.<init>(Unknown Source)
[statistics] disconnected
at java.net.URL.<init>(Unknown Source)
at com.google.api.client.http.GenericUrl.parseURL(GenericUrl.java:636)
... 7 more
Caused by: java.lang.NullPointerException
... 11 more

 

 

Labels (4)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hi,

Thank you for the response for this. I already pinpoint what is the cause of the error. It is because there is a other file format on my gdrive thats why it cause an error it should be always an excel file

View solution in original post

2 Replies
Anonymous
Not applicable
Author

Hi,

 

     Could you please try to print the values using a tlogrow to see whether the values are coming correctly?

 

      If the data is coming correctly in tlogrow for all the values in loop, then we need to see the details from other aspects.

 

Warm Regards,

 

Nikhil Thampi

Anonymous
Not applicable
Author

Hi,

Thank you for the response for this. I already pinpoint what is the cause of the error. It is because there is a other file format on my gdrive thats why it cause an error it should be always an excel file