-
Pagination
I am using LSEG library in Python. I was able to identify first 10,000 observation of any data set I want to obtain (e.g. VC investments, M&A deals). However, I cannot do pagination meaning going through data coming after 10,000th row. I tried to use skip + top, it gives skip + top cannot exceed 10,000 error. I tried…
-
RDP instrument search and Entitlements
We pull instruments using these following queries from RDP /search api. curl --location "https://api.refinitiv.com/search/beta1/" --header "content-type: application/json" -H "Authorization: Bearer ....” --data "{ \"View\": \"SearchAll\", \"Filter\": \"RIC eq 'MNI50500J5'\", \"Select\": \"RIC, RicRoot,…
-
Do we have RDP Search Java library
We are utilizing RDP search api from our Java backend services to get Options contract list. We are making simple WebClient calls to get this information. Are there any JAVA RDP search libraries which we could use for this purpose(like making the RDP connection, deserializing the search response to mapper objects etc?) ?
-
DISCREPANCY BETWEEN SEARCH VIA WORKSPACE APPLICATION AND VIA API
I'm searching for the company tree of some company. these company are subsidiaries and by downloading the tree excel from the workspace application, it is possible to see what level and who they are under. However, if the same thing is done with python starting with the ultimate parent these companies do not come up. Has…
-
Search function operators
I'm searching for the search function operators (ex.: 'eq') mentioned in this article https://developers.lseg.com/en/article-catalog/article/building-search-into-your-application-workflow. The article links to a documentation that I don't have access to, despite having the search function. Thanks in advance for your help.
-
retrieve bonds based on codes
Hello all, I am trying to retrieve all bonds for a list of issuers and i found in this forum a way of doing, however when i implemented it for some stocks i get an error based on the stocks name (see image below) what leads to an incomplete list of bonds. My question is if there is any alternative to retrieve bonds based…
-
Getting Best Match via Entity Search API
Hi, Please see my code below my sanctions_df_upgrade has a column caption which are company names. I am looping over that column and mapping it against the PermID db via the Entity Search API My ask is - now I am assuming that the first match found with the parameter num set to 1 is the best match. But is there a better…
-
How to map entity names to identifiers?
Hi, I have used the OpenSanctions API /search endpoint and retrieved results of entities under the UFLPA dataset My next task is to map these entities to permIDs (if available) The entities retrieved from the API call are API native fields and names of companies. I want to map the names to permIDs Please can someone guide…
-
Query export not working to build query string
I am trying to export a search query in Eikon, and the fields I choose are: However, the code provided by the Export Query does not contain the fields I added. So my questions are: 1. Why are the user-added fields not in the Export Query screen on Workspace? 2. Could you tell me the correct field for all the variables I…
-
Search API not case sensitive
Dear Developer Community i'm sharing with you an issue facing with Search API. Indeed, using Sraech API, i want to find Options matching criteria below (given for example purpose): - ExpiryDate:15/11/2024 - StrikePrice: 5200 - Ric starts with SPXw the issue is that the Search Module (and also Search API) is not case…
-
Tick History - Criteria Search - Pull all RICs starting with 0#
Hello, I am trying to extract all Chains for given exchange using criteria search but keep getting error. What am i missing in the code? Request: https://selectapi.datascope.refinitiv.com/RestApi/v1/Search/HistoricalCriteriaSearch HTTP/1.1?Prefer=respond-async&Content-Type=application/json { "Request": { "RicPattern":…
-
Different execution result between codebook and python API
Good morning, I'm using the refintiv.data api to query some bond data. In the codebook I'm running rd.discovery.search( filter = f"RIC eq '458140BP4=RRPS'", select = "MaturityDate" ) this runs without issues and gives me the maturity date. However when i copy paste the same thing in my code editor, i get ValueError…
-
Euro-Bund RIC Code Searchlight API
Hi all, I am trying to obtain euro-bund future RIC code and access to its data using Searchlight API. I have try with: * "Query": "euro-bund futures" * "Filter": "RIC eq ''FGBLZ4'" * "Filter": "startswith(RIC , 'FGBL')" And many others. Is there an easy way to obtain the RIC Code for a product? Sorry in advance if I have…
-
How to Efficiently Retrieve TR.PrimaryInstrument for Delisted Equities?
Hello everyone, I'm currently working on a project where I retrieve RICs and PrimaryRICs for a set of ordinary shares from various global markets using the Refinitiv Research API (EQUITY_QUOTES) through codebook. Then I use the PrimaryRICs to gather fundamental data for these companies. However, I've encountered a problem…
-
Retrieve RIC codes from ISIN and Exchange in instrument search
I am currently working on retrieving RICs for instruments using the Refinitiv API, given an ISIN and exchange. I am using the endpoint: https://selectapi.datascope.refinitiv.com/RestApi/v1/Search/InstrumentSearch. My goal is to obtain the specific RIC for a given exchange and ISIN from the search results. For example, I am…
