Import KoboToolBox Data Result in XLSX to SAS

[febyinkasid]

Has anyone tried to import Kobotoolbox questionnaire result in XLXS form to SAS?

I have this macro to import, but somehow it keeps getting timeout

/*XLS IMPORT*/
%macro httpkobolong(name, link);
filename target "&data.\&name..xlsx";
proc http method="get"
  url="&link."
  out=target
  timeout=600;
run;
%mend();
%let link_module=https://kobo.sid-indonesia.org/api/v2/assets/[AssetID]/export-settings/[export-setting UID]/data.xlsx;
%httpkobolong(name_module,&link_module.);

I assume this one from kobo, that is being timeout, but maybe anyone has any experience in this.

Thanks in advance

[Kurt_Bremser]

Where is the macro variable data defined?
On which platform does your SAS session run?

[febyinkasid]

&data is defined in my macro dictionary.
using SAS 9.4

[Kurt_Bremser]

SAS 9.4 on UNIX or Windows? If server-based, is the path defined in &data available on the server?

[febyinkasid]

Hmm the &data. is local path, is not the problem since its already used globally and regularly. that is not the main problem.

[Ksharp]

Try DEBUG statement to get more information:

filename target temp;
proc http method="get"
url="www.sas.com"
out=target
timeout=600;
debug level=3;
run;