Clarification on Date Range Filter for Corporate Action Pull

satyam.chawla

Hi LSEG team,

We are in the process of enhancing our Corporate Action Pull functionality for securities by introducing a Date Range column, consisting of a From Date and a To Date.

To ensure we retrieve accurate and complete data, could you please advise on the following:

1. Which date field should be used to apply the date range filter (e.g., announcement date, effective date, pay date)?
2. Which column/field in your data model corresponds to that date, so we can map it correctly on our end?

Your guidance will help us implement the filter correctly and avoid any data discrepancies.

Thanks,

Satyam Chawla

Jirapongse

@satyam.chawla

Thank you for reaching out to us.

Do you mean the CorporateActionsStandardExtractionRequest extraction?

I checked and found that you can specify date type in the condition parameters, such as CorporateActionsDividendsType. For example:

{

  "ExtractionRequest": {

    "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.CorporateActionsStandardExtractionRequest",

    "ContentFieldNames": [

      "Dividend Pay Date",

      "Dividend Rate",

      "Dividend Announcement Date",

      "Dividend Ex Date",

      "Annualised Dividend Period End Date",

      "Dividend Record Date"

    ],

    "IdentifierList": {

      "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",

      "InstrumentIdentifiers": [


      	{ "Identifier": "IBM.N", "IdentifierType": "Ric" }

      ]

    },

    "Condition": {

      "ReportDateRangeType": "Range",

      "QueryStartDate": "2026-02-10",

      "QueryEndDate":"2026-02-11",

      "ExcludeDeletedEvents": true,     

      "IncludeDividendEvents": true,     

      "CorporateActionsDividendsType": "DividendExDate"

    }

  }

}

Then, I found that the "Dividend Ex Date" will be used as the values for the QueryStartDate and QueryEndDate parameters. For other parameters, please refer to the DSS REST API Reference Tree.

However, please contact the DSS support team directly via LSEG Support to confirm it.