Missing Opportunity Fields in Advanced Search API Response

2 min read

CX is using the Opportunity List by Advanced Search API to pull data from LSQ. While the API is working as expected for most standard fields, CX is unable to retrieve several custom fields associated with the Opportunity object.

API details:

‘https://api-in21.leadsquared.com/v2/OpportunityManagement.svc/Retrieve/BySearchParameter?accessKey=u%24rdba6d6209c178301c593e3c5ab7ea309&secretKey=f1a52ee381badfb4d8608dfc62dc9e4700202b11′

–header ‘Content-Type: application/json’

–data ‘

{

“OpportunityEventCode”: 12000,

“AdvancedSearch”: “{“GrpConOp”:”And”,”Conditions”:[{“Type”:”Activity”,”ConOp”:”and”,”RowCondition”:[{“SubConOp”:”And”,”LSO”:”ActivityEvent”,”LSO_Type”:”PAEvent”,”Operator”:”eq”,”RSO”:”12000″},{“SubConOp”:”And”,”LSO”:”ModifiedOn”,”LSO_Type”:”DateTime”,”Operator”:”between”,”RSO”:”2025-08-04+16:00:00+TO+2025-08-04+17:00:00″}],”IsFilterCondition”:true},{“Type”:”Lead”,”ConOp”:”and”,”RowCondition”:[{“SubConOp”:”And”,”LSO”:”LeadType”,”LSO_Type”:”string”,”Operator”:”eq”,”RSO”:”OT_0″}]}],”QueryTimeZone”:”India+Standard+Time”}”,

“Paging”: {

“PageIndex”: 2,

“PageSize”: 20

“Sorting”: {

“ColumnName”: “CreatedOn”,

“Direction”: 1

}

}’

Solution: To retrieve custom fields in the API Try passing the following in the payload with the custom field values you wish to retrieve

“Columns”: {

“Include_CSV”: “ProspectID, FirstName, LastName, EmailAddress”

}

API details:

‘https://api-in21.leadsquared.com/v2/OpportunityManagement.svc/Retrieve/BySearchParameter?accessKey=u%24rdba6d6209c178301c593e3c5ab7ea309&secretKey=f1a52ee381badfb4d8608dfc62dc9e4700202b11′ \

–header ‘Content-Type: application/json’ \

–data ‘

{

“OpportunityEventCode”: 12000,

“AdvancedSearch”: “{\”GrpConOp\”:\”And\”,\”Conditions\”:[{\”Type\”:\”Activity\”,\”ConOp\”:\”and\”,\”RowCondition\”:[{\”SubConOp\”:\”And\”,\”LSO\”:\”ActivityEvent\”,\”LSO_Type\”:\”PAEvent\”,\”Operator\”:\”eq\”,\”RSO\”:\”12000\”},{\”SubConOp\”:\”And\”,\”LSO\”:\”ModifiedOn\”,\”LSO_Type\”:\”DateTime\”,\”Operator\”:\”between\”,\”RSO\”:\”2025-08-04+16:00:00+TO+2025-08-04+17:00:00\”}],\”IsFilterCondition\”:true},{\”Type\”:\”Lead\”,\”ConOp\”:\”and\”,\”RowCondition\”:[{\”SubConOp\”:\”And\”,\”LSO\”:\”LeadType\”,\”LSO_Type\”:\”string\”,\”Operator\”:\”eq\”,\”RSO\”:\”OT_0\”}]}],\”QueryTimeZone\”:\”India+Standard+Time\”}”,

“Paging”: {

“PageIndex”: 2,

“PageSize”: 20

“Sorting”: {

“ColumnName”: “CreatedOn”,

“Direction”: 1

}

}’

Solution: To retrieve custom fields in the API Try passing the following in the payload with the custom field values you wish to retrieve

“Columns”: {

“Include_CSV”: “ProspectID, FirstName, LastName, EmailAddress”

}