Information required for request response structure of Corporate Actions ISO report refinitiv api ca
Hi Team,
We need to consume refinitiv's Corporate Actions ISO report api call and require json request structure for making this call. Also, please provide the details of what will be the output format/structure of this call. Example: Currently we are consuming refinitiv eod price api call using below request structure:
{
"ExtractionRequest":{
"@odata.type":"#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.EndOfDayPricingExtractionRequest",
"ContentFieldNames":[
"ISIN",
"RIC",
"User Defined Identifier",
"Universal Ask Price",
"Universal Bid Ask Date",
"Universal Bid Price",
"Universal Close Price",
"Universal Close Price Date",
"Accrual",
"Accrued Interest",
"Alternate Close Grade",
"Alternate Close Price",
"Ask Clean Price",
"Ask Dirty Price",
"Ask Price",
"Asset Status",
"Asset Status Description",
"Base Currency Code",
"Bid Clean Price",
"Bid Dirty Price",
"Bid Price",
"Close Price",
"Close Price Timestamp",
"Close Price Timestamp Grade",
"Currency Code",
"Currency Code Description",
"Currency Code Scaled",
"Currency Code Scaled Description",
"Exchange Code",
"Exchange Description"
],
"IdentifierList":{
"@odata.type":"#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
"InstrumentIdentifiers":[
{
"Identifier":"AT0000A100E2",
"IdentifierType":"Isin",
"Source":"TWE"
},
{
"Identifier":"AT0000A100E2",
"IdentifierType":"Isin",
"Source":"EJV"
}
],
"ValidationOptions":null,
"UseUserPreferencesForValidationOptions":false
},
"Condition":{
"ScalableCurrency":true
}
}
}
Can you please help us provide similar request structure of Corporate Actions ISO report call?
Thanks and Regards,
Abhishek Joshi
Best Answer
-
Hi @abhishek.joshi6,
The Corporate Actions ISO 15022 can be retrieved on CorporateActionsISO report template. The report template support only the ExtractRaw endpoint. You can find the instruction for ExtractRaw on this tutorial.
Below is the sample of request body provided in the API Reference Tree and C# Example Application which is available on the download tab.
You can find more details about data in the ISO 15022 Service User Guide.
POST https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/ExtractRaw
{
"ExtractionRequest": {
"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.CorporateActionsIsoExtractionRequest",
"Condition": {
"ReportDateRangeType": "Init",
"ReportIsoEvents": [
"ACTV",
"BIDS"
],
"IncludeNonPendingEvents": true,
"GrossAmountOnlyForPaymentEvents": true,
"ExcludeNilPaidFromPaymentEvents": true
},
"IdentifierList": {
"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
"InstrumentIdentifiers": [
{
"Identifier": "IBM.N",
"IdentifierType": "Ric"
}
],
"ValidationOptions": null,
"UseUserPreferencesForValidationOptions": false
}
}
}0
Answers
-
Hi @veerapath.rungruengrayubkul , thanks for the response, we were able to hit the corporate action api, but as mentioned in the tutorial link we are being returned a job id and we need to make another api call to extract actual CA data (https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/RawExtractionResults('0x0730bbbce486becc')/$value). Isin being used in the request are FR0000031122 and DE0008404005 (but getting blank response for both). Can you please also let us know the Content-Type to be put in header of this request. Currently we are trying with "application/json", but not getting any response (We get 200 OK status but response is blank). Can you please suggest what should be done here?
Thanks and Regards,
Abhishek Joshi
0 -
Hi @abhishek.joshi6,
I have tried to add all ReportIsoEvents in the request and am able to get some response, so this likely is related to the content. You can contact DSS content support via MyRefinitiv for further discussion. Below is the request.
{
"ExtractionRequest": {
"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.CorporateActionsIsoExtractionRequest",
"Condition": {
"ReportDateRangeType": "Init",
"ReportIsoEvents": [
"ACTV", "BIDS", "BONU", "BPUT", "BRUP", "CAPD", "CAPG", "CAPI", "CHAN", "CMET", "CONV", "DECR", "DFLT", "DLST", "DRCA", "DRIP",
"DVCA", "DVOP", "DVSE", "EXOF", "EXRI", "EXTM", "EXWA", "INCR", "INTR", "LIQU", "MCAL", "MEET", "MRGR", "ODLT", "OMET", "OTHR",
"PARI", "PCAL", "PPMT", "PRIO", "REDM", "REDO", "RHDI", "RHTS", "SHPR", "SOFF", "SPLF", "SPLR", "SUSP", "TEND", "XMET"
],
"IncludeNonPendingEvents": true,
"GrossAmountOnlyForPaymentEvents": true,
"ExcludeNilPaidFromPaymentEvents": true
},
"IdentifierList": {
"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
"InstrumentIdentifiers": [
{
"Identifier": "FR0000031122",
"IdentifierType": "Isin"
},
{
"Identifier": "DE0008404005",
"IdentifierType": "Isin"
}
],
"ValidationOptions": null,
"UseUserPreferencesForValidationOptions": false
}
}
}Anyway, you can also find some useful informationin the Notes in the response of ExtractRaw request. Below is sample of the Notes information.
@{ "@odata.context": "https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#RawExtractionResults/$entity",
"JobId": "0x0730cae61286bee9",
"Notes": [
"...Processing completed successfully at 30/07/2020 09:10:43, taking 2.41 Secs.
Extraction finished at 30/07/2020 02:10:43 UTC, with servers: x02A05, QSHC20 (1.7 secs), QSSHA1 (0.0 secs)
Column 'CIN' suppressed for lack of CIN permission.
Column 'CapitalChangeNewSecurityCin' suppressed for lack of CIN permission.
Column 'IsoRightsSecurityCin' suppressed for lack of CIN permission.
1 Corporate Action ISO message was generated.
..."
] }0
Categories
- All Categories
- 6 AHS
- 37 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛