Legacy Dev Forum Posts

 View Only

Sign Up

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

  • 1.  Download a genesys cloud csv file through a static link using proc http

    Posted 06-05-2025 18:30

    Fafa | 2024-04-03 11:32:00 UTC | #1

    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;

    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


    system | 2024-05-03 11:32:55 UTC | #2

    This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.


    This post was migrated from the old Developer Forum.

    ref: 25535