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='Genesys Cloud'
method="get"
out=out
headerout=hdrout
ct="application/x-www-form-urlencoded";
debug level=3;
run;
Below the program execution log :
81 options sastrace=',,,d' sastraceloc=saslog;
82 filename out "\tmp\GenesystmpOutput.csv";
83 filename hdrout "\tmp\GenesystmpResponse.csv";
84 proc http
85 AUTH_BASIC
86 WEBUSERNAME ="xxxxxxxx"
87 WEBPASSWORD =XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
88 url='https://apps.mypurecloud.de/platform/api/v2/downloads/41c15b827cf4f848'
89 method="get"
90 out=out
91 headerout=hdrout
92 /*ct="application/json"*/
93 ct="application/x-www-form-urlencoded"
94 /*HEADEROUT_OVERWRITE*/;
95 debug level=3;
96
97 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: Mon, 01 Apr 2024 15:31:06 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: 1d3aa5ab-ab99-4355-ab46-79e3709a4c4a
< 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=8i1tm_gCCPYBZmIztxGMt8GUIxG1NCEWdx9xEdXfKHw=
> Content-Type: application/x-www-form-urlencoded
>
< HTTP/1.1 302 Found
< Date: Mon, 01 Apr 2024 15:31:06 GMT
< Content-Type: text/html; charset=utf-8
< Content-Length: 74
< Connection: keep-alive
< Critical-Origin-Trial: Tpcd
< Inin-Correlation-Id: f3d176bf-2f77-4b9a-4dce-f7001f4a5813
< Location: /?rid=Qhsnx7qS3rHSDM7MU85ZyQfJNQTHBje6ijrGNSQ6Lzk#/
< Origin-Trial:
AtWQEwyDlNfIOSHxLw0HDwj2F38os7a+UMa0YpbQp8YiCbBu9AZboWA2yOa5gR3qjlOseISNzTY3h10YYs+gawwAAABfeyJvcmlnaW4iOiJodHRwczovL215cHVyZWNsb3Vk
LmRlOjQ0MyIsImZlYXR1cmUiOiJUcGNkIiwiZXhwaXJ5IjoxNzM1MzQzOTk5LCJpc1N1YmRvbWFpbiI6dHJ1ZX0=
< Set-Cookie: redirectCount=1; Path=/; Expires=Mon, 01 Apr 2024 15:32:06 GMT; Max-Age=60; HttpOnly; Secure; SameSite=None
< Set-Cookie: ININ-Auth-Session=8i1tm_gCCPYBZmIztxGMt8GUIxG1NCEWdx9xEdXfKHw=; Path=/; Expires=Wed, 10 Apr 2024 15:31:06 GMT;
Max-Age=777600; HttpOnly; Secure; SameSite=None
< Strict-Transport-Security: max-age=31536000
< Vary: Accept-Encoding
<
< 00007F1E7543945B: 3C 61 20 68 72 65 66 3D 22 2F 3F 72 69 64 3D 51 <a href="/?rid=Q
< 00007F1E7543946B: 68 73 6E 78 37 71 53 33 72 48 53 44 4D 37 4D 55 hsnx7qS3rHSDM7MU
< 00007F1E7543947B: 38 35 5A 79 51 66 4A 4E 51 54 48 42 6A 65 36 69 85ZyQfJNQTHBje6i
< 00007F1E7543948B: 6A 72 47 4E 53 51 36 4C 7A 6B 23 2F 22 3E 46 6F jrGNSQ6Lzk#/">Fo
< 00007F1E7543949B: 75 6E 64 3C 2F 61 3E 2E 0A 0A und</a>...
> GET /%3Frid=Qhsnx7qS3rHSDM7MU85ZyQfJNQTHBje6ijrGNSQ6L?rid=Qhsnx7qS3rHSDM7MU85ZyQfJNQTHBje6ijrGNSQ6Lzk%23/#3 HTTP/1.1
> User-Agent: SAS/9
> Host: login.mypurecloud.de
> Accept: */*
> Authorization: ************
> Connection: Keep-Alive
> Cookie: ININ-Auth-Session=8i1tm_gCCPYBZmIztxGMt8GUIxG1NCEWdx9xEdXfKHw=; redirectCount=1
> Content-Type: application/x-www-form-urlencoded
>
< HTTP/1.1 200 OK
< Date: Mon, 01 Apr 2024 15:31:06 GMT
< Content-Length: 0
< Connection: keep-alive
< Critical-Origin-Trial: Tpcd
< Inin-Correlation-Id: b2c921ea-ba0e-4130-61e6-d0ed069c9f6b
< Origin-Trial:
AtWQEwyDlNfIOSHxLw0HDwj2F38os7a+UMa0YpbQp8YiCbBu9AZboWA2yOa5gR3qjlOseISNzTY3h10YYs+gawwAAABfeyJvcmlnaW4iOiJodHRwczovL215cHVyZWNsb3Vk
LmRlOjQ0MyIsImZlYXR1cmUiOiJUcGNkIiwiZXhwaXJ5IjoxNzM1MzQzOTk5LCJpc1N1YmRvbWFpbiI6dHJ1ZX0=
< Set-Cookie: ININ-Auth-Session=8i1tm_gCCPYBZmIztxGMt8GUIxG1NCEWdx9xEdXfKHw=; Path=/; Expires=Wed, 10 Apr 2024 15:31:06 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.24 seconds
cpu time 0.04 seconds
98
99
100 ODS HTML CLOSE;
101 &GRAPHTERM; ;*';*";*/;RUN;QUIT;
102 QUIT;RUN;
103 ODS HTML5 (ID=WEB) CLOSE;
104
105 ODS LISTING CLOSE;
106 FILENAME _GSFNAME;
NOTE: Fileref _GSFNAME has been deassigned.
107 DATA _NULL_;
108 RUN;
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
109
110
Bests regards