Trying to parse a Salesforce login response using groovy in SoapUI 3.5

Question

I need to extract the serverUrl and sessionId from the response I get from a Salesforce login request using a Saleforce developer setup.&nbsp; The response comes back just fine and looks like this:&nbsp;  &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;metadataserverurl&gt;https://na7-api.salesforce.com/services ... 000000KYuL&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; false&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; false&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; https://na7-api.salesforce.com/services ... 000000KYuL&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 00DA0000000KYuL!ARgAQDutrkJyY4HK73.HsH6sosqaMSMtOk6pSFL2fnhIWYTpUD0xAGRjUxKtlGQ50RxVf15g0FEk2NTmhOotmeBFgZVYL42z&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 005A0000000RfaYIAS&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  false&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  $&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  USD&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  false&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  false&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  00DA0000000KYuLMAW&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  false&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  Villanova University&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  00eA0000000nzgpIAA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  cris.lawrence@villanova.edu&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  Cris Lawrence&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  005A0000000RfaYIAS&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  en_US&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  en_US&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  cris.lawrence@verizon.net&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  America/Los_Angeles&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  Standard&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  Theme2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  &nbsp; &nbsp; &nbsp; &nbsp;  log.info("Login Response")groovyUtils = new com.eviware.soapui.support.GroovyUtils( context )holder = groovyUtils.getXmlHolder("Test Request#Response" )log.info("Response: " + holder.xml)serverUrl = holder.getNodeValue( "//serverUrl" )assert serverUrl != nullThe assert fails although the holder.xml string does show the entire xml response.&nbsp; Any node I substitute for 'serverUrl' in the xpath gives me the same result.&nbsp; Any reason why this doesn't work?&nbsp; Is there another way for me to get my data without resorting searching the string?Thanks for any and all help.- Cris

m_mcdonald · Answer

Try this:holder.declareNamespace("default","urn:enterprise.soap.sforce.com")def serverUrl = holder.getNodeValue( "//default:serverUrl" )assert serverUrl != null

crislawrence · Answer

Perfect!&nbsp; Worked!&nbsp; Thx a bunch!!

Forum Discussion

Trying to parse a Salesforce login response using groovy in SoapUI 3.5

2 Replies

Recent Discussions

Signature\Encryption tags missing in Security Header

CVE-2024-7565 and CVE-2017-16670 vulnabilities

Vulnerabilities found in SoapUI 5.9.1

Related Content

Trying to download attachment in response

Trying to remove CDATA from response not working

SaaS Platforms Like Salesforce – Automation: Feasible or Futile?