Kaizen #10 - Search Records API and Query API
Hello everyone! Welcome back to this week's Kaizen post! In this post, we will discuss the Query API and the Search Records API, and when you should use them. Query API The Query API allows you to query the records using the CRM Object Query Language(COQL). COQL is based on the SQL syntax and uses the SELECT statement in the query to fetch records. When should you use the Query API? When you want to use DB comparators such as =, >, <, >=, <=, is null, is not null, between, not in, like, and not like