Creator Help

Get Records

Table of ContentsDown

Get Records

You can fetch related records from Zoho Support modules in Zoho Creator form using the getRecords() task.

Syntax

<response> = zoho.support.getRecords(<moduleName>, <portal>, <department>, <fromIndex>, <toindex>);

where,
<response>is the map variable returned as response.
<moduleName>is the name of the Support Module from where the record needs to be fetched. For example, "Requests" refers to the Requests module. The Support modules that are supported by Creator are "Requests", "Accounts", "Contacts" and "Contracts".
<portal>is the name of the Support Portal and <department> refers to the department in the portal from where the records need to be fetched. 
<fromIndex>(optional)- Default value - 1
<toIndex> (optional) Default Value- 20 

Note:

  • All the parameters listed above are mandatory, except the From Index and the To Index. If the parameters, From Index and the To Index are not used or only any one of them is used, in either case, only 20 records will be fetched by default. A maximum of 200 records can be fetched at once by using the From Index and To Index parameters. 

Example

response = zoho.support.getRecords("Requests", "zohotest", "database");          // fetches all the records
response = zoho.support.getRecords("Requests", "zohotest", "database", 3, 8);  // fetches all the records between indexes 3 and 8

where,
response is the map variable returned as reponse.
Requests is the name of the Support Module from where the records need to be fetched.
zohotest is the name of the Support Portal and database refers to the department in the portal where the records need to be fetched.
The numbers 3 and 8 denote the From index and the To index.

Top