topic Re: proc http method = post xpt file in SAS Procedures

proc http method = post xpt file

agno3 — Wed, 07 Dec 2022 17:34:38 GMT

Hello,

My mission(I've chosen to accept it) is to upload a zip file (bundled up XPT files in there) to an API. I'm using the code below. The issue(s) I've run into are

1) Is the code complete/correct from the MULTI PART aspect ? The client is expecting a "multipart/form-data" type of upload.

2) Do I need the boundary to be defined, considering there are multiple xpt files in the zip file ? Currently commented out. If needed, where does it go ?

Some notes:

1) There is no "data size" limiting this operation.

2) Yes, the macro variables resolve correctly. Can't share that sensitive information here.

Thanks in advance.

AgNO3.

@ChrisHemedinger


options nobomfile;
filename dd_raw "../dataraw/dd_raw.zip";
/*%let boundary=%sysfunc(uuidgen());*/


proc http url = "&base_uri/repository/container/&containerAID/&version/assetgroup/&agaid/upload"
                method='post'
        in=multi (dd_raw header = "content-type: multipart/form-data", "xpt data");
        debug level=3;
        headers 'Authorization'="Bearer &ACCESS_TOKEN";
run;

Re: proc http method = post xpt file

ChrisHemedinger — Thu, 08 Dec 2022 01:17:58 GMT

@agno3 ,

I would first try without any special options, using just POST with the ZIP file as the IN= payload. If that doesn't do the trick, see the MULTI option on PROC HTTP (documentation). Your example doesn't look like valid syntax to me.

Or, See if the example here helps with the task. This workaround was the trick to use before there was a MULTI option, I think.

Re: proc http method = post xpt file

agno3 — Thu, 08 Dec 2022 19:09:51 GMT

Thanks for your reply.

Unfortunately, neither avenues have gotten me the intended result.

As for the example you pointed out to. the PROC ends in a "Bad Request". Below is my entire code, and the log snippet. Please see the "error:"invalid_files " message. FYI - I've tried this with 4 different files - XPT,XLSX,SAS7BDAT and a ZIP file. All of them yield the same error message. And yes, these files do have ample data in them.

%let boundary=%sysfunc(uuidgen()); 
filename input1 "../dataraw/f_ae_003.xpt";

%let updestfile = f_ae_003;

data _null_;
    infile request end=eof;
    file input1;

      if _n_ = 1 then do;
        put "--&boundary"; 
        put 'Content-Disposition: form-data; name="attributes"';
        put ;
        put '{"name":"' "&updestfile" '", "parent":{"id":"' "folderID" '"}}';
        put "--&boundary"; 
        put 'Content-Disposition: form-data; name="file"; filename="' "&updestfile" '"';

        put "Content-Type: application/ASCII";
/*        put "Content-Type: application/octet-stream";*/
        put ;
      end;

    input;
    put _infile_;

    if eof then
     do;
       put "--&boundary--"; 
     end;
  run;

  data _null_;
    file input1 mod recfm=f lrecl=1;
    infile request  recfm=f lrecl=1;
    
    input;
    put _infile_;
run;


  *---------------------------------------------------------------------------------------;
  *>> Determine size of request and store in macro variable  *****************************;
  *---------------------------------------------------------------------------------------;
  data _null_;
    length bytes $1024;
    fid = fopen("input1");
    rc = fread(fid);
    bytes = finfo(fid, 'File Size (bytes)');
    call symput("FileSize",trim(bytes));
    rc = fclose(fid);
    put bytes;
  run;

  *---------------------------------------------------------------------------------------;
  *>> Submit the Upload request to Box  **************************************************;
  *---------------------------------------------------------------------------------------;
  proc http
      url=  "&base_uri/repository/container/&containerAID/&version/assetgroup/&agaid/upload"
        method    = "POST"
        out       = resp
        headerout = headout
        in        = input1
        ct        = "multipart/form-data; boundary=&boundary"
    ;
    headers
      "Authorization"  = "Bearer &ACCESS_TOKEN"
      "Content-Length" = "&filesize"
    ;
	debug level=3;

  run;

As for the SAS documentation link, something seems off (atleast to me) as word POST is not wrapped in quotes. And even when I add quotes, it doesnt "finish" running...

Help here will be abundantly appreciated.

thanks.

Re: proc http method = post xpt file

ChrisHemedinger — Thu, 08 Dec 2022 19:35:42 GMT

I usually start with the API documentation, which often has examples that use cURL or another language. From there it's simple to transcribe to the equivalent in SAS PROC HTTP. Is there doc for the API? I understand your data is sensitive, but is the system you're using a well-known service?