Using RDP API Playground. I thought this might work but alas RIC is not an acceptable parameter:
"View": "Quotes",
"Query": "CERTIFICATE OF DEPOSIT",
"Top": 10000,
"RIC": "%US%",
"Skip": 0
Thanks in advance
Jason
Using RDP API Playground. I thought this might work but alas RIC is not an acceptable parameter:
"View": "Quotes",
"Query": "CERTIFICATE OF DEPOSIT",
"Top": 10000,
"RIC": "%US%",
"Skip": 0
Thanks in advance
Jason
Thanks for reaching out to us.
Yes, RIC is not a valid parameter. You can use it in the Filter, as shown below.
{ "View": "Quotes", "Query": "CERTIFICATE OF DEPOSIT", "Select": "DocumentTitle, RIC,BusinessEntity,RCSIssuerCountry,RCSIssuerCountryName", "Filter": "startswith(RIC,'US')" }
Otherwise, you can try the following query.
{ "View": "Quotes", "Query": "CERTIFICATE OF DEPOSIT", "Select": "DocumentTitle, RIC,BusinessEntity,RCSIssuerCountry,RCSIssuerCountryName,RCSCurrency,RCSCurrencyName", "Filter": "RCSIssuerCountry eq 'G:6J' and RCSCurrency eq 'C:6'" }
You can use the https://api.refinitiv.com/discovery/search/v1/metadata/views/Quotes to get the list of properties in the Quotes view.
Moreover, you can refer to the Reference tab regarding how to use this endpoint.
I hope that this information is of help.
Hi @jason.koulouras ,
Regarding to my colleague's comment, you can use Eikon Advanced Search to form the JSON request body (Click Export Query and select JSON tab) as demonstrated in article Find content and functionality using Refinitiv Data Library with Eikon Advanced Search