COQL selecting a column with space, how i can do it?

COQL selecting a column with space, how i can do it?

Hi Zoho Team

     I got a problem, when i was programming a Zoho deluge but  my query need to use a column name with space, please see the code:

  2. queryMap = Map();
  3. queryMap.put("select_query", "select Last_Name, First_Name, Full_Name from Leads where id ="+id+" and 'Form 2' like '%SOMETHING%' ");
  4. response = invokeurl
  5. [
  6. url :"https://www.zohoapis.com/crm/v3/coql"
  7. type :POST
  8. parameters: queryMap.toString()
  9. connection:"coql"
  10. ];
  11. info response;

As you can see, i need to query Form 2 (with space, it's a calculate column inside Leads table), but when i try to run, i got the following error:

  • {"code":"INVALID_QUERY","details":{"column_name":"Form 2"},"message":"column given seems to be invalid","status":"error"}
So, what's the wrong?, i need to declare the column name  using double quote, single quote or other magic way?

Thanks in advance
Pablo