Creator Help

Search Records in Zoho Recruit

 Overview

The zoho.recruit.searchRecords() task can be executed to search and retrieve existing records, based on a specified criteria, from any of the supported modules of Zoho Recruit. By placing it in the required form actions block of Zoho Creator, the process of searching and retrieving records from Zoho Recruit can easily be automated as per requirement. Lets say you have a Zoho Creator form where you need to retrieve records from Zoho Recruit, based on a search condition, for further action such as iterating them. You can execute zoho.recruit.searchRecords() task in the required form actions block which will return the response containing the searched records in a map format. Further details on how to execute this task are explained below.

 Supported Modules

  • Candidates
  • Job Openings
  • Clients
  • Client Contacts

 Syntax

response = zoho.recruit.searchRecords(moduleName, searchCondition, fromIndex, toIndex, selectColumns)

where,
<response> - is the map variable returned by Zoho Recruit as response. 
<moduleName> - name of module in Zoho Recruit from where the records will be fetched. (mandatory)
<searchCondition> must be in the following format: (<colName> |<operator>|<colValue>). You can specify the following expressions in the criteria : (mandatory)

  • is OR =
  • isn't OR <>
  • contains(*srcString*)
  • starts with(srcString*)
  • ends with(*srcString)
  • doesn't contain
  • < OR is before
  • > OR is after
  • <=
  • =>

<fromIndex> - is the starting index of the records that need to be retrieved.
<toIndex> - is the last index of the records that need to be retrieved.

 Example

Following is a sample script that can be added in a Zoho Creator form to search and retrieve existing records from Zoho Recruit. Let's say we have a Creator form where we need to fetch records from Zoho Recruit, based on a search condition, to perform an iteration. You can add the following script in required form actions block of the Creator Form so that whenever this form is loaded, edited or submitted etc, records existing in Zoho Recruit's specified module are searched and retrieved accordingly. In this case, the module is "Candidates". When the following script gets executed, records from Zoho Recruit are searched and fetched as specified by the search condition.

response = zoho.recruit.searchRecords("Candidates", "(Industry|=|Chemicals)", "2", "5");

where,
response - is the map variable returned by Zoho Recruit as response. 
Candidates - name of module in Zoho Recruit where the records will be searched and retrieved from.
(Industry|=|Chemicals) is the criteria based on which the records are searched in Zoho recruit.
2 is the starting index of the records that are going to be fetched.
5 is the last index of the records that are going to be fetched.

 Response

Response returned by Zoho Recruit as map:

{"Is Locked":"false","Candidate ID":"ZR_23_CAND","CANDIDATEID":"1687000000102009","Is Unqualified":"false","Updated On":"2015-08-05 18:41:34","Created By":"deepika.p","Is Attachment Present":"true","Source":"Resume","MODIFIEDBY":"1687000000077003","Created Time":"2015-08-05 18:41:34","Modified By":"deepika.p","SMOWNERID":"1687000000077003","Candidate Status":"New","Last Activity Time":"2015-08-05 18:41:34","SMCREATORID":"1687000000077003","Email Opt Out":"false","Is Hot Candidate":"false","Last Name":"No name","Experience in Years":"0","Candidate Owner":"deepika.p"},{"Is Locked":"false","Candidate ID":"ZR_24_CAND","CANDIDATEID":"1687000000102031","Is Unqualified":"false","Updated On":"2015-08-05 18:47:53","Created By":"deepika.p","Is Attachment Present":"true","Source":"Resume","MODIFIEDBY":"1687000000077003","Created Time":"2015-08-05 18:47:53","Modified By":"deepika.p","SMOWNERID":"1687000000077003","Candidate Status":"New","Last Activity Time":"2015-08-05 18:47:53","SMCREATORID":"1687000000077003","Email Opt Out":"false","Is Hot Candidate":"false","Last Name":"No name","Experience in Years":"0","Candidate Owner":"deepika.p"},{"Is Locked":"false","Candidate ID":"ZR_25_CAND","CANDIDATEID":"1687000000102053","Is Unqualified":"false","Updated On":"2015-08-05 18:49:51","Created By":"deepika.p","Is Attachment Present":"true","Source":"Resume","MODIFIEDBY":"1687000000077003","Created Time":"2015-08-05 18:49:51","Modified By":"deepika.p","SMOWNERID":"1687000000077003","Candidate Status":"New","Last Activity Time":"2015-08-05 18:49:51","SMCREATORID":"1687000000077003","Email Opt Out":"false","Is Hot Candidate":"false","Last Name":"No name","Experience in Years":"0","Candidate Owner":"john"}

Share this post : FacebookTwitter

Still can't find what you're looking for?

Write to us: support@zohocreator.com