Error using R tool to download on server

[Bueller18]

I have a workflow which downloads JSONstat files using the rjstat package in R, and it works fine on my desktop. When I publish to the Alteryx Gallery, however, the workflow fails with the following error messages:

Error: R (7): Error in open.connection(con, "rb") : cannot open the connection

Info: R (7): InternetOpenUrl failed: 'A connection with the server could not be established'

I believe this may be due to proxy settings in R, however, given that the installation of R appears to be a standalone installation for Alteryx, I cannot figure out how to change the proxy settings for R. 

Help would be much appreciated!

[jamielaird]

Hi @Bueller18 

Have you checked that your Alteryx Server has internet access? It could be related to your firewall settings on the server machine.

If you're publishing the the public gallery you generally won't be able to pull data from URLs unless your workflow has been vetted and approved by the Alteryx team.

[Bueller18]

Hi @jamielaird 

Yes the URL is whitelisted on the server and I can actually read the data using the download tool. Unfortunately the rjstat package is expecting to pull the data direct from a url.

I am publishing to a private gallery, not Alteryx public server