topic Re: How to read a table from XML Input call in SOAP ? in SAS Programming

How to read a table from XML Input call in SOAP ?

UdayGuntupalli — Thu, 30 Aug 2018 18:20:54 GMT

All,

I am trying to build a SOAP API. The API requires one of the inputs to be a table of information. Can anyone kindly provide an example of the correct format to read in a table as an input from XML Soap invocation call. Appreciate your help.

Re: How to read a table from XML Input call in SOAP ?

ChrisNZ — Fri, 31 Aug 2018 02:15:04 GMT

I never used SOAP, but have you seen this?

http://support.sas.com/documentation/cdl/en/wbsvcdg/64883/HTML/default/viewer.htm#n0e44v8zffokk6n1b5uu2alusw8p.htm

Re: How to read a table from XML Input call in SOAP ?

UdayGuntupalli — Sat, 01 Sep 2018 04:31:27 GMT

@ChrisNZ,
Thank you for your response. Yes, I have seen this. It only covers single parameters, however I am trying to look into passing a table as input.

Re: How to read a table from XML Input call in SOAP ?

ChrisNZ — Sun, 02 Sep 2018 22:19:05 GMT

I am afraid I am out of my depth, but maybe @ArvAmundson or @MagnusGustavsson or @BrunoMueller would be able to help?

Re: How to read a table from XML Input call in SOAP ?

ArvAmundson — Tue, 04 Sep 2018 12:39:06 GMT

Just to clarify. Are you trying to take one or more columns from a SAS table and populate fields in the request XML file that you submit with the PROC SOAP?

Re: How to read a table from XML Input call in SOAP ?

UdayGuntupalli — Tue, 04 Sep 2018 15:09:48 GMT

@ArvAmundson,
No. I am trying to just pass a table from another application for e.g. say C# pass a table in its XML soap request to the service

Re: How to read a table from XML Input call in SOAP ?

ArvAmundson — Tue, 04 Sep 2018 15:15:31 GMT

I can't help you then. I have looped thru tables one record at a time with a macro and used the contents to fill out the request XML. However, I have not used it to transfer a whole table.

Re: How to read a table from XML Input call in SOAP ?

BrunoMueller — Wed, 05 Sep 2018 20:37:44 GMT

Have you already defined the Stored Process with Input/Output data source definitions and looked at the WSDL coming back from the webservice, this should reflect how to provide the data.

Here is sample code on how to access the XML data passed in:

libname ws_ixml xmlv2;

proc copy in=ws_ixml out=work;
run;

proc contents data=work._all_ ;
run;

proc print data=work.t1;
run;

The definition of the WS_IXML looks like this:

The Web Service request looks like this:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:biw="http://www.sas.com/xml/namespace/biwebservices">
   <soapenv:Header/>
   <soapenv:Body>
      <biw:ws_input_data>
         <biw:streams>
            <biw:ws_ixml contentType="?">
               <biw:Value>
                  <!--You may enter ANY elements at this point-->
                  <root>
                     <t1>
                        <c1>r1c1</c1>
                        <c2>r1c2</c2>
                        <c3>123</c3>
                        <c4>2018-09-05</c4>
                     </t1>
                     <t1>
                        <c1>r2c1</c1>
                        <c2>r2c2</c2>
                        <c3>456</c3>
                        <c4>2018-09-05</c4>
                     </t1>
                  </root>
               </biw:Value>
            </biw:ws_ixml>
         </biw:streams>
      </biw:ws_input_data>
   </soapenv:Body>
</soapenv:Envelope>

The request xml was taken from SoapUI.

So the XML between the <biw:Value></biw:Value> tags can be read using the XMLV2 libname engine.

The XML data passed in to the WS_IXML libref can be read without using a XML Map file.

<root> is the root tag, <t1> is the table name, each repeating <t1> ... </t1> is treated as an observation. The <c4> column is an example how to pass in a date.

You can get the WSDL of a Stored process called as a SAS Webservice like this:

http://host:port/SASBIWS/services/<metadata folder name>/<stored process name>?WSDL

Hope this helps