how to use substring in PropertyTransfer

Question

I want to transfer one attribute value from 1 request to another request.i have used PropertyTransfer step to do the same.but the actual value is present in the description format (highlighted in bold below).and 2nd request will have below full string.e.g.Attribute 'Party ID' is transformed from ('') to ('49025')&nbsp;I just need to transfer the value i.e. 49025&nbsp;so what step should i use to do a substring?&nbsp;request1 response:&nbsp;&lt;soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"&gt;&nbsp; &lt;soapenv:Body&gt;&nbsp; &nbsp; &nbsp; &lt;DataService version="2.0" xsi:schemaLocation="http://www.tibco.com/cim/services/mastercatalogrecord/wsdl/2.0&nbsp;schemas/MasterCatalogRecord_Action.xsd" xmlns="http://www.tibco.com/cim/services/mastercatalogrecord/wsdl/2.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;Transaction&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;Response type="Add"&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;MasterCatalogRecord etype="Entity" commandqualifier="Validate/NoProcess"&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;ExternalKeys&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;Key name="MASTERCATALOGNAME"&gt;PARTY_2&lt;/Key&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/ExternalKeys&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;EntityData&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;Attribute name="PartyType" type="string"&gt;Individual&lt;/Attribute&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;Attribute name="NamePrefix" type="string"&gt;Mr.&lt;/Attribute&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;Attribute name="FirstName" type="string"&gt;Hemali&lt;/Attribute&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;Attribute name="LastName" type="date"&gt;Shinde&lt;/Attribute&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;Attribute name="NameSuffix" type="string"&gt;Sr.&lt;/Attribute&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;Attribute name="Gender" type="string"&gt;Female&lt;/Attribute&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/EntityData&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;ResultList highestSeverity="Info" reference="PartyName"&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;Result severity="Info" code="GEN-7300"&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;Description lang="en"&gt;Attribute 'Party Name' is transformed from ('') to ('Mr. Hemali Shinde Sr.')&lt;/Description&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/Result&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/ResultList&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;ResultList highestSeverity="Info" reference="RELATIONSHIP_LIST"&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;Result severity="Info" code="GEN-7300"&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;Description lang="en"&gt;attribute RELATIONSHIP_LIST assigned value = [Contact_Details, Associated_Organisation]&lt;/Description&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/Result&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/ResultList&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;ResultList highestSeverity="Info" reference="PRODUCTID"&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;Result severity="Info" code="GEN-7300"&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;Description lang="en"&gt;Attribute 'Party ID' is transformed from ('') to ('49025')&lt;/Description&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/Result&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/ResultList&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/MasterCatalogRecord&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;ResultList highestSeverity="Info" reference="Add"&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;Result severity="Info" code="SVC-11025"&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;Description lang="en"&gt;Service 'Validate/NoProcess' executed successfully.&lt;/Description&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/Result&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/ResultList&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/Response&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;TransactionResult result="Completed"&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;SuccessCount&gt;1&lt;/SuccessCount&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;EventID&gt;40041&lt;/EventID&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/TransactionResult&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;/Transaction&gt;&nbsp; &nbsp; &nbsp; &lt;/DataService&gt;&nbsp; &lt;/soapenv:Body&gt;&lt;/soapenv:Envelope&gt;&nbsp;&nbsp;Request 2 Request: ( it should have only that ID )&nbsp;&lt;soapenv:Envelope xmlns:ns="http://www.tibco.com/cim/services/mastercatalogrecord/wsdl/2.0" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"&gt;&nbsp;&lt;soapenv:Header/&gt;&lt;soapenv:Body&gt;&nbsp;&lt;DataService version="2.0" xmlns:ns0="http://www.tibco.com/cim/services/mastercatalogrecord/wsdl/2.0"&gt;&nbsp;&nbsp;&lt;Identity&gt;&nbsp;&nbsp;&nbsp; &lt;DirectoryPath&gt;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &lt;Directory type="Enterprise"&gt;&lt;/Directory&gt;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &lt;Directory type="User"&gt;&lt;/Directory&gt;&nbsp;&nbsp;&nbsp; &lt;/DirectoryPath&gt;&nbsp;&nbsp;&nbsp; &lt;Authentication type="Password"&gt;&lt;/Authentication&gt;&lt;/Identity&gt;&lt;Transaction&gt;&lt;Command type="Delete"&gt;&lt;MasterCatalogRecord commandqualifier="Record" etype="Entity"&gt;&lt;ExternalKeys&gt;&nbsp;&nbsp;&nbsp; &lt;Key name="MASTERCATALOGNAME"&gt;PARTY_2&lt;/Key&gt;&nbsp;&nbsp;&nbsp; &lt;Key name="PRODUCTID" type="String"&gt;Attribute 'Party ID' is transformed from ('') to ('49026')&lt;/Key&gt;&lt;/ExternalKeys&gt;&nbsp;&lt;/MasterCatalogRecord&gt;&nbsp;&lt;/Command&gt;&nbsp;&lt;/Transaction&gt;&nbsp;&lt;/DataService&gt;&nbsp;&lt;/soapenv:Body&gt;&nbsp;&lt;/soapenv:Envelope&gt;&nbsp;Kindly help.&nbsp;Thanks,kanchan

lucian · Answer

You can use a groovy script to extract the id. If the message "Attribute Party Id.." is always the same this should work:&nbsp;// Get the raw response from a certain test step
def rawResponse = testRunner.testCase.testSteps["NameOfYourRequestTestStep"].testRequest.response.contentAsString
// Find the index where the product id begins
def startIndexOfId = rawResponse.indexOf("Attribute 'Party ID' is transformed from ('') to ('") + "Attribute 'Party ID' is transformed from ('') to ('".length()
// Cut the string from the beggining of the id to the end of the rawResponse
def id = rawResponse.substring( startIndexOfId )
// Find the place where the id is ending
def endIndexOfId = id.indexOf("')")
// Extract the id
id = id.substring( 0, endIndexOfId )&nbsp;Cheers!

Forum Discussion

how to use substring in PropertyTransfer

1 Reply

Related Content

Substring not working

Search for a substring using wildcards

Python code to return a substring using regular expressions?

Insert Prefix to a Groovy Generated Substring value?

Selecting items by substring in tree view

Recent Discussions

Parameterising JDBC Connection Settings..Can you do it?

Test Runner - Report All in One File

GroovyScript Help - Repeating JSON Attributes Have Specific Value.....some of the time?

JDBC results are stored in the ReadyAPI project

MyFirstPlugin - button Project menu in Ready Api