title: Converting output of a GET Zap so we can read a specific piece of data
body: <p>Sorry in advance if this is not the correct place for this question, it is where I was pointed to put it.</p>
  <p>So we are sending a request to Moodle via the GET function. The return that we get is this:</p>
  <p>RESPONSE</p>
  <p>MULTIPLE</p>
  <pre><code>  SINGLE
  
        KEY
         VALUE
            **12**
        KEY2
         VALUE
             18
        KEY3
         VALUE
            **1010**
        KEY4
         VALUE
            &quot;
        KEY5
         VALUE
            1
        KEY6
         VALUE
            null
        KEY7
         VALUE
            null
    SINGLE2
  </code></pre>
  <p>I've highlighted what I am trying to get to, here are the problems. We get multiple returns that are in alphabetical order, not data created.</p>
  <p>We need to scan through the different Key3s to find the right value (in this example 1010) and then look back up the the Key (Key1) to get the return (in this case 12).</p>
  <p>This will be dynamic (the 1010 value is a variable that we will know in advance and can therefore 'look' for).</p>
  <p>I could probably do this, but in the next step each key is returned on a individual line, not as one set of data. This wouldn't be an issue, but as there are a variable number of single returns that aren't in a set order, I need to convert it to one data set (I think).</p>
  <p>Any ideas?
  Thanks in advance.</p>