Zoho Creator and Zoho CRM API

Zoho Creator and Zoho CRM API

Hello!

I'm trying to get the CRM Sales Orders records (using the CRM API) from Creator, but one of the fields is always empty. "Products" is a multi line field I'm using to see the XML response.

  1. mapvar = getUrl(("https://crm.zoho.com/crm/private/xml/SalesOrders/getRecords?newFormat=2&version=2&authtoken=xxxxxxxxxxxxxxxxxxxxxx&scope=crmapi&selectColumns=SalesOrders(Sales Order ID,Created by,Subject,Created Time,Product Details)"),false);
    stringdata = mapvar.get("responseText");
    input.Products = stringdata;

This is what I get in the "Products" field:
  1. <?xml version="1.0" encoding="UTF-8" ?>
    <response uri="/crm/private/xml/SalesOrders/getRecords"><result><SalesOrders><row no="1"><FL val="SALESORDERID">XXXXXXXXXXXXXX</FL><FL val="Subject"><![CDATA[Sales Order Test]]></FL><FL val="Created Time"><![CDATA[2012-03-21 13:29:04]]></FL><FL val="Product Details"></FL></row><row no="2"><FL val="SALESORDERID">XXXXXXXXXXXXXXXX</FL><FL val="Subject"><![CDATA[Sales Order Test 2]]></FL><FL val="Created Time"><![CDATA[2012-03-21 09:27:48]]></FL><FL val="Product Details"></FL></row></SalesOrders></result></response>
I also tried to use the CRM Webhooks and the Creator API, but again the Product Details field is always empty and all the other fields work properly.

How can I get the product details in a Sales Order (and also a Purchase Order) using the CRM API?

Thanks