ZOHO COQL query bug

ZOHO COQL query bug

Hi Zoho team!
I found a bug in your COQL handling.
please have a look at the query I am sending to the COQL endpoints: https://www.zohoapis.com/crm/v2.1/coql OR https://www.zohoapis.com/crm/v4/coql

 "select Potential_Name.Deal_Name,Potential_Name.id  FROM DealHistory WHERE Amount is null OR Amount is not null LIMIT 200 OFFSET 0"

The result is the following:
{
"data": [
        {
            "Potential_Name.Deal_Name": null,
            "Potential_Name.id": "4197230000000241283",
            "id": "4197230000000241294"
        },
        {
            "Potential_Name.Deal_Name": null,
            "Potential_Name.id": "4197230000000241284",
            "id": "4197230000000241297"
        },
......................

],
    "info": {
        "count": 155,
        "more_records": false
    }
}

Now, I will update the query by adding the field `Potential_Name.Amount` to it:
"select Potential_Name.Deal_Name,Potential_Name.id, Potential_Name.Amount  FROM DealHistory WHERE Amount is null OR Amount is not null LIMIT 200 OFFSET 0"
And the result is now the following - please pay attention to how the "Potential_Name.Deal_Name": field in the result changed from being "null", for that the same records:

{
    "data": [
        {
            "Potential_Name.Deal_Name": "Benton",
            "Potential_Name.id": "4197230000000241283",
            "id": "4197230000000241294",
            "Potential_Name.Amount": 1000
        },
        {
            "Potential_Name.Deal_Name": "Chanay",
            "Potential_Name.id": "4197230000000241284",
            "id": "4197230000000241297",
            "Potential_Name.Amount": 2000
        },
        ......................
    ],
    "info": {
        "count": 155,
        "more_records": false
    }
}

Below is the curl command in case you want to test it. I run it against version 2.1 and 4 of the CRM API with the same results.
  1. --header 'Content-Type: application/json' \
    --header 'Authorization: Bearer ..........' \
    --data '{
        "select_query": "select Potential_Name.Deal_Name,Potential_Name.id, Potential_Name.Amount  FROM DealHistory WHERE Amount is null OR Amount is not null LIMIT 200 OFFSET 0"
    }'