Fetch Record API
This API is used to fetch all the records of a form based on view name as well as you can get records based on predefined columns.
Request URL
https://people.zoho.com/people/api/forms/<viewname>/records?sIndex=<sIndex>&rec_limit=<rec_limit>
Header:
Authorization: Zoho-oauthtoken 1000.8cb99dxxxxxxxx9be93.9b8xxxxxxf
Scope:
ZOHOPEOPLE.forms.ALL
or
ZOHOPEOPLE.forms.READ
Possible Operation Types:
ALL - Full access to data
READ- Read form data
Request Parameters
| viewName | To get the view name use Views API |
| sIndex | Starting Index |
| rec_limit | Number of records to be fetched |
| SearchColumn | Search EMPLOYEEID or EMPLOYEEMAILALIAS |
| SearchValue | Search Employeeid of the employee or the Employee MailID |
| modifiedtime | To fetch records added & modified after the given time . value should be timestamp in milliseconds |
Sample Request
Copiedhttps://people.zoho.com/people/api/forms/P_EmployeeView/records?Request 2 - For searching records of a particular employee
Copiedhttps://people.zoho.com/people/api/forms/P_EmployeeView/records?searchColumn=EMPLOYEEMAILALIAS&searchValue=charless@zykler.comHeader
CopiedAuthorization: Zoho-oauthtoken 1000.8cb99dxxxxxxxx9be93.9b8xxxxxxfSample Response
Copied[
{
"recordId": 173907000000181100,
"Date of joining": "",
"Employee Role": "Team member",
"Work phone": "",
"AbouMe": "",
"EmployeeID": "123",
"Extension": "",
"Nick Name": "",
"ID Proof": "",
"Department": "",
"Work location": "",
"createdTime": 1351588396243,
"modifiedTime": 1351588396243,
"Job Description": "",
"Employee Type": "",
"Mobile Phone": "",
"Photo": "",
"Title": "",
"Marital Status": "",
"Tags": "",
"Source of Hire": "",
"Offer Letter": "",
"Birth Date": "",
"Address": "",
"Reporting To": "",
"Ask me about/Expertise": "",
"Employee Status": "Active",
"Other Email": "",
"Email ID": "",
"Last Name": "",
"First Name": "dummy123"
},
{
"recordId": 173907000000111000,
"Date of joining": "19-Nov-2016",
"Employee Role": "Team member",
"Work phone": "",
"AbouMe": "",
"EmployeeID": "HRM3",
"Extension": "",
"Nick Name": "",
"ID Proof": "",
"Department": "",
"Work location": "",
"createdTime": 1351588396243,
"modifiedTime": 1351588396243,
"Job Description": "",
"Employee Type": "",
"Mobile Phone": "",
"Photo": "",
"Title": "",
"Marital Status": "",
"Tags": "",
"Source of Hire": "",
"Offer Letter": "",
"Birth Date": "",
"Address": "",
"Reporting To": "",
"Ask me about/Expertise": "",
"Employee Status": "Active",
"Other Email": "",
"Email ID": "",
"Last Name": "",
"First Name": "dummy456"
}
]Copied<Records>
<Record>
<field name="recordId">173907000000228001</field>
<field name="Photo"><img class="ptB10" src="/people/images/user.png"></field>
<field name="EmployeeID">335</field>
<field name="Reporting To"></field>
<field name="First Name">non</field>
<field name="Last Name">user</field>
<field name="Email ID"></field>
<field name="Nick Name"></field>
<field name="Department"></field>
<field name="Title"></field>
<field name="Employee Role">Team member</field>
<field name="Date of joining">19-Nov-2016</field>
<field name="Work location"></field>
<field name="Work phone"></field>
<field name="Extension"></field>
<field name="Other Email"></field>
<field name="Birth Date"></field>
<field name="Mobile Phone"></field>
<field name="Address"></field>
<field name="Tags"></field>
<field name="Job Description"></field>
<field name="Ask me about/Expertise"></field>
<field name="AbouMe"></field>
<field name="Employee Type"></field>
<field name="Employee Status">Active</field>
<field name="Source of Hire"></field>
<field name="Marital Status"></field>
<field name="Offer Letter"></field>
<field name="ID Proof"></field>
</Record>
</Records>