Postman SQL Queries

This SQL query searches for translation patterns with a description that includes “Main Line” returning both the translated and original pattern and the description, sorting by the translation pattern.

<pre class="wp-block-code"><code>&lt;soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.cisco.com/AXL/API/14.0"&gt;
   &lt;soapenv:Header/&gt;
   &lt;soapenv:Body&gt;
     &lt;ns:executeSQLQuery&gt;
         &lt;sql&gt;
            SELECT description, dnorpattern,calledPartyTransformationMask
            FROM numplan np
             WHERE np.tkpatternusage = 3
             AND np.iscallable = 't'
             AND description like '<strong>% Main Line%</strong>'
              ORDER BY dnorpattern
        &lt;/sql&gt;
      &lt;/ns:executeSQLQuery&gt;
   &lt;/soapenv:Body&gt;
&lt;/soapenv:Envelope&gt;</code></pre>

This SQL query searches for route patterns that include ‘associated device’ that contain ‘fax’. Returning the route pattern and the description.

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.cisco.com/AXL/API/14.0">
   <soapenv:Header/>
   <soapenv:Body>
      <ns:executeSQLQuery>
         <sql>
             SELECT dnorpattern, numplan.description
             FROM numplan,device,devicenumplanmap
             WHERE numplan.tkpatternusage=5
             and devicenumplanmap.fkdevice=device.pkid
             and devicenumplanmap.fknumplan=numplan.pkid
             AND device.name like 'fax'
        </sql>
      </ns:executeSQLQuery>
   </soapenv:Body>
</soapenv:Envelope>