Get Records
Table of Contents
Overview
This task is used to fetch records from an application in Zoho Creator.
Syntax
<variable> = zoho.creator.v1.getRecords(<ownerName>, <appLinkName>, <viewLinkName>, <condition>, <fromIndex>, <toIndex>, <connectionlinkName>);
where,
| Parameter | Data Type | Description |
<variable> | LIST | Variable which will hold the returned response. |
<ownerName> | TEXT | is the name of the owner of the app from the records will be fetched. Name of the app owner is present in the url while editing the app: creator.zoho.com/appbuilder/<appOwner> App owner name can also be fetched using the system variable zoho.adminuser |
<appLinkName> | TEXT | is the link name of the application from which the records will be fetched. Link names of applications, reports, and fields in your account can be viewed here (listed in brackets). Application Link name can also be fetched using the system variable zoho.appname |
<viewLinkName> | TEXT | is the link name of the view (report) from which the records will be fetched. Link names of applications, reports, and fields in your account can be viewed here (listed in brackets). |
<condition> (optional) | TEXT | is the condition based on which records will be fetched. The condition must be in the following format: Lookup fields must be specified in the format <LookupFieldLinkName>.<displayFieldLinkName> Note: If your search condition contains hard-coded string value, it needs to be enclosed in double quotes escaped with backslashes. For example, the search condition, "Task_Name==Service Task" should be provided as "Task_Name==\"Service Task\"". |
<fromIndex> <toIndex> (optional) | NUMBER | <fromIndex> is the starting index of the records (which meet the criteria) that will be retrieved. |
<connectionLinkName> (optional)* | TEXT | is the name of the Zoho Creator connection. *Note
|
Example 1
Let us consider the below example of searching for a record using a condition in Zoho Creator. The record whose task name is ServiceTask is being fetched here.
Assume that we have a form with the two fields - Task_Name (Single Line Field Type) and Task_Description (Single Line Field Type). The arguments - Task_Management (Application Link Name), Create_Task (View Link Name), john (Owner Name) will be supplied to getRecords task in the following example.
response = zoho.creator.v1.getRecords("john","Task_Management","Create_Task","Task_Name == \"ServiceTask\"");
where,
responsejohnTask_ManagementCreate_TaskTask_Name == ServiceTaskExample 2
Let us consider the below example of searching for records without a condition or the start and end indices in Zoho Creator.
response = zoho.creator.v1.getRecords("SampleApps","Task_Management","Create_Task");
Example 3
Let us consider the below example of searching for a record using a condition in Zoho Creator.
Assume that we have a form with a lookup field - Department (Lookup Field Type) which refers to the Name (single line field type) field in the related form called "Department". The arguments - Employee_Management (Application Link Name), Employees (View Link Name), tony (Owner Name) will be supplied to getRecords task in the following example.
response = zoho.creator.v1.getRecords("tony","Employee_Management","Employees","Department.Name == \"Electrical\"");
where,
responsetonyEmployee_ManagementEmployeesDepartment.Name == ElectricalSample Response
Success Response for Example 1
Following is a successful response received after fetching a record
"Task_Description":"I need help installing my air conditioner",
"ID":3605445000000075003,
"Task_Name":"ServiceTask"
}
Success Response for Example 2
Following is a successful response received on fetching records without a condition/index
{"Task_Name":"Support Ticket1","Task_Description":"Toaster Configurations","ID":"3605445000000065010"},
{"Task_Name":"Support Ticket2","Task_Description":"Help me fix it","ID":"3605445000000065003"},
{"Task_Name":"Support Task1","Task_Description":"I need a call back","ID":"3605445000000063122"},
{"Task_Name":"Support Task1","Task_Description":"My new box broke","ID":"3605445000000063115"},
{"Task_Name":"Task1","Task_Description":"I need a technician visit my place","ID":"3605445000000058048"},
{"Task_Name":"Task2","Task_Description":"The water ain't flowing through the hose","ID":"3605445000000058043"},
{"Task_Name":"Tasks1","Task_Description":"Please get my iron box fixed ASAP","ID":"3605445000000058036"}
To get the IDs of the fetched records, execute the following snippet:
{
info var.get("ID");
}
Error
Following is an error when the user tries to search for a record with an incorrect application name:
"message":"Please verify whether you gave a valid ownerName,appLinkName and viewLinkName or not",
"status":"Failure"
}
Following is an error when the user tries to search for a record with a non-existent or incorrect record ID:
"message":"There is no records match for this condition"
}
Related Links
- To fetch the string value to which the specified key is mapped, use get()
- To get values from fetched records, use getJSON()
- To get the Application Owner Name, Application Link Name, Form Link Name and/ or View Link Name, please visit Creator API Link Names