Search Leads by Criteria
Returns leads based on criteria you define. For example, you can search for all leads that are created after a certain date or all leads where age > 22.
Note:
- If Object Types are enabled on your account, the field (
LeadType) value is set to OT_0 by default. - You can change the
LeadTypefrom the default value (OT_0) to a custom value (OT_1, OT_2, and so on) only once. After you change it, you cannot update it again.
API URL
Request
Content-Type: application/json{
"Parameter":{
"LookupName":"CreatedOn",
"LookupValue":"2025-01-01 14:36:59",
"SqlOperator":">"
},
"Columns":{
"Include_CSV":"ProspectID, FirstName, LastName, EmailAddress"
},
"Sorting":{
"ColumnName":"FirstName",
"Direction":"1"
},
"Paging":{
"PageIndex":1,
"PageSize":100
},
"Attribute":"LeadType",
"Value":"OT_0"
}
Request Parameters
| Parameter | Description |
|---|---|
| LookupName | Schema name of the lead field. For example, if you want to find all leads based on last name, then pass “LookupName”: “LastName”. To get the schema names for all lead fields use the LeadsMetaData API. |
| LookupValue | This is the search term. For example, if you want all leads who’s last name is Smith then pass “LookupValue”: “Smith”. |
| SqlOperator | Operator: One of =, LIKE, >, <, <=, >=, <> For an exact match pass “SqlOperator”:”=” |
| Include_CSV | Lead fields that should be included in the result. Use the schema names of lead fields. |
| ColumnName | The column on which results will be sorted. For example, if you want results to be shown based on creation date, pass “CreatedOn”. |
| Direction | Direction “1” means descending order and “0” means ascending order. |
| PageIndex | The results matching your criteria may be large. You can fetch the result in blocks of “PageSize” and make multiple calls to the API with increasing values of “PageIndex”. For example, you can specify “PageIndex”: 1, “PageSize”: 100 for the first call and specify “PageIndex”: 2, “PageSize”: 100 for second call. |
| PageSize | The results matching your criteria may be large. You can fetch the result in blocks of “PageSize” and make multiple calls to the API with increasing values of “PageIndex”. For example, you can specify “PageIndex”: 1, “PageSize”: 100 for the first call and specify “PageIndex”: 2, “PageSize”: 100 for second call. The maximum page size supported is 1,000. |
| LeadType | If Object Types are enabled on your account, the LeadType value is OT_0 by default, and you can change it to a custom value (OT_1, OT_2, and so on) only once, after which you cannot update it again. This is optional. |
Response
[
{
"ProspectID":"5492ac10-3fc9-4114-8d07-04a5e8917b3e",
"FirstName":"Wim",
"LastName":"Wenders",
"EmailAddress":"wim.wenders@example.com",
"ProspectAutoId":"1043",
"OwnerId":"d8932cc2-0731-11f1-ad41-02975fe78883",
"CreatedOn":"2026-02-12 09:18:02.000"
},
{
"ProspectID":"234bb253-7a5d-4513-8a5c-2ab6d83d8eea",
"FirstName":"Sarah Adams",
"LastName":null,
"EmailAddress":"sarahadams@example.com",
"ProspectAutoId":"1025",
"OwnerId":"7511e6c2-9df5-11f0-91df-068012126923",
"CreatedOn":"2025-11-04 09:31:23.000"
},
{
"ProspectID":"9726b73c-6cb4-4681-966b-223155baab0f",
"FirstName":"Pramila",
"LastName":"Marthur",
"EmailAddress":null,
"ProspectAutoId":"1038",
"OwnerId":"655fac78-fce3-11f0-ad41-02975fe78883",
"CreatedOn":"2026-01-29 08:31:42.000"
},
{
"ProspectID":"bd595fc2-3678-4004-9ac6-65bfd1caadb5",
"FirstName":"Nivas",
"LastName":"Ravi",
"EmailAddress":"nivas@leadsquard.com",
"ProspectAutoId":"1024",
"OwnerId":"7511e6c2-9df5-11f0-91df-068012126923",
"CreatedOn":"2025-11-04 09:07:42.000"
},
{
"ProspectID":"e65eac7f-b312-11f0-91df-068012126923",
"FirstName":"John",
"LastName":"Smith",
"EmailAddress":"john.smith@acmecorp.com",
"ProspectAutoId":"1021",
"OwnerId":"0d31d53e-5b8d-11f0-91df-068012126923",
"CreatedOn":"2025-10-27 08:58:19.000"
},
{
"ProspectID":"2d689df7-8e95-4b37-b1cd-65732324045d",
"FirstName":"Cyril",
"LastName":"Adams",
"EmailAddress":"cyriladams@example.com",
"ProspectAutoId":"1026",
"OwnerId":"7511e6c2-9df5-11f0-91df-068012126923",
"CreatedOn":"2025-11-04 09:32:01.000"
},
{
"ProspectID":"b6520cb4-d0ff-41ef-94bc-1442cc6e0cda",
"FirstName":"Credit card",
"LastName":null,
"EmailAddress":"credit@gmail.com",
"ProspectAutoId":"1036",
"OwnerId":"655fac78-fce3-11f0-ad41-02975fe78883",
"CreatedOn":"2026-01-29 07:48:28.000"
},
{
"ProspectID":"a9d584b9-3a5f-4506-8575-c35f30a8cca9",
"FirstName":"Chris",
"LastName":"Jacob",
"EmailAddress":"chrisjake@example.com",
"ProspectAutoId":"1027",
"OwnerId":"7511e6c2-9df5-11f0-91df-068012126923",
"CreatedOn":"2025-11-04 09:41:11.000"
},
{
"ProspectID":"54040183-0401-4cb9-a99d-6946b071d4e5",
"FirstName":"Binavi",
"LastName":"S",
"EmailAddress":"binav@gmail.com",
"ProspectAutoId":"1008",
"OwnerId":"0d31d53e-5b8d-11f0-91df-068012126923",
"CreatedOn":"2025-10-03 09:32:51.000"
},
{
"ProspectID":"b0a5f1ab-7546-4264-8af7-f69dea2992a3",
"FirstName":"Ann Jacob",
"LastName":null,
"EmailAddress":"ann.jacob@example.com",
"ProspectAutoId":"1028",
"OwnerId":"7511e6c2-9df5-11f0-91df-068012126923",
"CreatedOn":"2025-11-04 09:41:35.000"
},
{
"ProspectID":"76b00e68-b314-11f0-91df-068012126923",
"FirstName":"Aishwarya",
"LastName":"Lsq",
"EmailAddress":"aishwarya.lsq@acmecorp.com",
"ProspectAutoId":"1022",
"OwnerId":"0d31d53e-5b8d-11f0-91df-068012126923",
"CreatedOn":"2025-10-27 09:09:05.000"
},
{
"ProspectID":"3998973f-e33f-4df6-9af6-ae2830485f83",
"FirstName":null,
"LastName":null,
"EmailAddress":"rhythmj45@gmail0.com",
"ProspectAutoId":"1002",
"OwnerId":"e0b37c54-5b1c-11f0-a986-06c72fc46c23",
"CreatedOn":"2025-07-07 23:46:12.000"
},
{
"ProspectID":"e6b5a9f1-d402-43a7-846f-7fc4fd3a199f",
"FirstName":null,
"LastName":null,
"EmailAddress":"v2v@gmail.com",
"ProspectAutoId":"1004",
"OwnerId":"e0b37c54-5b1c-11f0-a986-06c72fc46c23",
"CreatedOn":"2025-09-15 23:35:40.000"
},
{
"ProspectID":"7fa1a085-9040-4552-9452-954fac0c805d",
"FirstName":null,
"LastName":null,
"EmailAddress":"bpappu@gmail.com",
"ProspectAutoId":"1005",
"OwnerId":"0d31d53e-5b8d-11f0-91df-068012126923",
"CreatedOn":"2025-09-15 23:37:32.000"
},
{
"ProspectID":"93d30f0d-0d10-4116-a27e-b5c1f64c8601",
"FirstName":null,
"LastName":null,
"EmailAddress":"g2func@gmail.com",
"ProspectAutoId":"1003",
"OwnerId":"e0b37c54-5b1c-11f0-a986-06c72fc46c23",
"CreatedOn":"2025-07-07 23:54:34.000"
},
{
"ProspectID":"a3216312-ff71-46c8-92b6-4d45a656a032",
"FirstName":null,
"LastName":null,
"EmailAddress":"bhaludivad@gmail.com",
"ProspectAutoId":"1007",
"OwnerId":"0d31d53e-5b8d-11f0-91df-068012126923",
"CreatedOn":"2025-09-15 23:40:03.000"
},
{
"ProspectID":"d4a4df3a-bc89-417c-80c5-a327903deae1",
"FirstName":null,
"LastName":null,
"EmailAddress":"lb2c@gmail.com",
"ProspectAutoId":"1006",
"OwnerId":"0d31d53e-5b8d-11f0-91df-068012126923",
"CreatedOn":"2025-09-15 23:38:11.000"
},
{
"ProspectID":"3f0c857e-e718-4c31-a109-af97849654eb",
"FirstName":null,
"LastName":null,
"EmailAddress":"rhythmj45@gmail.com",
"ProspectAutoId":"1001",
"OwnerId":"e0b37c54-5b1c-11f0-a986-06c72fc46c23",
"CreatedOn":"2025-07-07 17:52:42.000"
},
{
"ProspectID":"b5a4413a-fd4b-464f-9db6-36b20abb8b3e",
"FirstName":null,
"LastName":null,
"EmailAddress":"sarahadams@gmail.com",
"ProspectAutoId":"1034",
"OwnerId":"7511e6c2-9df5-11f0-91df-068012126923",
"CreatedOn":"2025-12-02 10:37:06.000"
},
{
"ProspectID":"95e9618d-e20b-44d0-bb3f-2dbbf268d2fb",
"FirstName":null,
"LastName":null,
"EmailAddress":"sia@gmail.com",
"ProspectAutoId":"1041",
"OwnerId":"655fac78-fce3-11f0-ad41-02975fe78883",
"CreatedOn":"2026-01-29 08:51:07.000"
},
{
"ProspectID":"ce7d56da-7864-495e-9c09-3da7e034aac4",
"FirstName":null,
"LastName":null,
"EmailAddress":"Kalpana@gmail.com",
"ProspectAutoId":"1042",
"OwnerId":"655fac78-fce3-11f0-ad41-02975fe78883",
"CreatedOn":"2026-01-29 08:51:16.000"
}
]
HTTP Response Codes
| Code | Description |
|---|---|
| 200 OK | This is the status code for successful API call. |
| 401 Unauthorized | The API call was made with invalid access credentials. Check your AccessKey and SecretKey. |
| 400 Bad Request | The message body on the request is not as per API specification. Make sure that content type is set to “application/json” and the JSON body has correct attribute names and structure. |
| 404 Not Found | The API could not be found. Please check the API signature. |
| 429 Too Many Requests | API calls exceeded the limit of 25 in 5 second(s) |
| 500 Internal Server Error | The API called failed. There could be many reasons for it. Check the exception message to get more details. |

