Eikon via Python Unable to Collect Data For Some Fields

hans-hermann.kiessig

Hi,

we are trying to retrieve Corporate Event data via the Python Eikon module and its get_data() function. Normally this works just fine. However, today we submitted a query which was answered successfully. After that we submitted the same query which received a partial answer. Some fields were empty and the following information was provided:

[{'code': 415, 'col': 1, 'message': 'Unable to collect data for some field(s).', 'row': 0}, {'code': 415, 'col': 2, 'message': 'Unable to collect data for some field(s).', 'row': 0}, {'code': 415, 'col': 11, 'message': 'Unable to collect data for some field(s).', 'row': 0}]

Example RIC : 'BLK.DE'

Can you please explain why that happens and how to resolve this issue?

Best regards,

Hans

Jirapongse

@hans-hermann.kiessig

I have removed the TR.CACorpEventType field and changed the value of the SDate parameter.

l = ['BLK.DE']

fields = [ 'TR.CACorpActEventType', 'TR.CACorpActDate', 'TR.EventType', 
          'TR.EventTitle', 'TR.EventStartDate', 'TR.EventStartTime', 
          'TR.EventEndTime', 'TR.EventStatus', 'TR.EventCountry', 
          'TR.EventLastUpdate', 'TR.DivEventStatus','EXDIVDATE', 
          'DIVPAYDATE', 'CF_YIELD', 'CF_CURR', 'TR.ISIN']

vals = {'SDate': '-1Y', 'EDate': '0AY'}

df_out, info = ek.get_data( l, fields, vals )

df_out

I got the following response.

I think this field TR.CACorpEventType is invalid.

jason.ramchandani01

@hans-hermann.kiessig Sorry to hear this please could you paste the API call code so we can try to replicate. thanks.

hans-hermann.kiessig

Hi,

here is our API call:

import eikon as ek

l = ['BLK.DE']

fields = ['TR.CACorpEventType', 'TR.CACorpActEventType', 'TR.CACorpActDate', 'TR.EventType', 'TR.EventTitle', 'TR.EventStartDate', 'TR.EventStartTime', 'TR.EventEndTime', 'TR.EventStatus', 'TR.EventCountry', 'TR.EventLastUpdate', 'TR.DivEventStatus', 'EXDIVDATE', 'DIVPAYDATE', 'CF_YIELD', 'CF_CURR', 'TR.ISIN']

vals = {'SDate': '1AW', 'EDate': '0AY'}

df_out, info = ek.get_data( l, fields, vals )

Best,

Hans

hans-hermann.kiessig

https://community.developers.refinitiv.com/discussion/comment/85942#Comment_85942

We have eikon version 1.1.12 and Python (Windows) version 3.8.3

hans-hermann.kiessig

https://community.developers.refinitiv.com/discussion/comment/85934#Comment_85934

Hi, have you seen my reply below?

wasin.w

Hello @hans-hermann.kiessig

I did a quick check with the Data Item Browser app ("DIB" in Eikon/Workspace) based on @Jirapongse answer, I cannot find the field TR.CACorpEventType too.

You can use the Data Item Browser app to verify the available fields of that item.