Process a file hosted on an external server from Sugar Cloud

Yes you can....

As an example I added a small scheduler job which reads the exchange rates for Euros from an XML file provided by the ECB server. It's just a very simple example which should show the principle of operation. For sensitive customer data a more complicated CURL dialog  with authentication is recommended.

CurrencyUpdate_EUR_1000.zip

Hello Harald Kuske

Thank you, indeed it works well.

Sylvain

Hello Harald,

many thanks for your quick and usefull feedbacks.

Best regards,

Fred

hi 

is this still possible, import data from a CSV file hosted on an external SFTP server

hi Harald Kuske 

When trying to upload your example, I get the following errors/warnings;

File Issues
SugarModules/custom/Extension/modules/Schedulers/Ext/ScheduledTasks/Update_Currencies_EUR.php
Code attempted to call denylisted function "curl_init" on line 46
Code attempted to call denylisted function "curl_setopt" on line 47
Code attempted to call denylisted function "curl_setopt" on line 48
Code attempted to call denylisted function "curl_setopt" on line 49
Code attempted to call denylisted function "curl_exec" on line 50

Do you know how to achieve this without using current restrictions please?

Thank you in advance

Hi Tony,

cURL has been replaced by ExternalResiurceClient in Sugar since version 12. So, please change the code from Harald to use the new ExternalResourceClient class instead of cURL.

Please refer to the documentation:   support.sugarcrm.com/.../

hi Abhijeet Vardhan 

Thank you for reply, unfortunately ExternalResourceClient doesn’t support SFTP which is needed for the requirement mentioned earlier 
"import data from a CSV file hosted on an external SFTP server"