COQL API

{     "select_query":"select External from Contacts where id is not null" }

Answer: 

The error occurs because the query uses an SQL reserved keyword, "External", as a column name without enclosing it in quotes. When using SQL reserved keywords like "External", you must enclose them in single or double quotes.

The above-query can be written as:

{     "select_query":"select 'External' from Contacts where id is not null" }

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

2. Why does the following query throw an error?

{     "select_query":"select id from Contacts where id is not null and Account_Name is not null and Vendor_Name is not null" }

Answer: 

When the query involves more than two criteria, ensure that you enclose your criteria properly by grouping them in pairs, such as ((A and B) and C).

The above-query can be written as:

{     "select_query": "select id from Contacts where ((id is not null and Account_Name is not null) and Vendor_Name is not null)" }

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

3. How to escape single quotes within single quotes and double quotes within double quotes?

Answer: 

For single quote:

If you want to retrieve a value that contains a single quote, for example, 1' 2 in the Designation field (a single-line field), you need to escape the single quote in the value by adding another single quote.

Example:

1'' 2

Sample Input and Response:

• Below V7: You must query the first_name and last_name fields separately and concatenate them to form the Full Name.
• From V7: You can directly query the full_name field in the SELECT column, and it will return data based on the User Preference.

• Multi-select lookup fields: These cannot be queried directly from the parent module. Instead, query them from their respective linking modules.
• Line items: Pricing_Details and Product_Details
• Pricing_Details: This field cannot be queried as it is not a subform but a separate section.
• Product_Details: This is a subform. You cannot query data from the parent module. Instead, query it directly from the respective subform module.
• Participants in the Events module.
• File/Image upload fields
• Availability Information fields in the Services module
• Choose Date(s)
• Choose Day(s)

• Multiline fields: Cannot be used in criteria.
• Encrypted numeric fields: Support limited comparators (is null, is not null, =, != ).
• Encrypted non-numeric fields: Support only is null and is not null comparators.