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.
3
●0 ●1 ●2
Example queries using "OR" and "AND" in discovery/symbology/v1/lookup API
21
●0 ●0 ●0
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?
