Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • DSS /
avatar image
Question by abhishek.joshi6 · Jul 10, 2020 at 04:34 AM · corporate actioncorporateactions

Information required for request response structure of Corporate Actions ISO report refinitiv api call.

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

People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

2 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by veerapath.rungruengrayubkul · Jul 10, 2020 at 06:36 AM

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
        }
    }
}


Comment

People who like this

0 Show 1 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
abhishek.joshi6 · Jul 29, 2020 at 12:54 PM 0
Share

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

avatar image
REFINITIV
Answer by veerapath.rungruengrayubkul · Jul 30, 2020 at 03:09 AM

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.
..."     
] }
Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
12 People are following this question.

Related Questions

PriceHistory Corporate Actions and Dividend adjustement

Getting planned delisting date for a given corporate action

How can I reproduce this section of XML Corporate Actions Report Template

How to use CorporateActions extractions

I can see that the CorporateActionStandardReportTemplate gives the dividend for Equities. But I am not able to get the dividend info for Mutual Funds. Is there another API for that? Or is it that the parameters should be different

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges