For a deeper look into our DataScope Select REST API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
1 0 0 0

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

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
  • capture-api.pngReport Query Type: Schedule Delta Query
    • 1 Day Ago
    • Don’t Exclude deleted events
    • Don’t Exclude historical events


#technologycorporate-actions
capture-api.png (58.2 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Upvotes
Accepted
84.9k 289 53 77

@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.

1722994509795.png



1722994509795.png (71.6 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.