Purpose
You can use the getMyRecords method to fetch data by the owner of the ticket specified in the API request.
Request URL
- XML: http://crm.zoho.com/crm/private/xml/Leads/getMyRecords?apikey=yourapikey&ticket=yourticket
- JSON: http://crm.zoho.com/crm/private/json/Leads/getMyRecords?apikey=[API Key]&ticket=[Ticket]
Request Parameters
| Parameter |
Data Type |
Description |
| ticket* |
String |
- |
| apikey* |
String |
- |
| fromIndex |
Integer |
Default value: 1 |
| toIndex |
Integer |
Default value:20
Maximum value:200
|
| sortColumnString |
String |
You can select one of the fields in CRM in to sort the data.
Ex: sortColumnString=Company
Here, sorting of the data will happen based on the Company field
|
| sortOrderString |
String |
Sorting order: asc or desc
If you use the sortColumnString parameter, by default data is sorted in ascending order.
|
| lastModifiedTime |
yyyy-MM-dd HH:mm:ss |
Default: null
If you specify the time, created/modified data will be fetched after the configured time.
|
Examples
1. Fetching Leads Data
http://crm.zoho.com/crm/private/xml/Leads/getMyRecords?apikey=[API Key]&ticket=[Ticket]
For fetching data from other modules, replace Leads with Accounts, Contacts, Potentials, etc
2. Fetching more than 200 records
Maximum of 200 Records will be fetched per batch. If you want to fetch more than 200 records, follow the steps given below:
Iteration 1: fromIndex=1&toIndex=200
Iteration 2: fromIndex=201&toIndex=400
3. Fetching leads with “Company” name in the ascending order
sortColumnString=Company&sortOrderString=sort_asc
4. Fetching leads with “Company” name in the descending order
sortColumnString=Company&sortOrderString=sort_dsc
Additional Notes
- This method retrieves data in all fields of a module irrespective of the user’s field-level security settings in Zoho CRM.
- fromIndex and toIndex are optional parameters. By default the fromIndex is 1 and toIndex is 200.
- sortColumnString and sortOrderString are also optional parameters
- The value for lastModifiedTime parameter should be in yyyy-MM-dd HH:mm:ss format
Other Methods
Existing Methods
New Methods (From Oct 22, 2009):
Related Topics
