| Last update | Jan 2026 |
| Environment | Any |
| Language | Any HTTP is supported |
| Compilers | None |
| Prerequisites | DSS login, internet access |
| Source code | Below |
This tutorial explains how to:
If you do not know what field lists are available, you can request a list of those available.
The report template type must be specified in the path. As we want corporate actions data we set a value of CorporateActions. The preceding and following tutorials show other possibilities.
Note: for all requests we need a user token. This was retrieved in Tutorial 1.
URL:
https://selectapi.datascope.lseg.com/RestApi/v1/Extractions/GetValidContentFieldTypes(ReportTemplateType=DataScope.Select.Api.Extractions.ReportTemplates.ReportTemplateTypes'CorporateActions')
Method: GET
Headers:
Prefer: respond-async
Authorization: Token F0ABE9A3FFF2E02E10AE2765ED872C59B8CC3B40EBB61B30E295E71DE31C254B8648DB9434C2DF9299FDC668AA123501F322D99D45C8B93438063C912BC936C7B87062B0CF812138863F5D836A7B31A32DCA67EF07B3B50B2FC4978DF6F76784FDF35FCB523A8430DA93613BC5730CDC310D4D241718F9FC3F2E55465A24957CC287BDEC79046B31AD642606275AEAD76318CB221BD843348E1483670DA13968D8A242AAFCF9E13E23240C905AE46DED9EDCA9BB316B4C5C767B18DB2EA7ADD100817ADF059D01394BC6375BECAF6138C25DBA57577F0061
If the token is valid, this is the response we get:
Status: 200 OK
Relevant headers:
Content-Type: application/json; charset=utf-8
Body:
There are more than 300 values in the response. Here is the beginning of the response:
{
"@odata.context": "https://selectapi.datascope.lseg.com/RestApi/v1/$metadata#ContentFieldTypes",
"value": [
{
"Code": "COR.Accounting Standard",
"Name": "Accounting Standard",
"Description": "Code indicating the accounting standard used in accounts in which the EPS figure is reported",
"FormatType": "Text",
"FieldGroup": " "
},
{
"Code": "COR.Acquirer Company Name",
"Name": "Acquirer Company Name",
"Description": "Name of the acquiring party",
"FormatType": "Text",
"FieldGroup": " "
},
{
"Code": "COR.Acquirer RIC",
"Name": "Acquirer RIC",
"Description": "RIC of primary issue of acquirer",
"FormatType": "Text",
"FieldGroup": " "
},
{
"Code": "COR.Acquirer Row ID",
"Name": "Acquirer Row ID",
"Description": "Unique system-assigned identifier for the acquiring party",
"FormatType": "Number",
"FieldGroup": " "
},
{
"Code": "COR.Actual Adjustment Factor",
"Name": "Actual Adjustment Factor",
"Description": "Actual or as-reported adjustment factor expressing the dilutive effect of the capital change event on per share values",
"FormatType": "Number",
"FieldGroup": " "
},
This goes with all the other available fields. Here is the last part:
{
"Code": "COR.Wertpapier",
"Name": "Wertpapier",
"Description": "Issue-level code used for identifying instruments in Germany",
"FormatType": "Text",
"FieldGroup": " "
},
{
"Code": "COR.Withdrawn Date",
"Name": "Withdrawn Date",
"Description": "Date on which the offer was withdrawn",
"FormatType": "Date",
"FieldGroup": " "
},
{
"Code": "COR.Zip Code",
"Name": "Zip Code",
"Description": "Current zip code of the organization",
"FormatType": "Text",
"FieldGroup": " "
}
]
}
The result contains the field code, name, a description, field type (number, text, date) and group. Use this to choose the field names you want. In the next step we will make a request for data, using some data fields we chose.
This is similar to the previous tutorials, as it is also an On Demand extraction request.
The body of the request must mention it is an extraction request. It contains several parts:
Note: for all requests we need to include a user token in the header of our request. This was retrieved in Tutorial 1.
URL:
https://selectapi.datascope.lseg.com/RestApi/v1/Extractions/ExtractWithNotes
Method: POST
Headers:
Prefer: respond-async
Content-Type: application/json
Authorization: Token F0ABE9A3FFF2E02E10AE2765ED872C59B8CC3B40EBB61B30E295E71DE31C254B8648DB9434C2DF9299FDC668AA123501F322D99D45C8B93438063C912BC936C7B87062B0CF812138863F5D836A7B31A32DCA67EF07B3B50B2FC4978DF6F76784FDF35FCB523A8430DA93613BC5730CDC310D4D241718F9FC3F2E55465A24957CC287BDEC79046B31AD642606275AEAD76318CB221BD843348E1483670DA13968D8A242AAFCF9E13E23240C905AE46DED9EDCA9BB316B4C5C767B18DB2EA7ADD100817ADF059D01394BC6375BECAF6138C25DBA57577F0061
Body:
{
"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": "02079K107", "IdentifierType": "Cusip" },
{ "Identifier": "ALVG.DE", "IdentifierType": "Ric" },
{ "Identifier": "IBM.N", "IdentifierType": "Ric" }
]
},
"Condition": {
"ReportDateRangeType": "Last",
"PreviousDays": 30,
"ExcludeDeletedEvents": true,
"IncludeCapitalChangeEvents": true,
"IncludeDividendEvents": true,
"IncludeEarningsEvents": true,
"IncludeMergersAndAcquisitionsEvents": true,
"IncludeNominalValueEvents": true,
"IncludePublicEquityOfferingsEvents": true,
"IncludeSharesOutstandingEvents": true,
"IncludeVotingRightsEvents": true,
"CorporateActionsCapitalChangeType": "CapitalChangeExDate",
"CorporateActionsDividendsType": "DividendPayDate",
"CorporateActionsEarningsType": "PeriodEndDate",
"ShareAmountTypes": [
]
}
}
}
If the token is valid, and there is no timeout, the data will be delivered. This is the response we get:
Status: 200 OK
Relevant headers:
Content-Type: application/json; charset=utf-8
Body:
{
"@odata.context": "https://selectapi.datascope.lseg.com/RestApi/v1/$metadata#DataScope.Select.Api.Extractions.ExtractionRequests.ExtractionResult",
"Contents": [
{
"IdentifierType": "Cusip",
"Identifier": "02079K107",
"Corporate Actions Type": "CAP",
"Capital Change Event Type": 78,
"Capital Change Event Type Description": "Exchange Offer",
"Actual Adjustment Type": "RPO",
"Actual Adjustment Type Description": "Reuters Pricing Only - Adjusts Pricing",
"Adjustment Factor": 1,
"Currency Code": "USD",
"Exchange Code": "NSM",
"Effective Date": "2015-10-05",
"Dividend Pay Date": null,
"Dividend Rate": null,
"Nominal Value": null,
"Nominal Value Currency": null,
"Nominal Value Date": null
},
{
"IdentifierType": "Cusip",
"Identifier": "02079K107",
"Corporate Actions Type": "SHO",
"Capital Change Event Type": null,
"Capital Change Event Type Description": null,
"Actual Adjustment Type": null,
"Actual Adjustment Type Description": null,
"Adjustment Factor": null,
"Currency Code": "USD",
"Exchange Code": "NSM",
"Effective Date": null,
"Dividend Pay Date": null,
"Dividend Rate": null,
"Nominal Value": null,
"Nominal Value Currency": null,
"Nominal Value Date": null
},
{
"IdentifierType": "Cusip",
"Identifier": "02079K107",
"Corporate Actions Type": "DIV",
"Capital Change Event Type": null,
"Capital Change Event Type Description": null,
"Actual Adjustment Type": null,
"Actual Adjustment Type Description": null,
"Adjustment Factor": null,
"Currency Code": "USD",
"Exchange Code": "NSM",
"Effective Date": null,
"Dividend Pay Date": "2015-05-04",
"Dividend Rate": 0.27455,
"Nominal Value": null,
"Nominal Value Currency": null,
"Nominal Value Date": null
},
{
"IdentifierType": "Cusip",
"Identifier": "02079K107",
"Corporate Actions Type": "VOT",
"Capital Change Event Type": null,
"Capital Change Event Type Description": null,
"Actual Adjustment Type": null,
"Actual Adjustment Type Description": null,
"Adjustment Factor": null,
"Currency Code": "USD",
"Exchange Code": "NSM",
"Effective Date": null,
"Dividend Pay Date": null,
"Dividend Rate": null,
"Nominal Value": null,
"Nominal Value Currency": null,
"Nominal Value Date": null
},
{
"IdentifierType": "Cusip",
"Identifier": "02079K107",
"Corporate Actions Type": "EAR",
"Capital Change Event Type": null,
"Capital Change Event Type Description": null,
"Actual Adjustment Type": null,
"Actual Adjustment Type Description": null,
"Adjustment Factor": null,
"Currency Code": "USD",
"Exchange Code": "NSM",
"Effective Date": null,
"Dividend Pay Date": null,
"Dividend Rate": null,
"Nominal Value": null,
"Nominal Value Currency": null,
"Nominal Value Date": null
},
{
"IdentifierType": "Cusip",
"Identifier": "02079K107",
"Corporate Actions Type": "NOM",
"Capital Change Event Type": null,
"Capital Change Event Type Description": null,
"Actual Adjustment Type": null,
"Actual Adjustment Type Description": null,
"Adjustment Factor": null,
"Currency Code": "USD",
"Exchange Code": "NSM",
"Effective Date": null,
"Dividend Pay Date": null,
"Dividend Rate": null,
"Nominal Value": 0.001,
"Nominal Value Currency": "USD",
"Nominal Value Date": "2015-04-27"
},
{
"IdentifierType": "Ric",
"Identifier": "ALVG.DE",
"Corporate Actions Type": "SHO",
"Capital Change Event Type": null,
"Capital Change Event Type Description": null,
"Actual Adjustment Type": null,
"Actual Adjustment Type Description": null,
"Adjustment Factor": null,
"Currency Code": "EUR",
"Exchange Code": "GER",
"Effective Date": null,
"Dividend Pay Date": null,
"Dividend Rate": null,
"Nominal Value": null,
"Nominal Value Currency": null,
"Nominal Value Date": null
},
{
"IdentifierType": "Ric",
"Identifier": "ALVG.DE",
"Corporate Actions Type": "VOT",
"Capital Change Event Type": null,
"Capital Change Event Type Description": null,
"Actual Adjustment Type": null,
"Actual Adjustment Type Description": null,
"Adjustment Factor": null,
"Currency Code": "EUR",
"Exchange Code": "GER",
"Effective Date": null,
"Dividend Pay Date": null,
"Dividend Rate": null,
"Nominal Value": null,
"Nominal Value Currency": null,
"Nominal Value Date": null
},
{
"IdentifierType": "Ric",
"Identifier": "ALVG.DE",
"Corporate Actions Type": "PEO",
"Capital Change Event Type": null,
"Capital Change Event Type Description": null,
"Actual Adjustment Type": null,
"Actual Adjustment Type Description": null,
"Adjustment Factor": null,
"Currency Code": "EUR",
"Exchange Code": "GER",
"Effective Date": null,
"Dividend Pay Date": null,
"Dividend Rate": null,
"Nominal Value": 2.56,
"Nominal Value Currency": "EUR",
"Nominal Value Date": null
},
{
"IdentifierType": "Ric",
"Identifier": "ALVG.DE",
"Corporate Actions Type": "NOM",
"Capital Change Event Type": null,
"Capital Change Event Type Description": null,
"Actual Adjustment Type": null,
"Actual Adjustment Type Description": null,
"Adjustment Factor": null,
"Currency Code": "EUR",
"Exchange Code": "GER",
"Effective Date": null,
"Dividend Pay Date": null,
"Dividend Rate": null,
"Nominal Value": null,
"Nominal Value Currency": null,
"Nominal Value Date": "2018-08-14"
},
{
"IdentifierType": "Ric",
"Identifier": "ALVG.DE",
"Corporate Actions Type": "MNA",
"Capital Change Event Type": null,
"Capital Change Event Type Description": null,
"Actual Adjustment Type": null,
"Actual Adjustment Type Description": null,
"Adjustment Factor": null,
"Currency Code": "EUR",
"Exchange Code": "GER",
"Effective Date": null,
"Dividend Pay Date": null,
"Dividend Rate": null,
"Nominal Value": null,
"Nominal Value Currency": null,
"Nominal Value Date": null
},
{
"IdentifierType": "Ric",
"Identifier": "ALVG.DE",
"Corporate Actions Type": "EAR",
"Capital Change Event Type": null,
"Capital Change Event Type Description": null,
"Actual Adjustment Type": null,
"Actual Adjustment Type Description": null,
"Adjustment Factor": null,
"Currency Code": "EUR",
"Exchange Code": "GER",
"Effective Date": null,
"Dividend Pay Date": null,
"Dividend Rate": null,
"Nominal Value": null,
"Nominal Value Currency": null,
"Nominal Value Date": null
},
{
"IdentifierType": "Ric",
"Identifier": "ALVG.DE",
"Corporate Actions Type": "MNA",
"Capital Change Event Type": null,
"Capital Change Event Type Description": null,
"Actual Adjustment Type": null,
"Actual Adjustment Type Description": null,
"Adjustment Factor": null,
"Currency Code": "EUR",
"Exchange Code": "GER",
"Effective Date": null,
"Dividend Pay Date": null,
"Dividend Rate": null,
"Nominal Value": null,
"Nominal Value Currency": null,
"Nominal Value Date": null
},
{
"IdentifierType": "Ric",
"Identifier": "ALVG.DE",
"Corporate Actions Type": "DIV",
"Capital Change Event Type": null,
"Capital Change Event Type Description": null,
"Actual Adjustment Type": null,
"Actual Adjustment Type Description": null,
"Adjustment Factor": null,
"Currency Code": "EUR",
"Exchange Code": "GER",
"Effective Date": null,
"Dividend Pay Date": "2022-05-09",
"Dividend Rate": 10.8,
"Nominal Value": null,
"Nominal Value Currency": null,
"Nominal Value Date": null
},
{
"IdentifierType": "Ric",
"Identifier": "ALVG.DE",
"Corporate Actions Type": "CAP",
"Capital Change Event Type": 13,
"Capital Change Event Type Description": "Non-renounceable rights issue in same stock",
"Actual Adjustment Type": "CCH",
"Actual Adjustment Type Description": "Capital Change - Adjusts Dividend and Earnings per Share, Pricing and Volume",
"Adjustment Factor": 1,
"Currency Code": "EUR",
"Exchange Code": "GER",
"Effective Date": "2007-05-03",
"Dividend Pay Date": null,
"Dividend Rate": null,
"Nominal Value": null,
"Nominal Value Currency": null,
"Nominal Value Date": null
},
{
"IdentifierType": "Ric",
"Identifier": "IBM.N",
"Corporate Actions Type": "SHO",
"Capital Change Event Type": null,
"Capital Change Event Type Description": null,
"Actual Adjustment Type": null,
"Actual Adjustment Type Description": null,
"Adjustment Factor": null,
"Currency Code": "USD",
"Exchange Code": "NYS",
"Effective Date": null,
"Dividend Pay Date": null,
"Dividend Rate": null,
"Nominal Value": null,
"Nominal Value Currency": null,
"Nominal Value Date": null
},
{
"IdentifierType": "Ric",
"Identifier": "IBM.N",
"Corporate Actions Type": "MNA",
"Capital Change Event Type": null,
"Capital Change Event Type Description": null,
"Actual Adjustment Type": null,
"Actual Adjustment Type Description": null,
"Adjustment Factor": null,
"Currency Code": "USD",
"Exchange Code": "NYS",
"Effective Date": null,
"Dividend Pay Date": null,
"Dividend Rate": null,
"Nominal Value": null,
"Nominal Value Currency": null,
"Nominal Value Date": null
},
{
"IdentifierType": "Ric",
"Identifier": "IBM.N",
"Corporate Actions Type": "VOT",
"Capital Change Event Type": null,
"Capital Change Event Type Description": null,
"Actual Adjustment Type": null,
"Actual Adjustment Type Description": null,
"Adjustment Factor": null,
"Currency Code": "USD",
"Exchange Code": "NYS",
"Effective Date": null,
"Dividend Pay Date": null,
"Dividend Rate": null,
"Nominal Value": null,
"Nominal Value Currency": null,
"Nominal Value Date": null
},
{
"IdentifierType": "Ric",
"Identifier": "IBM.N",
"Corporate Actions Type": "NOM",
"Capital Change Event Type": null,
"Capital Change Event Type Description": null,
"Actual Adjustment Type": null,
"Actual Adjustment Type Description": null,
"Adjustment Factor": null,
"Currency Code": "USD",
"Exchange Code": "NYS",
"Effective Date": null,
"Dividend Pay Date": null,
"Dividend Rate": null,
"Nominal Value": 0.2,
"Nominal Value Currency": "USD",
"Nominal Value Date": "2008-06-30"
},
{
"IdentifierType": "Ric",
"Identifier": "IBM.N",
"Corporate Actions Type": "EAR",
"Capital Change Event Type": null,
"Capital Change Event Type Description": null,
"Actual Adjustment Type": null,
"Actual Adjustment Type Description": null,
"Adjustment Factor": null,
"Currency Code": "USD",
"Exchange Code": "NYS",
"Effective Date": null,
"Dividend Pay Date": null,
"Dividend Rate": null,
"Nominal Value": null,
"Nominal Value Currency": null,
"Nominal Value Date": null
},
{
"IdentifierType": "Ric",
"Identifier": "IBM.N",
"Corporate Actions Type": "DIV",
"Capital Change Event Type": null,
"Capital Change Event Type Description": null,
"Actual Adjustment Type": null,
"Actual Adjustment Type Description": null,
"Adjustment Factor": null,
"Currency Code": "USD",
"Exchange Code": "NYS",
"Effective Date": null,
"Dividend Pay Date": "2022-06-10",
"Dividend Rate": 1.65,
"Nominal Value": null,
"Nominal Value Currency": null,
"Nominal Value Date": null
},
{
"IdentifierType": "Ric",
"Identifier": "IBM.N",
"Corporate Actions Type": "CAP",
"Capital Change Event Type": 74,
"Capital Change Event Type Description": "Demerger (DEM)",
"Actual Adjustment Type": "RPO",
"Actual Adjustment Type Description": "Reuters Pricing Only - Adjusts Pricing",
"Adjustment Factor": 1,
"Currency Code": "USD",
"Exchange Code": "NYS",
"Effective Date": "2021-11-03",
"Dividend Pay Date": null,
"Dividend Rate": null,
"Nominal Value": null,
"Nominal Value Currency": null,
"Nominal Value Date": null
}
],
"Notes": [
"Extraction Services Version 16.0.43633 (806c08a4ae8f), Built May 9 2022 17:21:13\r\nProcessing started at 05/30/2022 08:44:30.\r\nUser ID: 9008895\r\nExtraction ID: 592934837\r\nCorrelation ID: CiD/9008895/AAAAAA.08084c75159df0ed/RA/EXT.592934837\r\nSchedule: _OnD_0x08084c7515adf0ed (ID = 0x08084c7519bdf0ed)\r\nReporting the latest corporate actions.\r\nSuppressing Deleted Events\r\nReporting corporate actions with shares default type.\r\nInput List (3 items): _OnD_0x08084c7515adf0ed (ID = 08084c75172df0ed) Created: 05/30/2022 08:44:27 Last Modified: 05/30/2022 08:44:28\r\nSchedule Time: 05/30/2022 08:44:28\r\nReport Template (20 fields): _OnD_0x08084c7515adf0ed (ID = 0x08084c7515cdf0ed) Created: 05/30/2022 08:44:27 Last Modified: 05/30/2022 08:44:27\r\nProcessing completed successfully at 05/30/2022 08:44:31, taking 1.16 Secs.\r\nExtraction finished at 05/30/2022 07:44:31 UTC, with servers: x03A04, QSDHA1 (0.0 secs), QSHC12 (0.4 secs)\r\nUsage Summary for User 9008895, Client 65508, Template Type Corporate Actions, Standard Events\r\nBase Usage\r\n Instrument Instrument Terms Price\r\n Count Type Subtype Source Source\r\n------- ----------------------------------- ---------------------------- -------------- ----------------------------------------\r\n 3 Equities N/A N/A\r\n-------\r\n 3 Total instruments charged.\r\n 0 Instruments with no reported data.\r\n=======\r\n 3 Instruments in the input list.\r\nWriting RIC maintenance report.\r\n",
"Identifier,IdentType,Source,RIC,RecordDate,MaintType,OldValue,NewValue,Factor,FactorType\r\n"
]
}
No corporate actions apply to the bond, so there are no results for that instrument.
The Corporate Actions Type defines the event type:
| Value | Description |
| CAP | Capital change |
| DIV | Dividend |
| EAR | Earnings |
| MNA | Mergers and acquisitions |
| NOM | Nominal value |
| PEO | Public equity offering |
| SHO | Shares outstanding |
| VOT | Voting rights |
Depending on the event type, some fields will contain values, others, irrelevant to that case, will be null.