Is there any Java example in DSS REST API, which can do on demand extraction by using pre-defined...

nityanand.koppad

Is there any Java example in DSS REST API, which can do on demand extraction by using pre-defined report templates with fields ISIN,SEDOL,RIC,TICKER,Security Name and GICS Industry Code.

susana.chang

Attached is an example. DSS REST On Demand Extraction does not takes a Report Template Id as param; thus the work around is:

1. create an Immediate Schedule Extraction (for the Report Template)
2. check if report is ready
3. extract the files, when report is complete

steven.peng

DSS REST doesn't provide Java Wrapper library like the REST C# library. However, there are Java examples demonstrate how to use HTTP requests. You can download the DSS Rest Java Code examples from DSS Rest Download tag and modify the extraction fields in the LegalEntityDetailReport examples.

.

nityanand.koppad

https://community.developers.refinitiv.com/discussion/comment/6506#Comment_6506

Thanks @steven.peng, but that also did not answer my question. Consider I have report template (lets say T&C with fields ISIN, CUSIP etc) ready on my DSS or created using Java in the past. Now this report I want use in ON DEMAND EXTRACTION for the any given instruments.

nityanand.koppad

Hi All,

Does anyone have solution for my question, this request came from client. If no solution then I can update back client accordingly.

Thanks, Nityanand

Christiaan Meihsl

https://community.developers.refinitiv.com/discussion/comment/6552#Comment_6552

This sample was added to the Java code sample package today (available under the downloads tab).

Christiaan Meihsl

https://community.developers.refinitiv.com/discussion/comment/6574#Comment_6574

The sample under the downloads tab has been updated today.

Christiaan Meihsl

https://community.developers.refinitiv.com/discussion/comment/6552#Comment_6552

Note: to create a schedule you need the instrumentListId and reportTemplateId. Code referring to manually created instrument list & report template can retrieve their respective IDs by name. See separate response for the coding details.

Christiaan Meihsl

Additional details to Susana's answer:

To create a schedule you need the instrumentListId and reportTemplateId. Code referring to manually created instrument list "myInstrumentListName" & report template "myReportTemplateName" can easily retrieve the respective IDs by name. See how to below (Java, HTTP REST and C#).

Java: see attached code (it is Susana's code with 2 added methods).

HTTP REST:

HTTP GET request by Instrument List name:

https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/InstrumentListGetByName(ListName='myInstrumentListName')

HTTP response:

Location: https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/InstrumentLists('')
{
	"@odata.context": "https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#InstrumentLists/$entity",
	"ListId": "0x054a3d8c310afc5b",
	"Name": "myInstrumentListName",
	... (etc.)
}

HTTP GET request by Report Template name:

https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/ReportTemplateGetByName(Name='myReportTemplateName')

HTTP response:

{
	"@odata.context": "https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#ReportTemplates/ThomsonReuters.Dss.Api.Extractions.ReportTemplates.EndOfDayPricingReportTemplate/$entity",
	"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ReportTemplates.EndOfDayPricingReportTemplate",
	"ReportTemplateId": "0x054a3dc609e52703",
	... (etc.)
}<br>

C# using the .Net SDK:

myInstrumentList = extractionsContext.InstrumentListOperations.GetByName("myInstrumentListName");
myInstrumentListId = myInstrumentList.ListId;

myReportTemplate = extractionsContext.ReportTemplateOperations.GetByName("myReportTemplateName");
myReportTemplateId = myReportTemplate.ReportTemplateId;<br>