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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
76 2 1 11

Example of usage of Java Rest ExtractRaw for Iso Corporate Actions

Hi,

Do you have any example of how to read Rest request for

CorporateActionsIsoExtractionRequest, that use an ExtractRaw request, I get the an output but only the note, no ISO data.

The request:

{
"ExtractionRequest":{
"@odata.type":"#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.CorporateActionsIsoExtractionRequest",
"Condition":{
"ReportDateRangeType":"Delta",
"PendingEventsPreviousDays":1,
"ReportIsoEvents":["ACTV","BIDS","BONU","BPUT","BRUP","CAPD","CAPG","CAPI","CHAN","CMET","CONV","DECR","DFLT","DLST","DRCA","DRIP","DVCA","DVOP","DVSE","EXOF","EXRI","EXTM","INCR","INTR","LIQU","MCAL","MEET","MRGR","ODLT","OMET","OTHR","PARI","PCAL","PPMT","PRIO","REDM","REDO","RHDI","RHTS","SHPR","SOFF","SPLF","SPLR","SUSP","TEND","XMET"],
"CorporateActionsStandardYearType":"Current",
"IncludeNonPendingEvents":true,
"GrossAmountOnlyForPaymentEvents":true,
"ExcludeNilPaidFromPaymentEvents":true
},
"IdentifierList":{
"@odata.type":"#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList","InstrumentIdentifiers":[{"Identifier":"4","IdentifierType":"FileCode"},{"Identifier":"4","IdentifierType":"FileCode"},{"Identifier":"4","IdentifierType":"FileCode"},{"Identifier":"4","IdentifierType":"FileCode"}],
"ValidationOptions":null,
"UseUserPreferencesForValidationOptions":false
}
}
}

The reply I get:

{"@odata.context":"https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#RawExtractionResults/$entity","JobId":"0x05870f742f7b3016","Notes":["Extraction Services Version 10.7.35743 (b74a502e64b0), Built Oct 17 2016 20:52:51
Corporate Action ISO Report Type is Delta.
Processing started at 2016-12-14 10:33:06.
User ID: 9009941
Extraction ID: 240472962
Schedule: _OnD_0x05870f742f7b3016 (ID = 0x05870f750fbb3016)
Input List (4 items): _OnD_0x05870f742f7b3016 (ID = 05870f7471cb3016) Created: 2016-12-14 10:32:55 Last Modified: 2016-12-14 10:32:57
Delisted RICs are not included in the file code expansion.
File code 4 expanded to 299 RICS: 1319.NG to 9987.NG.
File code 4 expanded to 299 RICS: 1319.NG to 9987.NG.
File code 4 expanded to 299 RICS: 1319.NG to 9987.NG.
File code 4 expanded to 299 RICS: 1319.NG to 9987.NG.
Total instruments after instrument expansion = 1196
Schedule Time: 2016-12-14 10:33:00
Report Template (0 fields): _OnD_0x05870f742f7b3016 (ID = 0x05870f74632b3016) Created: 2016-12-14 10:32:55 Last Modified: 2016-12-14 10:32:55
Requested Corporate Action ISO events: ACTV,BIDS,BONU,BPUT,BRUP,CAPD,CAPG,CAPI,CHAN,CMET,CONV,DECR,DFLT,DLST,DRCA,DRIP,DVCA,DVOP,DVSE,EXOF,EXRI,EXTM,INCR,INTR,LIQU,MCAL,MEET,MRGR,ODLT,OMET,OTHR,PARI,PCAL,PPMT,PRIO,REDM,REDO,RHDI,RHTS,SHPR,SOFF,SPLF,SPLR,SUSP,TEND,XMET
Reporting all Corporate Action deltas since 12/12/2016 19:00:00.000 US/Eastern.
Reporting all Corporate Action deltas before 12/14/2016 05:33:00.000 US/Eastern.
Processing completed successfully at 2016-12-14 10:36:39, taking 213.779 Secs.
Extraction finished at 2016-12-14 10:36:39 UTC, with servers: x04A04, QSHA02 (0.0 secs), QSHC01 (212.0 secs)
8 Corporate Action ISO messages were generated.
Usage Summary for User 9009941, Client 104819, Template Type Corporate Actions, ISO15022
Base Usage
Instrument Instrument Terms Price
Count Type Subtype Source Source
------- ----------------------------------- ---------------------------- -------------- ----------------------------------------
1196 Equities N/A N/A
-------
1196 Total instruments charged.
0 Instruments with no reported data.
=======
1196 Instruments in the input list.
Writing RIC maintenance report.
","Identifier,IdentType,Source,RIC,RecordDate,MaintType,OldValue,NewValue,Factor,FactorType
"]}

Thanks

Stephane

dss-rest-apidatascope-selectdssjavarest-api
icon clock
10 |1500

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

Upvotes
Accepted
13.7k 26 8 12

@Stephane Rossi

The workflow for raw data is different from other extractions. After the actions you already performed, to retrieve the raw data you need to send a GET request to the following URL, which includes as parameter the JobId you received:

https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/RawExtractionResults('0x05870f742f7b3016')/$value

icon clock
10 |1500

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

Upvotes
76 2 1 11

Thanks all fine now

icon clock
10 |1500

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

Click below to post an Idea Post Idea