I'm currently facing a challenge with the following Excel code snippet:
=RDP.Search("EQUITY","IsPrimaryIssueRIC eq true and SearchAllCategoryv2 eq 'Equities' and RCSAssetCategoryGenealogy eq 'A:1L' and RCSIssuerCountryGenealogy eq 'M:DQ\\G:AM\\G:6J' and RCSExchangeCountryLeaf eq 'United States';query="&A2&"","NBROWS:1",,)
My aim is to retrieve around 1 million company names using the RDP.Search function. However, I'm concerned about hitting request limits or encountering inefficiencies in the process.
Could anyone provide insights or strategies on how to achieve this without running into limitations? I greatly appreciate any advice or experiences shared regarding this endeavor.