How to select "CorporateActionsStandardEventsType" as "CAP","DIV" and "MNA" altogether

MayankJ

Hi Team,

Below is my request body and I want to include CAP, DIV, and MNA together as CorporateActionsStandardEventsType within a single API call.

{
"ExtractionRequest": {
"@odata .type": "#DataScope.Select.Api.Extractions.ExtractionRequests.CorporateActionsStandardExtractionRequest",
"ContentFieldNames": [
"Security Long Description",
"ISIN",
"SEDOL",
"RIC",
"Dividend Ex Date",
"Capital Change Ex Date",
"Effective Date",
"Deal Effective Date",
"Dividend Pay Date",
"Dividend Payment Type Description",
"Capital Change Event Type Description",
"Dividend Currency",
"Dividend Currency Description",
"Dividend Rate",
"Dividend Tax Marker Description",
"New Shares Terms",
"Old Shares Terms",
"Offer Price",
"Offer Price Currency",
"Capital Change New Security ISIN",
"Corporate Action Notes"
],
"IdentifierList": {
"@odata .type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
"InstrumentIdentifiers": [
{
"Identifier": "7144569",
"IdentifierType": "Sedol"
}
],
"ValidationOptions": {
"AllowOpenAccessInstruments": true,
"AllowHistoricalInstruments": true,
"AllowLimitedTermInstruments": true,
"AllowInactiveInstruments": true,
"AllowUnsupportedInstruments": true,
"ExcludeFinrAsPricingSourceForBonds": true,
"UseExchangeCodeInsteadOfLipper": true,
"UseUsQuoteInsteadOfCanadian": true,
"UseConsolidatedQuoteSourceForUsa": true,
"UseConsolidatedQuoteSourceForCanada": true,
"UseDebtOverEquity": true,
"UseOtcPqSource": true,
"AllowSubclassImport": true
},
"UseUserPreferencesForValidationOptions": false
},
"Condition": {
"ReportDateRangeType": "Range",
"QueryStartDate": "2025-01-15",
"QueryEndDate": "2026-01-20",
"ExcludeDeletedEvents": true,
"IncludeDividendEvents": true,
"CorporateActionsDividendsType": "DividendExDate",
"IncludeInstrumentsWithNoEvents": false,
"IncludeNullDates": false,
"ExcludeDeletedEvents": true,
"IncludeCapitalChangeEvents": true,
"IncludeDividendEvents": true,
"IncludeEarningsEvents": false,
"IncludeMergersAndAcquisitionsEvents": true,
"IncludeNominalValueEvents": false,
"IncludePublicEquityOfferingsEvents": false,
"IncludeSharesOutstandingEvents": false,
"IncludeVotingRightsEvents": false,
"CorporateActionsCapitalChangeType": "CapitalChangeExDate",
"CorporateActionsDividendsType": "DividendExDate",
"CorporateActionsEarningsType": "EarningsAnnouncementDate",
"CorporateActionsEquityOfferingsType": "AllPendingDeals",
"CorporateActionsMergersAcquisitionsType": "DealEffectiveDate",
"CorporateActionsNominalValueType": "NominalValueDate",
"CorporateActionsSharesType": "SharesAmountDate",
"CorporateActionsStandardEventsType": "CAP",
"CorporateActionsVotingRightsType": "VotingRightsDate",
"ShareAmountChoice": "All",
"ShareAmountTypes": [
"Outstanding"
],
"ExcludeHistoricalEvents": false,
"LastEntityOnly": false
}
}
}

Can you suggest what to do here?

Jirapongse

@MayankJ

Thank you for reaching out to us.

I tested the following Corporate Actions - Standard Events Report template on the DSS Web UI.

The output is also empty.

Can you check if the data is available on the DSS Web UI?

It will return the CAP and MNA events if I change the QueryStartDate to "2000-01-15".

{

    "ExtractionRequest": {

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

        "ContentFieldNames": [

            "Corporate Actions Type",

            "Security Long Description",

            "ISIN",

            "SEDOL",

            "RIC",

            "Dividend Ex Date",

            "Capital Change Ex Date",

            "Effective Date",

            "Deal Effective Date",

            "Dividend Pay Date",

            "Dividend Payment Type Description",

            "Capital Change Event Type Description",

            "Dividend Currency",

            "Dividend Currency Description",

            "Dividend Rate",

            "Dividend Tax Marker Description",

            "New Shares Terms",

            "Old Shares Terms",

            "Offer Price",

            "Offer Price Currency",

            "Capital Change New Security ISIN",

            "Corporate Action Notes"

        ],

        "IdentifierList": {

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

            "InstrumentIdentifiers": [

                {

                    "Identifier": "7144569",

                    "IdentifierType": "Sedol"

                }

            ],

            "ValidationOptions": {

                "AllowOpenAccessInstruments": true,

                "AllowHistoricalInstruments": true,

                "AllowLimitedTermInstruments": true,

                "AllowInactiveInstruments": true,

                "AllowUnsupportedInstruments": true,

                "ExcludeFinrAsPricingSourceForBonds": true,

                "UseExchangeCodeInsteadOfLipper": true,

                "UseUsQuoteInsteadOfCanadian": true,

                "UseConsolidatedQuoteSourceForUsa": true,

                "UseConsolidatedQuoteSourceForCanada": true,

                "UseDebtOverEquity": true,

                "UseOtcPqSource": true,

                "AllowSubclassImport": true

            },

            "UseUserPreferencesForValidationOptions": false

        },

        "Condition": {

            "ReportDateRangeType": "Range",

            "QueryStartDate": "2000-01-15",

            "QueryEndDate": "2026-01-20",

            "ExcludeDeletedEvents": true,

            "IncludeDividendEvents": true,

            "CorporateActionsDividendsType": "DividendExDate",

            "IncludeInstrumentsWithNoEvents": false,

            "IncludeNullDates": false,

            "ExcludeDeletedEvents": true,

            "IncludeCapitalChangeEvents": true,

            "IncludeDividendEvents": true,

            "IncludeEarningsEvents": false,

            "IncludeMergersAndAcquisitionsEvents": true,

            "IncludeNominalValueEvents": false,

            "IncludePublicEquityOfferingsEvents": false,

            "IncludeSharesOutstandingEvents": false,

            "IncludeVotingRightsEvents": false,

            "CorporateActionsCapitalChangeType": "CapitalChangeExDate",

            "CorporateActionsDividendsType": "DividendExDate",

            "CorporateActionsEarningsType": "EarningsAnnouncementDate",

            "CorporateActionsEquityOfferingsType": "AllPendingDeals",

            "CorporateActionsMergersAcquisitionsType": "DealEffectiveDate",

            "CorporateActionsNominalValueType": "NominalValueDate",

            "CorporateActionsSharesType": "SharesAmountDate",

            "CorporateActionsVotingRightsType": "VotingRightsDate",

            "ShareAmountChoice": "All",

            "ShareAmountTypes": [

                "Outstanding"

            ],

            "ExcludeHistoricalEvents": false,

            "LastEntityOnly": false

        }

    }

}

For example:

 {

            "IdentifierType": "Sedol",

            "Identifier": "7144569",
     "Corporate Actions Type": "MNA",

            "Security Long Description": null,

            "ISIN": "IT0003128367",

            "SEDOL": "7144569",

            "RIC": "ENEI.MI",

            "Dividend Ex Date": null,

            "Capital Change Ex Date": null,

            "Effective Date": null,

            "Deal Effective Date": "2020-07-07",

            "Dividend Pay Date": null,

            "Dividend Payment Type Description": null,

            "Capital Change Event Type Description": null,

            "Dividend Currency": null,

            "Dividend Currency Description": null,

            "Dividend Rate": null,

            "Dividend Tax Marker Description": null,

            "New Shares Terms": null,

            "Old Shares Terms": null,

            "Offer Price": null,

            "Offer Price Currency": null,

            "Capital Change New Security ISIN": null,

            "Corporate Action Notes": null

        },

…

 {

            "IdentifierType": "Sedol",

            "Identifier": "7144569",
      "Corporate Actions Type": "CAP",

            "Security Long Description": "Enel Ord Shs",

            "ISIN": "IT0003128367",

            "SEDOL": "7144569",

            "RIC": "ENEI.MI",

            "Dividend Ex Date": null,

            "Capital Change Ex Date": "2001-06-18",

            "Effective Date": "2001-06-18",

            "Deal Effective Date": null,

            "Dividend Pay Date": null,

            "Dividend Payment Type Description": null,

            "Capital Change Event Type Description": "Cash Dividend",

            "Dividend Currency": null,

            "Dividend Currency Description": null,

            "Dividend Rate": null,

            "Dividend Tax Marker Description": null,

            "New Shares Terms": null,

            "Old Shares Terms": null,

            "Offer Price": null,

            "Offer Price Currency": null,

            "Capital Change New Security ISIN": null,

            "Corporate Action Notes": "0.112 EUR from total 0.13 EUR dividend to be paid from reserves."

        },