DSS Rest API request/response

Hi,

Please provide an example of the DSS Rest API request/response results for the attached list of instruments. I can access the data via teh GUI but struggling to get it via the API.

Thanks

image

Best Answer

  • @preshan.govinder,

    Thanks to your report template I now see you want to retrieve an intraday price snapshot.

    Getting the bid and ask prices for your list of RICs in the screenshot

    This request body delivers the bid and ask price for all RICs in capture1.jpg:

    {
    "ExtractionRequest": {
    "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.IntradayPricingExtractionRequest",
    "ContentFieldNames": [
    "RIC", "Ask Price", "Bid Price", "Currency Code", "Exchange Code",
    "Instrument ID", "Instrument ID Type", "Trade Date", "Volume"
    ],
    "IdentifierList": {
    "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
    "InstrumentIdentifiers": [
    { "Identifier": "XS1452710962=BARL", "IdentifierType": "Ric" },
    { "Identifier": "XS1452800797=BARL", "IdentifierType": "Ric" },
    { "Identifier": "XS1452801175=BARL", "IdentifierType": "Ric" },
    { "Identifier": "XS1471949195=BARL", "IdentifierType": "Ric" },
    { "Identifier": "XS1471949864=BARL", "IdentifierType": "Ric" },
    { "Identifier": "XS1471975430=BARL", "IdentifierType": "Ric" },
    { "Identifier": "XS1471993763=BARL", "IdentifierType": "Ric" },
    { "Identifier": "XS1511977875=BARL", "IdentifierType": "Ric" },
    { "Identifier": "XS1511977958=BARL", "IdentifierType": "Ric" }
    ],
    "ValidationOptions": { "AllowOpenAccessInstruments": true }
    },
    "Condition": { "ScalableCurrency": true }
    }
    }

    Note that I specified a validation option:

          "ValidationOptions": { "AllowOpenAccessInstruments": true }

    If you set that to false (or do not set it) then you get a "Not Found" error for all these instruments.

    I am not a data specialist, I cannot explain why these RICs qualify as Open Access instruments. For data content query like this one, the best and speediest way to receive an answer is to open a content-related enquiry via My Account or to call the Thomson Reuters Help Desk directly.

    ISIN XS1068108932

    I tried changing the instrument list in the query above, to test the RICs you listed:

          	{ "Identifier": "XS1068108932=BARL", "IdentifierType": "Ric" },
    { "Identifier": "XS1068108932", "IdentifierType": "Ric" },
    { "Identifier": "GB106810893=BARL", "IdentifierType": "Ric" },
    { "Identifier": "GB106810893=", "IdentifierType": "Ric" },
    { "Identifier": "XS1068108932", "IdentifierType": "Isin" }

    Results:

    • RIC XS1068108932=BARL: prices are delivered.
    • RIC XS1068108932: not found
    • RICs GB106810893=BARL and GB106810893=: null prices.
    • ISIN XS1068108932: null prices.

    I did a search for RICs corresponding to ISIN XS1068108932, it delivers the 2 RICs you mention, the 3rd result is the ISIN itself, not a RIC:

    image

    That is why RIC XS1068108932 is not found.

    I cannot tell you why the search for RIC XS1068108932=BARL returned the message "No securities found.". For that, and to understand why some of these instruments have null prices, please open a content-related enquiry via My Account or call the Thomson Reuters Help Desk directly.

    Note: converting ISINs to RICs can be tricky. I suggest you read this article, it should help you understand what API calls and searches you can use, depending on your use case.

    Side note

    Please try to start a new thread for each new query (without duplicating queries), that will help everyone find related things.

Answers