Example queries using "OR" and "AND" in discovery/symbology/v1/lookup API

dragan.vasic
dragan.vasic
in Refinitiv Data Platform

Hi Refinitiv team,
I cannot find examples for usage of "OR" or "AND" in symbology/lookup API. Can we have some examples of how to construct a query using the "OR" or "AND" operator (symbology_user_guide.pdf, page 14).
What I try to accomplish is the same as what I get with this PermID request:
">https://api-eit.refinitiv.com/permid/search?entityType=quote&q=ticker:CRG%20AND%20mic:XDUB&format=json&num=100&access-token=<TOKEN>
, that is to be able to send ticker (ExchangeTicker) and Exchange MIC in lookup request and get RIC as an answer.

Tagged:

Best Answer

  • divya.pratap1
    divya.pratap1
    Answer ✓

    Hi dragan.vasic

    A typical 'AND' (intersection) query in this case would have been: AND [ticker -to- Ric + Mic -to- Ric].

    However we are currently restricting Mic to Ric queries because they are too broad.

    So we could use the following two queries in this case : (1) A pre-defined AND query from ticker + mic to Org (2) We then use this org id to navigate from Org to its Ric using an auto query

    These are the queries below:

    Query 1

    {

    "from": [

    {

    "values": [

    {

    "ExchangeTicker": "CRG",

    "Mic": "XDUB"

    }

    ]

    }

    ],

    "type": "predefined",

    "route": "ExchangeTickerMicToOrganization"

    }


    Query 2


    {

    "from": [

    {

    "identifierTypes": ["Permid"],

    "objectTypes": ["Organization"],

    "values": ["4295874867"]

    }

    ],

    "type": "auto",

    "to": [

    {

    "identifierTypes": ["ric"]

    }

    ]

    }




    Does this help?

Categories