title: Call a WebService if value not found in an XML result
body: <p>From a MySQL query, I am trying to iterate on every rows to:</p>
  <ol>
  <li>Test the existence of an object using a webservice</li>
  <li>Then if the object doesn't exist yet, I will add it using another webservice, otherwise I do nothing.</li>
  <li>Update in any case a MySQL DB table.</li>
  </ol>
  <p>Here is what I've done so far:</p>
  <p><a href="https://i.stack.imgur.com/lNf7s.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/lNf7s.png" alt="enter image description here" /></a></p>
  <ul>
  <li>First I create the connection</li>
  <li>I get the columns I need from my MySQL query</li>
  <li>I start iterating</li>
  <li>I call my webservice which give me a <strong>String</strong> holding XML (column name: ResultXML)
  <a href="https://i.stack.imgur.com/UCEBI.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/UCEBI.png" alt="enter image description here" /></a></li>
  <li>I extract from this XML the values I need (column name: ResultExtract)</li>
  <li>Then I want to test if one of the values extracted is equal to a specific value (let's say 10).</li>
  </ul>
  <p>So from my my <strong>tExtractXMLField</strong>, I get something like :</p>
  <blockquote>
  <p>150</p>
  <p>10</p>
  </blockquote>
  <p>So this would mean that I won't have called the 2nd webservice.</p>
  <p>I can't find how to look for my value in the result (the result can also be empty and then no row would come from the <strong>tExtractXMLField</strong>).
  I tried to use a <strong>tJava</strong> after the <strong>tExtractXMLField</strong> component to split my result as a List but the <strong>tJava</strong> component is running before the 1st webservice has finished so I get NULL.</p>
  <p>Maybe there is a better way to do what I've already done, and if so, I am also pleased to receive your recommandation.</p>