Downloading MBO, MM data with custonized set of columns

Ayan
Ayan Contributor

We want to download MBO/MM data for given column names only. Please help.

Best Answer

  • Ayan
    Ayan Contributor
    Answer ✓

    query:

    curl -vk -X POST -H "Content-Type: application/json" -H "Prefer: respond-async" -H "Authorization: Token xxxx" 'https://10.192.6.221/RestApi/v1/Extractions/ExtractRaw' -d @AllRICSFile.txt

    content of AllRICSFile.txt:

    @{ "ExtractionRequest": {"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.TickHistoryMarketDepthExtractionRequest","ContentFieldNames": ["TRD_STATUS","BOOK_STATE","CURRENCY","DSPLY_NAME","MNEMONIC","ACTIV_DATE","TIMACT_MS","ORDER_SIZE","ORDER_PRC","ORDER_SIDE","OR_UDT_RSN","ORDER_TONE","PR_TIM_MS","PR_DATE","PR_TIM_MSP","OR_TIM_MS","OR_TIM_MSP","OR_DATE","QUOTIM_MS","ORDER_ID" ], "IdentifierList": {"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList","InstrumentIdentifiers": [ {"@odata.type": "#ThomsonReuters.Dss.Api.Search.HistoricalSearchResult","Identifier": "0001100000C8.HK","IdentifierType": "Ric"}, {"@odata.type": "#ThomsonReuters.Dss.Api.Search.HistoricalSearchResult","Identifier": "0001100000F8.HK","IdentifierType": "Ric"}, {"@odata.type": "#ThomsonReuters.Dss.Api.Search.HistoricalSearchResult","Identifier": "0001100000H7.HK","IdentifierType": "Ric"}, {"@odata.type": "#ThomsonReuters.Dss.Api.Search.HistoricalSearchResult","Identifier": "0001100000I7.HK","IdentifierType": "Ric"}, {"@odata.type": "#ThomsonReuters.Dss.Api.Search.HistoricalSearchResult","Identifier": "0001100000J7.HK","IdentifierType": "Ric"} ],"ValidationOptions":{"AllowHistoricalInstruments":true}},"Condition":{"View": "RawMarketByOrder","MessageTimeStampIn": "GmtUtc","ReportDateRangeType": "Range","QueryStartDate": "2017-08-18T00:00:00.000Z","QueryEndDate": "2017-08-18T23:59:59.000Z","DisplaySourceRIC": true}}}

    Response:

    HTTP/1.1 400 Bad Request

Answers