How to get the RowCount as Header part of the endofday extract using DSS Select

prachand2

@ Christiaan Meihsl,

We are using DSS Select REST API to extract endofday data .Using below endpoint
https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/Extract.


Providing the REST body as :
{
"ExtractionRequest": {
"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.ElektronTimeseriesExtractionRequest",
"ContentFieldNames": ${market_fields},
"IdentifierList": {
"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentListIdentifierList",
"InstrumentListId": ${market_instrument_list_id}
},
"Condition": {
"StartDate": "{startDate}",
"EndDate": "{endDate}"
}
}
}

Providing market_fields and market_instrument_list_id as list .

In a different thread I got to know its possible to get the total RowCount of extract as Header in the response itself, could you help me how shall I get that programmatically (Any parameters to add/update in above REST body ? ) I want to test this using POSTMAN. We have been using python application which we migrated to scala one.

Many Thanks

Christiaan Meihsl

@prachand2,

I'm sorry to say that is not possible. The Header/Footer functionality that delivers the RowCount is not available for the 4 Tick History extractions (ElektronTimeseriesExtractionRequest is one of them), it is only available for templates defined for scheduled DSS extractions, as discussed in this separate thread.

As a side note, I recommend you do not use the Extract end point, and replace it with the ExtractWithNotes endpoint. The Extract end point is being deprecated, as explained here.

prachand2

https://community.developers.refinitiv.com/discussion/comment/40887#Comment_40887

Thank You We will be updating the extract endpoint.

Christiaan Meihsl

@prachand2,

Actually, that feature it is only available for DSS templates used in scheduled requests.

The request you describe above is a TRTH request that uses the On Demand workflow (which does not use a template).

DSS and TRTH are 2 separate products that both use the same servers, hence some confusion.

Scheduled versus On Demand extractions are described here.

So just to be quite clear I confirm it is not available for your TickHistoryTimeAndSalesExtractionRequest described above.