topic Re: calling SAS bi web services with attachments in SAS Programming

calling SAS bi web services with attachments

cpagrawal — Thu, 31 Mar 2022 09:48:09 GMT

Does anyone knows how to attach a file when calling a SAS BI web service ( json in my case ) ?
I am trying to set up the content-type but it is not working, probably I am using a wrong one. Any help will be appreciated.
I want to attach a file which will be read by stored process ( calling as an api ) and I will get response which is very short.

thank you.

Re: calling SAS bi web services with attachments

andreas_lds — Thu, 31 Mar 2022 12:38:57 GMT

afaik the sp-web-app can't handle attachments. You could provide path+name of file, but this is, of course, not what you want.

Re: calling SAS bi web services with attachments

Quentin — Thu, 31 Mar 2022 14:00:08 GMT

I haven't called stored processes as a web service, but this old thread talks about building a STP that allows a user to upload a file from a html form. Perhaps could be adapted for your need. https://communities.sas.com/t5/SAS-Stored-Processes/Uploading-a-file-through-an-html-form/td-p/203124

Re: calling SAS bi web services with attachments

cpagrawal — Thu, 31 Mar 2022 14:48:07 GMT

I am not sure still if file type is not supported.

https://documentation.sas.com/doc/en/itechcdc/9.4/wbsvcdg/n0e44v8zffokk6n1b5uu2alusw8p.htm
if we use multi part when sending the request, it should be able to retrieve the attachment but I am not able to do that. on the other side I am thinking what could be option if I use rest instead of json.