API problems.. (1) getSearchRecordsByPDC: search for custom field.. (2) updateRecords: multiple records.. please help... thanks

API problems.. (1) getSearchRecordsByPDC: search for custom field.. (2) updateRecords: multiple records.. please help... thanks

Put these in one post... hope thats okay...first problem: We have a custom field "Site ID"... we wanted to use this field to retrieve the value of the Zoho "Lead ID" but we keep getting this message:

<error>
<code> 4420 </code>
<message> Invalid Search Column.Check it now </message>

Here is the relevant code:

$selectColumns="leads(LEADID)";
$searchColumn="Site%20ID";
$searchValue="24090";
$param="authtoken=".$token."&scope=crmapi"."&selectColumns=".$selectColumns."&searchColumn=".$searchColumn;
$param .= "&searchValue=".$searchValue;

We have tried many different ways of referring to "Site ID" but nothing works... any ideas?

------------------------------------------------------------------------------------

Second issue... we are trying to update multiple rows using row number.. here is the error:

<error>
<code> 4425 </code>
<details>
Unable to process your request. Please check whether you have given the valid record Id

Here is the XML Data:

<Leads>
<row no="1">
<FL val="Refer ID">22</FL>
</row>
<row no="2">
<FL val="Refer ID">22</FL>
</row>
<row no="3">
<FL val="Refer ID">22</FL>
</row>
</Leads>

Here is the code:

$param= "authtoken=".$token."&version=4&scope=crmapi&xmlData=".$xmldata;

I was thinking that maybe we have to include the lead ID or company name in the XML data to use this API method to update multiple records?  Any ideas?

Thank you for any help that you might offer....