Question: Error while calling Search leads by criteria API based Lead Age
WorkAround/Solution:
Since Lead Age field is internal/system field and cannot be used in searchable option.
Please run this API to know which all fields can be used as Searchable parameter: http://apidocs.leadsquared.com/meta-data/.
When you run the above API you will receive all the field properties in JSON format and the fields which are mentioned as {“IsSearchable”: true} can be used in search.
But however, as you are searching for the Lead Age field(Lead days) same data can be searchable with the help of “Created On” field.
Sample JSON:
{
“Parameter”: {
“LookupName”: “CreatedOn”,
“LookupValue”: “2015-01-01 14:36:59”,
“SqlOperator”: “>”
},
“Columns”: {
“Include_CSV”: “ProspectID, FirstName, LastName, EmailAddress”
},
“Sorting”: {
“ColumnName”: “CreatedOn”,
“Direction”: “1”
},
“Paging”: {
“PageIndex”: 1,
“PageSize”: 100
}
}
