Looking for API Ondemand query under New Corporate Actions - Standard Events Report

hariprasad.n

Please provide the API query for below extraction

Under New Corporate Actions - Standard Events Report

Data is accessed via SFTP.

• Schedules and instrument lists are configured by API
• Report templates were configured through the GUI I think
• Report Query Type: Schedule Delta Query
  • 1 Day Ago
  • Don’t Exclude deleted events
  • Don’t Exclude historical events

Jirapongse

@hariprasad.n

Thank you for reaching out to us.

The request could be like this:

{
    "ExtractionRequest": {
        "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.CorporateActionsStandardExtractionRequest",
        "ContentFieldNames": [
            "Corporate Actions Type",
            "Capital Change Event Type",
            "Capital Change Event Type Description",
            "Actual Adjustment Type",
            "Actual Adjustment Type Description",
            "Adjustment Factor",
            "Currency Code",
            "Exchange Code",
            "Effective Date",
            "Dividend Pay Date",
            "Dividend Rate",
            "Nominal Value",
            "Nominal Value Currency",
            "Nominal Value Date"
        ],
        "IdentifierList": {
            "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
            "InstrumentIdentifiers": [
                {
                    "Identifier": "IBM.N",
                    "IdentifierType": "Ric"
                }
            ]
        },
        "Condition": {
            "ReportDateRangeType": "Delta",
            "PreviousDays": 1,
            "ExcludeDeletedEvents": false,
            "ExcludeHistoricalEvents": false,
            "IncludeInstrumentsWithNoEvents": true,
            "IncludeNullDates": true,
            "IncludeCapitalChangeEvents": true,
            "IncludeDividendEvents": true,
            "IncludeEarningsEvents": true,
            "IncludeMergersAndAcquisitionsEvents": true,
            "IncludeNominalValueEvents": true,
            "IncludePublicEquityOfferingsEvents": true,
            "IncludeSharesOutstandingEvents": true,
            "IncludeVotingRightsEvents": true
        }
    }
}

The endpoint is https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/ExtractWithNotes.

You can access the REST API Reference Tree to see all available parameters of the CorporateActionsStandardExtractionRequest.