Extract SOAP XML attribute value from datafile to provide JDBC request with query filter value

Hey Radford

Thanks for reply - I do appreciate it!

I edited the file as implied (see below) but I'm getting an org.xml.sax.SAXParseException; Premature end of file. error at line :14 response.

I'm not a coder - I spent a couple of hours trying to work out the problem but the google help is talking about instreams/outstreams and I just haven't got a clue!  The data files in the directory are all wellformed.

import groovy.util.XmlSlurper

// Get XML from data source property
def xmlText = context.expand( '${DataSource#contents}' )

//Example XML just to demo XmlSlurper
//def xmlText = '''<element1>
//	<element2>
//		<element3 RecordID='123'>fred</element3>
//	</element2>
//</element1>
//'''

def xml = new XmlSlurper().parseText(xmlText)

log.info(xml.element2.element3.@RecordID)

I'm totally lost!

Thanks again!

Hey Rao,

You're doing me the favour so more than happy to supply anything you need!  

please see below - the XML contained within my test data file is as below:

<RecordInput xsi:noNamespaceSchemaLocation="file:///D:/Folder/CSMRecord_v1_0_0.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<RecordProfile RecordID="D8765" RequestedDateTime="20170412163030999">
<RecordName>Record NAME 20 CHARSS</RecordName>
<LocationName>LOCATION NAME OF Record 30 CHAR</LocationName>
<BuildingName>LOCATION NAME OF Record 30 CHAR</BuildingName>
<InternalLocation>XINTERNAL LOCATION WITH A LARGE 50 CHARACTER LIMIT</InternalLocation>
<ExternalLocation>XEXTERNAL LOCATION WITH A LARGE 50 CHARACTER LIMIT</ExternalLocation>
<Address Type="V">
<CompanyName>C NAME NOT FOR Record</CompanyName>
<Line>30 CHARACTER 1ST LINE -ADDRESS</Line>
<Line>30 CHARACTER 2ND LINE -ADDRESS</Line>
<Line>30 CHARACTER 3RD LINE -ADDRESS</Line>
<Line>30 CHARACTER 4TH LINE -ADDRESS</Line>
<Postcode>AB10 1XG</Postcode>
<Latitude>57.14416516</Latitude>
<Longitude>-2.114847768</Longitude>
</Address>
<Telno>07581455199</Telno>
<MaxBedNo>99</MaxBedNo>
<NGArea>NJ</NGArea>
<InUse>Y</InUse>
<RegionCode>RC</RegionCode>
<FixSite>N</FixSite>
<SectorCode>SC</SectorCode>
</RecordProfile>
</RecordInput>

The Soap request I am trying to post to the web service is as follows:

<soapenv:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:urn="urn:CSMRecordServicesIntf-ICSMRecordServices">
   <soapenv:Header/>
   <soapenv:Body>
      <urn:Venue soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
         <i_RecordXML xsi:type="xsd:string">${DataSource#FileContent}</i_RecordXML>
         <i_Database xsi:type="xsd:string">?</i_Database>
         <i_UserID xsi:type="xsd:string">?</i_UserID>
      </urn:Venue>
   </soapenv:Body>
</soapenv:Envelope>

As you can see - I've created a FileContent property in the Datasource step which I intend to populate the i_RecordXML tag in the post to the web service.

I think I've given you too much background - anyway.....the original point which I'm stuck on is that I want to scrape the content of the XML (in the datafile) for the RecordID attribute value current as 'D8765' in my XML datafile and then use this as the query in a where clause (select * from table where RecordID='D8765';) in a subsequent JDBC step (essentially I need to query the database once the post to the webservice to confirm if the database has been updated with the new record.

Thanks again for all/any guidance/advice etc. - I apologise if I've supplied too much info - I just want to make it nice and clear!

Cheers!

richie