Using web scripting API (python), output data is incomplete

Johann Lourens

Eikon Web Scripting API (Python) code:

df, err = ek.get_data(['SCREEN(U(IN(Equity(active,public,primary,countryprimaryquote))), IN(TR.ExchangeCountryCode,''ZA'')),CFRJ.J'], ['TR.PrimaryRIC']).

Does not pull PrimaryRIC for every ticker in screen. Majority are missed out. I am expecting 416 primary RICs, but only getting roughly 190. It is consistent in the Primary RICs that are not populated. What is happening?

I do not want use to pull TR.PrimaryRICCode or TR.PrimaryQuote. I specifically have to pull data for TR.PrimaryRIC.

Using equivalent query in Excel API yields all 416 Primary RICS which means the data is available.

=TR("SCREEN(U(IN(Equity(active,public,primary,countryprimaryquote))), IN(TR.ExchangeCountryCode,""ZA"")),CFRJ.J","TR.PrimaryRIC")

Alex Putkov.1

I'm afraid I'm not reproducing this. I just tried executing your request and I got 416 RICs as expected. The same number as returned by =TR function in Excel. It seems to me that the issue you reported earlier on a separate thread has been fixed. Can you try again?

Johann Lourens

https://community.developers.refinitiv.com/discussion/comment/21966#Comment_21966

Alex Putkov.1

Dec 7, 2017

I'm afraid I'm not reproducing this. I just tried executing your request and I got 416 RICs as expected. The same number as returned by =TR function in Excel. It seems to me that the issue you reported earlier on a separate thread has been fixed. Can you try again?

Hi Alex. Thanks. I agree, it is working for me as well. Not clear why it stopped though. was not working 4 to 7 Dec