If I exclude the URL the record insert works fine. But if I incude it fails.
I have tried wrapping with CDATA and it still fails. I get an error code 4600.
<row no='1'>
<FL val='Lead Source'>SolarQuotes.com.au</FL>
<FL val='Lead Status'>New</FL>
<FL val='Lead Type'>Residential Solar</FL>
<FL val='Industry'>Consumer</FL>
<FL val='Rating'>New</FL>
<FL val='Submitted Time'>26/01/2012</FL>
<FL val='First Name'>FirstNameTest</FL>
<FL val='Last Name'>LastNameTest</FL>
<FL val='Company'></FL>
<FL val='Phone'>0732459175</FL>
<FL val='Street'>41 Gordon Parade</FL>
<FL val='City'>East Gravatt Mount</FL>
<FL val='Province'>QLD</FL>
<FL val='Postal Code'>4122</FL>
<FL val='Country'>Australia</FL>
<FL val='Timeframe for Purchase'>In the next 6 months</FL>
<FL val='Available for conversation'>day time</FL>
<FL val='Asked for home visit'>No</FL>
<FL val='Do you own the roof space'>Yes</FL>
<FL val='Roof Type'>Other</FL>
<FL val='Other Roof Type'>concrete tiles</FL>
<FL val='Is there at least 10 square metres of North-facing'>No</FL>
<FL val='Roof Slope'>I'm not sure</FL>
<FL val='How Shaded is North Facing Roof'>I'm not sure</FL>
<FL val='Roof Direction'>null</FL>
<FL val='Other Information about Install Site'>SolarHart Hot water already installed. This will not be relocated. Small roof spaces to front of house.,null</FL>
<FL val='Size Of System'>1.5kW</FL>
<FL val='External Lead Reference'>103275</FL>
<FL val='Interested in Finance/Payment Plan'>true</FL>
</row>
</Leads>