Read Multipart/for-data attachment via sas

[chithra]

Hi,

I am reposting the same which i posted accidentally in the sas programming forum.

i need to read the attachemnt(file.zip) from the client and create a sas webservice(stored process) in sas.

what the storedprocess needs to do is, read the attachemnt from the request body and copy to one of the folder in the sas server.

Could anyone know about this?

we are using Restful webservice and can be tested in REST API/Client


Thanks,
Chithra

[AllanBowe]

 Hi Chithra,

This is more a collection of pointers than a full solution, but should lead you on the right path.  

Step 1 - Loading your zip file to the SAS server

For this you can use a form, or ajax, in your web front end.  The form approach is documented here:  https://support.sas.com/documentation/cdl/en/stpug/61271/HTML/default/viewer.htm#a003254547.htm

Step 2 - Find and Unzip using SAS and save to folder

The file you uploaded will be stored in a macro variable named

_WEBIN_FILEREF1

To avoid a subsequent move of the folder, the best approach would be to unzip it directly to the target location.  You can do this using a pipe:

infile"unzip %sysfunc(pathname(&_WEBIN_FILEREF1)) -d &target_location" pipe;

Or with a pure sas approach - https://blogs.sas.com/content/sasdummy/2015/05/11/using-filename-zip-to-unzip-and-read-data-files-in....

Hope this helps!  SAS is a great platform for building web applications.  For further reference materials, check out the following:

• https://www.linkedin.com/pulse/5-tips-sas-app-developers-allan-bowe/
• https://support.sas.com/resources/papers/proceedings17/1091-2017.pdf
• https://support.sas.com/resources/papers/proceedings17/1372-2017.pdf

There is also a SPWA tag on Sasensei with a number of tips on this topic.

[chithra]

Hi,

This is a new information for me and it really helps me.

STEP 1: I tried the html but I am getting "Unsupported Media Type", do I need to configure anything in the storedprocess which I created?

I created a stored process via SAS enterprise guide and copy the infile command you created there, but didn't add any prompts, datasouce targets etc.. is this the reason for the error message?

Thanks,

Chithra

[chithra]

can anyone help me here?

[Kurt_Bremser]

Where do you get the "Unsupported Media Type" message? When you hit "OK" in the web form, or in the SAS log of the stored process?

Please post your HTML code for the form, and the code of the stored process.

[chithra]

i created a sample stored process with out any content, just a %put comment.

The webservice is not triggered at all, if so we need to get any error atleast.

i triggered using REST client/postman  and through HTML form.

Both i get unsupported media type. 

<form action="StoredProcessWebApplicationURL" method="post" enctype="multipart
                         /form-data">
<input type="hidden" name="_program" value="/Path/StoredProcessName">
<table border="0" cellpadding="5">
   <tr>
      <th>Choose a file to upload:</th>
      <td><input type="file" name="myfile"></td>
   </tr>
   <tr>
      <td colspan="2" align="center"><input type="submit" value="OK"></td>
   </tr>
</table>
</form>

[AllanBowe]

As Kurt mentions, we need more information on what you are actually doing. Regarding the STP, be sure to create it WITHOUT headers / footers (stpbegin / end) and set it to have STREAM output to give you control over the response using _WEBOUT. No need for prompts.

[chithra]

I created a stored process in SAS enterprise guide, with no logical code inside, 

select execution option in storedprocess server and doesn't add any data source targets etc..

file-->new-->storedprocess

through html form and using rest client/postman i uploaded a file with content type multipart/form-data and hit send button in rest client/api and ok button in html form and i am getting unsupported media type.

Does this means sas 9.4 is not suppporting this media type or do i need to change anyting in the stored process or any configuration changes in the sas server?

when i use other content types such as text/xml etc...i am not getting this message atleast i am getting some error.

[AllanBowe]

can you post a screenshot? Are these messages coming from SAS or from Postman? Loading a file to a stored process should not (by itself) cause any errors.

[boemskats]

Assuming this is relating to STPs deployed as Web Services to the SASBIWS webapp, and called via the REST interface as documented here?