MBO file download issue continues

Ayan

curl -k -X GET -H "Content-Type: application/json" -H "Prefer: respond-async" -H "Authorization: Token xxxxxxxxxxxxxxxxxx" https://10.192.6.221/RestApi/v1/Extractions/RawExtractionResults('0x05d3eddcecab2f86')/$value -o IUS-2017-08-07-MBO-Data.csv.gz

Though the response code is 200 it is not downloading any data from TRTH server. Please help.

veerapath.rungruengrayubkul

@Ayan

According to the note information you provided, the "Report
suppressed because there are no instruments" message implies that there is no valid instrument for this extraction request, so there is no data generated.

All instruments you uses should be in MarketByPrice, not MarketByOrder. The result of "HistoricalSearch" on the RICs (i.e. 1CC1200I7) shows that they are available in DomainCode: 6 (MarketPrice) and 8 (MarketByPrice) only. There is no DomainCode: 7 (MarketByOrder).

Below is the result of "HistoricalSearch" endpoint.

Request message:

POST https://hosted.datascopeapi.reuters.com/RestApi/v1/Search/HistoricalSearch

{
	"Request":
    	{
		"Identifier": "1CC1200I7",
		"IdentifierType":"Ric",
		"Range":
		{
			"Start":"2017-08-03T00:00:00.000Z",
			"End":"2017-08-03T23:59:59.000Z"
		}
}
}

Response message:

{
  "@odata.context": "http://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#Collection(ThomsonReuters.Dss.Api.Search.HistoricalSearchResult)",
  "value": [
  {
  "Identifier": "1CC1200I7",
  "IdentifierType": "Ric",
  "Source": "",
  "Key": "VjF8MHgzMDAwMDAwMDAwMDAwMDAwfDB4MzAwMDAwMDAwMDAwMDAwMHx8fHx8fHwxQ0MxMjAwSTd8",
  "Description": "Historical Instrument",
  "InstrumentType": "Unknown",
  "Status": "Valid",
  "DomainCode": "6",
  "FirstDate": "2017-06-26T00:00:00.000Z",
  "LastDate": "2017-08-07T00:00:00.000Z",
  "History": []
  },
  {
  "Identifier": "1CC1200I7",
  "IdentifierType": "Ric",
  "Source": "",
  "Key": "VjF8MHgzMDAwMDAwMDAwMDAwMDAwfDB4MzAwMDAwMDAwMDAwMDAwMHx8fHx8fHwxQ0MxMjAwSTd8",
  "Description": "Historical Instrument",
  "InstrumentType": "Unknown",
  "Status": "Valid",
  "DomainCode": "8",
  "FirstDate": "2017-06-26T00:00:00.000Z",
  "LastDate": "2017-08-07T00:00:00.000Z",
  "History": []
  }
  ]
}

So, you may need to find other RICs for MarketByOrder data.

For these RIC, if you change the "View" type of the request to "RawMarketByPrice" instead of "RawMarketByOrder". You can receive MarketByPrice data for these RICs. Below is the modified version of your request message.

@{ "ExtractionRequest": {"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.TickHistoryMarketDepthExtractionRequest",    "IdentifierList": {"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList","InstrumentIdentifiers": [
@{"@odata.type": "#ThomsonReuters.Dss.Api.Search.HistoricalSearchResult","Identifier": "1CC1200I7","IdentifierType": "Ric"},
@{"@odata.type": "#ThomsonReuters.Dss.Api.Search.HistoricalSearchResult","Identifier": "1CC1200J7","IdentifierType": "Ric"},
@{"@odata.type": "#ThomsonReuters.Dss.Api.Search.HistoricalSearchResult","Identifier": "1CC1200K7","IdentifierType": "Ric"},
@{"@odata.type": "#ThomsonReuters.Dss.Api.Search.HistoricalSearchResult","Identifier": "1CC1200L7","IdentifierType": "Ric"},
@{"@odata.type": "#ThomsonReuters.Dss.Api.Search.HistoricalSearchResult","Identifier": "1CC1200U7","IdentifierType": "Ric"},
@{"@odata.type": "#ThomsonReuters.Dss.Api.Search.HistoricalSearchResult","Identifier": "1CC1200V7","IdentifierType": "Ric"},
@{"@odata.type": "#ThomsonReuters.Dss.Api.Search.HistoricalSearchResult","Identifier": "1CC1200W7","IdentifierType": "Ric"},
@{"@odata.type": "#ThomsonReuters.Dss.Api.Search.HistoricalSearchResult","Identifier": "1CC1200X7","IdentifierType": "Ric"},
@{"@odata.type": "#ThomsonReuters.Dss.Api.Search.HistoricalSearchResult","Identifier": "1CC1250C8","IdentifierType": "Ric"},
@{"@odata.type": "#ThomsonReuters.Dss.Api.Search.HistoricalSearchResult","Identifier": "1CC1250E8","IdentifierType": "Ric"},
@{"@odata.type": "#ThomsonReuters.Dss.Api.Search.HistoricalSearchResult","Identifier": "1CC1250G8","IdentifierType": "Ric"},
@{"@odata.type": "#ThomsonReuters.Dss.Api.Search.HistoricalSearchResult","Identifier": "1CC1250I7","IdentifierType": "Ric"},
@{"@odata.type": "#ThomsonReuters.Dss.Api.Search.HistoricalSearchResult","Identifier": "1CC1250J7","IdentifierType": "Ric"},
@{"@odata.type": "#ThomsonReuters.Dss.Api.Search.HistoricalSearchResult","Identifier": "1CC1250K7","IdentifierType": "Ric"},
@{"@odata.type": "#ThomsonReuters.Dss.Api.Search.HistoricalSearchResult","Identifier": "1CC1250L7","IdentifierType": "Ric"},
@{"@odata.type": "#ThomsonReuters.Dss.Api.Search.HistoricalSearchResult","Identifier": "1CC1250O8","IdentifierType": "Ric"},
@{"@odata.type": "#ThomsonReuters.Dss.Api.Search.HistoricalSearchResult","Identifier": "1CC1250Q8","IdentifierType": "Ric"},
@{"@odata.type": "#ThomsonReuters.Dss.Api.Search.HistoricalSearchResult","Identifier": "1CC1250S8","IdentifierType": "Ric"},
@{"@odata.type": "#ThomsonReuters.Dss.Api.Search.HistoricalSearchResult","Identifier": "1CC1250U7","IdentifierType": "Ric"},
@{"@odata.type": "#ThomsonReuters.Dss.Api.Search.HistoricalSearchResult","Identifier": "1CC1250V7","IdentifierType": "Ric"}
],"ValidationOptions":{"AllowHistoricalInstruments":true}},"Condition":{"View": "RawMarketByPrice","MessageTimeStampIn": "GmtUtc","ReportDateRangeType": "Range","QueryStartDate": "2017-08-03T00:00:00.000Z","QueryEndDate": "2017-08-07T23:59:59.000Z","DisplaySourceRIC": true}}}