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
3
●0 ●0 ●3
How would I find all RICS with Certificate of Deposit filtered to USD issued currency and country of issuer the United States (I would like to use RDP API, not Eikon AS) Thanks
78.6k
●248 ●52 ●74
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.
Thank yuo - helpful - now I need to go workout some approaches - appreciate the fast assistance!
14.1k
●30 ●5 ●10
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
Thanks Raksina for the elaboration and the pointer to your elaboration, if I wanted to dig into this using Eikon to reverse out the search, is that something I would connect with you for via my Account Team? Thank you
