download a genesys cloud csv file through a static link using proc http

[ndiack]

I want to download a genesys cloud csv file through a static link using proc http.

The program seems to work but the expected output file is empty (GenesystmpOutput.csv).

When I copy paste the url into a browser, the file is well downloaded.

Do you have any idea why the download doesn’t work?

filename out "\tmp\GenesystmpOutput.csv";

filename hdrout "\tmp\GenesystmpResponse.csv"; 

proc http

AUTH_BASIC

WEBUSERNAME = "username"

WEBPASSWORD ="xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"

  url='https://apps.mypurecloud.de/platform/api/v2/downloads/41c15b827cf4f848'

  method="get" 

out=out

headerout=hdrout

ct="application/x-www-form-urlencoded";

debug level=3;

run;

Bests regards

[ballardw]

What does your LOG show when you run that Proc HTTP code?

Copy the log with code and all the notes and messages, on the forum open a text box using the </> icon above the message window and paste the text. You can edit the pasted text in the box to replace the secure elements like user Id and password.

Your code requests debug information but you haven't shared any of the result of that debug with us.

[ndiack]

Hi,

below the program execution log

Soumission : Apr 2, 2024, 5:46:08 PM
1    OPTIONS NOSYNTAXCHECK;
2    TITLE;
3    FOOTNOTE;
4    DATA _NULL_;
5    RUN;
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      
6    OPTIONS VALIDVARNAME=ANY;
7    OPTIONS VALIDMEMNAME=EXTEND;
8    ODS _ALL_ CLOSE;
9    
10   OPTIONS NOSYNTAXCHECK;
11   DATA _NULL_;
12   LENGTH RC 4;
13   %let TWORKLOC="%sysfunc(getoption(work))";
14   RC=DLGCDIR(&TWORKLOC);
15   RUN;
NOTE: The current working directory is now 
      "/opt/sas/viya/config/var/tmp/compsrv/default/2d70b8fe-8dc8-41c2-a007-781cad3be5b7/SAS_workF8D10012B1AD_vmsasanalyticsdv01".
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      
16   OPTIONS NOSYNTAXCHECK;
17   FILENAME _HTMLOUT TEMP;
18   FILENAME _LISTOUT TEMP;
19   FILENAME _GSFNAME TEMP;
20   FILENAME _DATAOUT TEMP;
21   %LET SYSCC=0;
22   %LET _CLIENTAPP = %NRQUOTE(%NRSTR(SAS Studio));
23   %LET _CLIENTAPPABBREV = %NRQUOTE(%NRSTR(Studio));
24   %LET _CLIENTAPPVERSION=5.2;
25   %LET _CLIENTVERSION=5.2;
26   %LET _SASSERVERNAME = %NRQUOTE(%NRSTR(vmsasanalyticsdv01));
27   %LET _SASHOSTNAME = %NRQUOTE(%NRSTR(vmsasanalyticsdv01));
28   %LET _SASPROGRAMFILEHOST = %NRQUOTE(%NRSTR(vmsasanalyticsdv01));
29   %LET _CLIENTUSERID = %NRQUOTE(%NRSTR(fafa));
30   %LET _CLIENTUSERNAME = %NRQUOTE(%NRSTR(Fafa
30 !                                                                                                                 ));
31   %LET CLIENTMACHINE = %NRQUOTE(%NRSTR(10.81.53.23));
32   %LET _CLIENTMACHINE = %NRQUOTE(%NRSTR(10.81.53.23));
33   %LET _CLIENTMODE = %NRQUOTE(%NRSTR(viya));
34   %let SASWORKLOCATION="%sysfunc(getoption(work))/";
35   FILENAME _CWD &SASWORKLOCATION;
36   DATA _NULL_;
37   CALL SYMPUT('_SASWORKINGDIR',PATHNAME('_CWD'));
38   RUN;
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      
39   FILENAME _CWD;
NOTE: Fileref _CWD has been deassigned.
40   %LET _SASPROGRAMFILE = %NRQUOTE(%NRSTR());
41   %LET _BASEURL = %NRQUOTE(%NRSTR(http://x.x.x.x/SASStudioV/));
42   %LET _EXECENV = %NRQUOTE(%NRSTR(SASStudio;));
43   DATA _NULL_;
44   LENGTH RC $255;
45   CALL SYMPUT("GRAPHINIT","");
46   CALL SYMPUT("GRAPHTERM","");
47   RC=TSLVL('SASXGOPT','N');
48   _ERROR_=0;
49   IF (RC^=' ') THEN DO;
50   CALL SYMPUT("GRAPHINIT","GOPTIONS RESET=ALL GSFNAME=_GSFNAME;");
51   CALL SYMPUT("GRAPHTERM","GOPTIONS NOACCESSIBLE;");
52   END;
53   RUN;
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      
54   DATA _NULL_;
55   LENGTH RC 4;
56   RC=SYSPROD("PRODNUM002");
57   IF (RC^=1) THEN DO;
58   CALL SYMPUT("GRAPHINIT","");
59   CALL SYMPUT("GRAPHTERM","");
60   END;
61   RUN;
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      
62   %LET _DATAOUT_MIME_TYPE=;
63   %LET _DATAOUT_NAME=;
64   %LET _DATAOUT_TABLE=;
65   %LET _DATAOUT_URL=;
66   %SYMDEL _DATAOUT_MIME_TYPE _DATAOUT_NAME _DATAOUT_URL _DATAOUT_TABLE;
67   %LET _SASWS_ = %BQUOTE(%sysfunc(getoption(work)));
68   %LET _SASWSTEMP_ = %BQUOTE(%sysfunc(getoption(work)));
69   
70   ODS LISTING CLOSE;
71   OPTIONS PRINTERPATH=PDF;
72   ODS AUTONAVIGATE OFF;
73   ODS GRAPHICS ON;
74   ODS HTML5 (ID=WEB) METATEXT='http-equiv="Content-Security-Policy" content="default-src ''none''; style-src ''unsafe-inline'';
74 ! img-src data: ;"' DEVICE=PNG GPATH="&_SASWSTEMP_" PATH="&_SASWSTEMP_" ENCODING=utf8 FILE=_HTMLOUT (TITLE='Results:Programme
74 ! 3.sas') STYLE=Illuminate OPTIONS(BITMAP_MODE='INLINE' OUTLINE='ON' SVG_MODE='INLINE'
74 ! CSS_PREFIX='.ods_03405fe2-fc36-4b53-b19a-5593ad08f949' BODY_ID='div_03405fe2-fc36-4b53-b19a-5593ad08f949' );
NOTE: Writing HTML5(WEB) Body file: _HTMLOUT
75   ODS LISTING FILE=_LISTOUT;
76   &GRAPHINIT;
77   OPTIONS FIRSTOBS=1;
78   OPTIONS OBS=MAX;
79   OPTIONS DTRESET DATE NUMBER;
80   OPTIONS DEVICE=PNG;
81   filename out "\tmp\GenesystmpOutput.csv";
82   filename hdrout "\tmp\GenesystmpResponse.csv";
83   proc http
84   AUTH_BASIC
85   WEBUSERNAME = "a00ede31-766b-4cee-89df-c8c6b61091c6"
86   WEBPASSWORD =XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
87    url='https://apps.mypurecloud.de/platform/api/v2/downloads/41c15b827cf4f848'
88    method="get"
89   out=out
90   headerout=hdrout
91   ct="application/x-www-form-urlencoded"
92   /*HEADEROUT_OVERWRITE*/;
93   debug level=3;
94   run;
> GET /platform/api/v2/downloads/41c15b827cf4f848 HTTP/1.1
> User-Agent: SAS/9
> Host: apps.mypurecloud.de
> Accept: */*
> Authorization: ************
> Connection: Keep-Alive
> Content-Type: application/x-www-form-urlencoded
>
< HTTP/1.1 303 See Other
< Date: Tue, 02 Apr 2024 15:46:09 GMT
< Content-Length: 0
< Connection: keep-alive
< Location: 
https://login.mypurecloud.de/authorize?response_type=code&redirect_uri=https%3A%2F%2Fapi.mypurecloud.de%2Fapi%2Fv2%2Fdownloads%2Fcal
lback&state=41c15b827cf4f848&client_id=181dfaa4-f290-4a95-b0da-bfa37c7678c2
< ININ-Correlation-Id: 9c28d172-70f1-42f5-8327-f6543bb28a3f
< Strict-Transport-Security: max-age=31536000; includeSubDomains
< Cache-Control: no-cache, no-store, must-revalidate
< Access-Control-Allow-Methods: GET, POST, PUT, DELETE, OPTIONS, HEAD, PATCH
< Access-Control-Allow-Headers: Origin, X-Requested-With, Content-Type, Accept, Authorization, DNT, User-Agent, Keep-Alive, 
Cache-Control, ININ-Client-Path, Genesys-App
< Access-Control-Expose-Headers: Retry-After,inin-correlation-id
< Access-Control-Max-Age: 86400
< 
> GET 
/authorize?response_type=code&redirect_uri=https%3A%2F%2Fapi.mypurecloud.de%2Fapi%2Fv2%2Fdownloads%2Fcallback&state=41c15b827cf4f848
&client_id=181dfaa4-f290-4a95-b0da-bfa37c7678c2 HTTP/1.1
> User-Agent: SAS/9
> Host: login.mypurecloud.de
> Accept: */*
> Authorization: ************
> Connection: Keep-Alive
> Cookie: ININ-Auth-Session=4m0qX4VOISel_NqdYvnlJooYzzRyUfT2YPe7S-tifsk=
> Content-Type: application/x-www-form-urlencoded
>
< HTTP/1.1 302 Found
< Date: Tue, 02 Apr 2024 15:46:09 GMT
< Content-Type: text/html; charset=utf-8
< Content-Length: 74
< Connection: keep-alive
< Critical-Origin-Trial: Tpcd
< Inin-Correlation-Id: 4b73a4a6-b842-4efc-4c34-7680f8521943
< Location: /?rid=fk63LfJSzveGLx0JYMEF0SEnqCGtK-u2pc6nPfCZs4M#/
< Origin-Trial: 
AtWQEwyDlNfIOSHxLw0HDwj2F38os7a+UMa0YpbQp8YiCbBu9AZboWA2yOa5gR3qjlOseISNzTY3h10YYs+gawwAAABfeyJvcmlnaW4iOiJodHRwczovL215cHVyZWNsb3Vk
LmRlOjQ0MyIsImZlYXR1cmUiOiJUcGNkIiwiZXhwaXJ5IjoxNzM1MzQzOTk5LCJpc1N1YmRvbWFpbiI6dHJ1ZX0=
< Set-Cookie: redirectCount=1; Path=/; Expires=Tue, 02 Apr 2024 15:47:09 GMT; Max-Age=60; HttpOnly; Secure; SameSite=None
< Set-Cookie: ININ-Auth-Session=4m0qX4VOISel_NqdYvnlJooYzzRyUfT2YPe7S-tifsk=; Path=/; Expires=Thu, 11 Apr 2024 15:46:09 GMT; 
Max-Age=777600; HttpOnly; Secure; SameSite=None
< Strict-Transport-Security: max-age=31536000
< Vary: Accept-Encoding
< 
< 00007F24F414279B: 3C 61 20 68 72 65 66 3D 22 2F 3F 72 69 64 3D 66 <a href="/?rid=f
< 00007F24F41427AB: 6B 36 33 4C 66 4A 53 7A 76 65 47 4C 78 30 4A 59 k63LfJSzveGLx0JY
< 00007F24F41427BB: 4D 45 46 30 53 45 6E 71 43 47 74 4B 2D 75 32 70 MEF0SEnqCGtK-u2p
< 00007F24F41427CB: 63 36 6E 50 66 43 5A 73 34 4D 23 2F 22 3E 46 6F c6nPfCZs4M#/">Fo
< 00007F24F41427DB: 75 6E 64 3C 2F 61 3E 2E 0A 0A                   und</a>...      
> GET /%3Frid=fk63LfJSzveGLx0JYMEF0SEnqCGtK-u2pc6nPfCZs?rid=fk63LfJSzveGLx0JYMEF0SEnqCGtK-u2pc6nPfCZs4M%23/#z HTTP/1.1
> User-Agent: SAS/9
> Host: login.mypurecloud.de
> Accept: */*
> Authorization: ************
> Connection: Keep-Alive
> Cookie: ININ-Auth-Session=4m0qX4VOISel_NqdYvnlJooYzzRyUfT2YPe7S-tifsk=; redirectCount=1
> Content-Type: application/x-www-form-urlencoded
>
< HTTP/1.1 200 OK
< Date: Tue, 02 Apr 2024 15:46:09 GMT
< Content-Length: 0
< Connection: keep-alive
< Critical-Origin-Trial: Tpcd
< Inin-Correlation-Id: 39caae69-5427-415c-4a29-a32b9e90ff59
< Origin-Trial: 
AtWQEwyDlNfIOSHxLw0HDwj2F38os7a+UMa0YpbQp8YiCbBu9AZboWA2yOa5gR3qjlOseISNzTY3h10YYs+gawwAAABfeyJvcmlnaW4iOiJodHRwczovL215cHVyZWNsb3Vk
LmRlOjQ0MyIsImZlYXR1cmUiOiJUcGNkIiwiZXhwaXJ5IjoxNzM1MzQzOTk5LCJpc1N1YmRvbWFpbiI6dHJ1ZX0=
< Set-Cookie: ININ-Auth-Session=4m0qX4VOISel_NqdYvnlJooYzzRyUfT2YPe7S-tifsk=; Path=/; Expires=Thu, 11 Apr 2024 15:46:09 GMT; 
Max-Age=777600; HttpOnly; Secure; SameSite=None
< Strict-Transport-Security: max-age=31536000
< Vary: Accept-Encoding
< 
NOTE: PROCEDURE HTTP used (Total process time):
      real time           0.22 seconds
      cpu time            0.05 seconds
      
95   
96   
97   ODS HTML CLOSE;
98   &GRAPHTERM; ;*';*";*/;RUN;QUIT;
99   QUIT;RUN;
100  ODS HTML5 (ID=WEB) CLOSE;
101  
102  ODS LISTING CLOSE;
103  FILENAME _GSFNAME;
NOTE: Fileref _GSFNAME has been deassigned.
104  DATA _NULL_;
105  RUN;
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      
106  
107  

Bests regards