Context What a concept. Apologies should have been more succinct. After scrubbing a lot of data I have this XML wrapper coming to me.
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:sch="http://somewhere.us.com/is/cs/schema" xmlns:sch1="http://somewhere.us.com/is/common/schema">
<soapenv:Header />
<soapenv:Body>
<sch:ANBRRequest>
<sch:ANBRReq>
<sch1:userId>XXYYZZ</sch1:userId>
<!--Optional: -->
<sch1:clientNumber>0001</sch1:clientNumber>
<!--Optional: -->
<sch:SaveFormsList>
<!--1 or more repetitions: -->
<sch:SaveForms>
<sch:accountKey>
<!--Optional: -->
</sch:accountKey>
<sch1:repId>UUU</sch1:repId>
<sch1:formId>YYYY</sch1:formId>
<sch:docDate>
<sch1:day>09</sch1:day>
<sch1:month>01</sch1:month>
<sch1:year>2015</sch1:year>
</sch:docDate>
<sch:docId>XXXXXXYYYYYYYZZZZZZ</sch:docId>
<sch1:updateADTS />
<sch:attachmentRawData contentType="application/pdf">
<sch:attachmentData></sch:attachmentData>
[Attachments would typically be here. Show in attached file]
</sch:attachmentRawData>
</sch:SaveForms>
</sch:SaveFormsList>
<!-- <TXLife</TXLife> data in binary format-->
<sch:fullNoNStdXML contentType="application/xml">
[Attachment would typically be here.To Be inserted to a data column rowset. Index created by DocDate]
</sch:fullNoNStdXML>
</sch:ANBRReq>
</sch:ANBRRequest>
</soapenv:Body>
</soapenv:Envelope>
So from this the application pdf's node is handle by another procedure for document storage. I need to store the fullNoNStdXML attachment to a datatable that would also include some of the data elements in the body for indexing (i.e. docId, month, year, day, userid, etc..)
GG