---
title: Missing Opportunity Fields in Advanced Search API Response
description: "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: ..."
url: "https://supportb.kinsta.cloud/docs/missing-opportunity-fields-in-advanced-search-api-response/"
updated: "2026-03-09"
category: "Apps: Mobile"
---

# Missing Opportunity Fields in Advanced Search API Response

**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'](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"** **}**  **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'](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"****}**