How to extract Email of the Primary Contact from the XML returned by ZOHO CRM API?
I am having trouble generating the XPATH expression to extract the primary contact's email address. (Primary contact of a Zoho CRM Account).
But none seem to work in Zoho Creator.
HERE IS THE TRIMMED XML I GET FROM THE CRM API CALL FROM WHICH I WANT TO EXTRACT THE EMAIL ADDRESS OF THE PRIMARY CONTACT. ANY ONE OUT THERE WHO HAS TRIED IT BEFORE OR WANTS TO GIVE IT A SHOT?
<!--?xml version="1.0" encoding="UTF-8" ?-->
<response uri="/crm/private/xml/Contacts/getRelatedRecords">
<result>
<contacts>
<row no="1">
<fl val="CONTACTID">511618000000889989</fl>
<fl val="Email">
</fl>
<fl val="Primary">
<!--[CDATA[true]]-->
</fl>
</row>
<row no="2">
<fl val="CONTACTID">511617845475451213</fl>
<fl val="Email">
</fl>
<fl val="Primary">
<!--[CDATA[false]]-->
</fl>
</row>
</contacts>
</result>
</response>
<!--?xml version="1.0" encoding="UTF-8" ?--> <response uri="/crm/private/xml/Contacts/getRelatedRecords"> <result> <contacts> <row no="1"> <fl val="CONTACTID">511618000000889989</fl> <fl val="Email"> <!--[CDATA[person1@example.com]]--> </fl> <fl val="Primary"> <!--[CDATA[true]]--> </fl> </row> <row no="2"> <fl val="CONTACTID">511617845475451213</fl> <fl val="Email"> <!--[CDATA[person2@example.com]]--> </fl> <fl val="Primary"> <!--[CDATA[false]]--> </fl> </row> </contacts> </result> </response>
Thanks in advance for looking at this problem.
Regards
Moiz Tankiwala
Smart Training & IT Solutions