Purpose
You can use the getRecords method to fetch all users data specified in the API request.
Request URL
- XML: http://crm.zoho.com/crm/private/xml/Leads/getRecords?apikey=[API Key]&ticket=[Ticket]
- JSON: http://crm.zoho.com/crm/private/json/Leads/getRecords?apikey=[API Key]&ticket=[Ticket]
Request Parameters
| Parameter |
Description |
| ticket |
- |
| apikey |
- |
| fromIndex |
Default value - 1 |
| toIndex |
Default value - 20
Maximum value - 200
|
| sortColumnString |
If you use the sortColumnString parameter, by default data is sorted in ascending order. |
| sortOrderString |
Default value - asc
if you want to sort in descending order, then you have to pass sortOrderString=desc.
|
| lastModifiedTime |
Default: null
If you specify the time, created/modified data will be fetched after the configured time. |
Examples
1. Fetch all accounts in JSON format sorted by Account Name (descending) starting from 20 to 200
http://crm.zoho.com/crm/private/json/Accounts/getRecords?
ticket=xy4gr112345fgg&apikey=sbdjEDBDJ1323&fromIndex=
20&toIndex=200&sortColumnString=Account Name&sortOrderString=sort_desc
2. Fetch all accounts in XML format, which got modified / created after
2008-05-27 00:00:00
http://crm.zoho.com/crm/private/xml/Accounts/getRecords?
ticket=xy4gr112345fgg&apikey=
sbdjEDBDJ1323&lastModifiedTime=2008-05-27 00:00:00
Other Methods
Existing Methods
New Methods (From Oct 22, 2009):
Related Topics
I'm happy to see some updates here - though the 50 API calls per day limit on the new getSearchRecords function is troubling.
Hi, Can you explain what are possible values of sortColumnString and sortOrderString.
What does it mean in eample -> sortOrderString=sort_desc ?
Best regards, m
i tried combinations:
1.
http://crm.zoho.com/crm/private/xml/Events/getRecords?loginName=mmigroup@biznespakiet.pl&apikey=mmigroup.biznespakiet.pl&fromIndex=1&toIndex=200&sortColumnString=Start DateTime&sortOrderString=sort_asc
2.
http://crm.zoho.com/crm/private/xml/Events/getRecords?loginName=mmigroup@biznespakiet.pl&apikey=mmigroup.biznespakiet.pl&fromIndex=1&toIndex=200&sortColumnString=Start DateTime&sortOrderString=sort_desc
Still geting same sorting order :(
Best regards, m
Dear prezentacje,
You have to give "sortOrderString=desc" not "sortOrderString=sort_desc". Sorry for not mentioning it in the help documentation. I have updated it now. Kindly check it and let us know.
Regards,
Mahesh,
(Zoho CRM Team).