topic Re: Read Multipart/for-data attachment via sas in Developers

Read Multipart/for-data attachment via sas

chithra — Sun, 20 Jan 2019 13:32:23 GMT

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

Re: Read Multipart/for-data attachment via sas

AllanBowe — Sun, 20 Jan 2019 13:56:14 GMT

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-sas/.

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

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

Re: Read Multipart/for-data attachment via sas

chithra — Mon, 21 Jan 2019 05:28:14 GMT

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

Re: Read Multipart/for-data attachment via sas

chithra — Mon, 21 Jan 2019 09:05:48 GMT

can anyone help me here?

Re: Read Multipart/for-data attachment via sas

Kurt_Bremser — Mon, 21 Jan 2019 13:38:47 GMT

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.

Re: Read Multipart/for-data attachment via sas

AllanBowe — Mon, 21 Jan 2019 21:16:27 GMT

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.

Re: Read Multipart/for-data attachment via sas

chithra — Tue, 22 Jan 2019 04:39:24 GMT

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>

Re: Read Multipart/for-data attachment via sas

chithra — Tue, 22 Jan 2019 04:44:52 GMT

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.

Re: Read Multipart/for-data attachment via sas

AllanBowe — Tue, 22 Jan 2019 22:07:10 GMT

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.

Re: Read Multipart/for-data attachment via sas

boemskats — Wed, 27 Feb 2019 17:02:52 GMT

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