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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
76 8 2 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 512.0 KiB each and 1.0 MiB total.

@Stephane Rossi

Thank you for your participation in the forum.

Are any of the replies below satisfactory in resolving your query?

If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.

Otherwise please post again offering further insight into your question.

Thanks,

AHS

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 512.0 KiB each and 1.0 MiB total.

Upvotes
76 8 2 11

Thanks all fine now

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.