On demand extraction via HTTP requests with list and template ids?

Is there a way to perform an on demand extraction - via HTTP request - without
explicitly write both instruments and fields (template) lists? Ideally, we would like to perform on demand extractions passing a list id and a report template id at the request.
Best Answer
-
This example should help. Unfortunately we do not have any examples on the help site for this feature.
{
"ExtractionRequest":{
"@odata.type":"#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.FundAllocationExtractionRequest",
"ContentFieldNames":[ "FundSERVDO","FundSERVFE","FundSERVIS"],
"IdentifierList":{
"@odata.type":"#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentListIdentifierList",
"InstrumentListId":"0x056354c268de2e3f"
},
"Condition":{
"FundAllocationTypes":[ "Currency","IndustrySector","InvestmentCountry"]
}
}
}0
Answers
-
I don't believe this is possible via an on demand extraction. But you could create a report template (or use an existing one), and then schedule an immediate extraction (this requires the instrument list Id and the report template id). This is explained in detail in REST API Tutorial 8.
0 -
A little color commentary...
The reason for this is that On Demand is intended to be "an extraction in isolation" aka transactional. There is no persistence of any kind beyond the call to make it wholly self-contained.
One word of caution: Running immediate extractions means that the client should not modify or delete either the instrument list or the report template until all immediate extractions referencing them are complete.
0 -
Correction: I now understand that On Demand will support referencing stored lists - you need to use a InstrumentListIdentifierList in place of a InstrumentIdentifierList in your call.
My cautionary comments apply.
0 -
I was not aware of this feature. This is good to know !
0 -
Tested it and it indeed works, many thanks! I assume I can include a report template id in an homologous way to the included list id at the example?
0 -
The REST API does not provide data
formatting like a scheduled extraction, and so there is a lot of
information in a Report Template that would not be put into play, which
may be confusing to some users. What would be needed is a means to say
GetFieldNamesFromReportTemplate(id).There are 2 options: Fetch your stored RT and then
enumerate the field list into the On Demand extraction, or, use an
existing list and template with an immediate extraction. The first option does cause the wire transfer of the template each time,
and the second on only returns the results via a formatted file.0 -
A new REST API tutorial 7 illustrating the use of an existing instrument list has been created.
0
Categories
- All Categories
- 3 Polls
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 685 Datastream
- 1.4K DSS
- 620 Eikon COM
- 5.2K Eikon Data APIs
- 10 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 254 ETA
- 557 WebSocket API
- 38 FX Venues
- 14 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 23 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 276 Open PermID
- 44 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 22 RDMS
- 1.9K Refinitiv Data Platform
- 662 Refinitiv Data Platform Libraries
- 4 LSEG Due Diligence
- LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 27 DACS Station
- 121 Open DACS
- 1.1K RFA
- 104 UPA
- 193 TREP Infrastructure
- 229 TRKD
- 917 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 90 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 46 中文论坛