Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

URL download csv data more than 2147483648

Begin_22
6 - Meteoroid

Hello all,

I want to download data from https://www.gstatic.com/covid19/mobility/Global_Mobility_Report.csv. However the data is more than the maximum limit to download tool. I receive an error message: Error String size limit reached: Strings are limited to 2147483648 bytes.

Does any one know how to download the data faster?

 

Thank you very much.

5 REPLIES 5
apathetichell
18 - Pollux

Toggle Download tool from  String Field to Download to Temporary File.

Begin_22
6 - Meteoroid

Thank you for your response. How to read temp file? 

Luke_C
17 - Castor

Hi @Begin_22 

 

Use a dynamic input tool - here's an example downloading a csv from yahoo finance. 

 

Luke_C_0-1661802024590.png

 

Begin_22
6 - Meteoroid

😀The dynamic tool works to read data. When I try to  save the workflow in gallery, but it shows error that it can't find the temp file. How to go around with that?

Luke_C
17 - Castor

@Begin_22 It will probably give you an error when you save it up to the gallery, but if you actually run the workflow from the gallery it should work just fine. 

Labels