title: Error with ampersand in XML in Zoho API
body: <p>I'm using the Zoho API to insert leads into the CRM.</p>
  
  <p>Everything is working fine except when one of the fields contains an ampersand, in which case the response from Zoho is this:</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8" ?&gt;
  &lt;response uri="/crm/private/xml/Leads/insertRecords"&gt;
    &lt;error&gt;
      &lt;code&gt;4835&lt;/code&gt;
      &lt;message&gt;Unable to parse XML data&lt;/message&gt;
    &lt;/error&gt;
  &lt;/response&gt;
  </code></pre>
  
  <p>I've tried the following payloads without any success:</p>
  
  <p><strong>1/</strong></p>
  
  <pre><code>&lt;Leads&gt;
      &lt;row no="1"&gt;
          &lt;FL val="Lead Owner"&gt;me@example.com&lt;/FL&gt;
          &lt;FL val="Company"&gt;Marks &amp; Spencer&lt;/FL&gt;
      &lt;/row&gt;
  &lt;/Leads&gt;
  </code></pre>
  
  <p><strong>2/</strong></p>
  
  <pre><code>&lt;Leads&gt;
      &lt;row no="1"&gt;
          &lt;FL val="Lead Owner"&gt;me@example.com&lt;/FL&gt;
          &lt;FL val="Company"&gt;Marks &amp;amp; Spencer&lt;/FL&gt;
      &lt;/row&gt;
  &lt;/Leads&gt;
  </code></pre>
  
  <p><strong>3/</strong></p>
  
  <pre><code>&lt;Leads&gt;
      &lt;row no="1"&gt;
          &lt;FL val="Lead Owner"&gt;me@example.com&lt;/FL&gt;
          &lt;FL val="Company"&gt;Marks &amp;#038; Spencer&lt;/FL&gt;
      &lt;/row&gt;
  &lt;/Leads&gt;
  </code></pre>
  
  <p><strong>4/</strong></p>
  
  <pre><code>&lt;Leads&gt;
      &lt;row no="1"&gt;
          &lt;FL val="Lead Owner"&gt;me@example.com&lt;/FL&gt;
          &lt;FL val="Company"&gt;&lt;![CDATA[Marks &amp;amp; Spencer]]&gt;&lt;/FL&gt;
      &lt;/row&gt;
  &lt;/Leads&gt;
  </code></pre>
  
  <p>I've even tested by replacing the ampersand by <code>%26</code> as advised on this <a href="https://forums.zoho.com/topic/api-throws-error-when-passing-ampersand-and-via-xml" rel="nofollow">Zoho forum thread</a> but with no luck.</p>
  
  <p>What is the correct format to encode ampersands for Zoho queries?</p>