Workspace API returns NaT for some fields, but in Data Item Browser there is full value for these...

IoannisG

... fields

When using Workspace API in Python under Windows 10, some fields produce "NaT" results, but these fields have full values in Data Item Browser.

E.g. the Python command

df=rd.get_data(['MMM.N','BAG.L','AOS.N'], ['TR.ISUpdateType','TR.IsISFlashUpdated','TR.IsBSFlashUpdated','TR.IsCFFlashUpdated'], parameters={'NULL':'Blank'})

produces no results for the required fields.

How can one obtain the values for these fields in Python?

jason.ramchandani01

@IoannisG Thanks for your question - have you tried:

import refinitiv.data as rd
rd.open_session()

df=rd.get_data(['MMM.N','BAG.L','AOS.N'],
               ['TR.F.UpdateType(StType=INC)','TR.F.IsFlashUpdated(StType=INC)',
                'TR.F.UpdateType(StType=BAL)','TR.F.IsFlashUpdated(StType=BAL)',
                'TR.F.UpdateType(StType=CAS)','TR.F.IsFlashUpdated(StType=CAS)'],
               parameters={'Period':'FY0'},
               use_field_names_in_headers=True
              )
df

There are also more StTypes available - please see the Data Item Browser (type DIB into Eikon/WS Search bar) and search for 'Update Type' or 'Is Flash Updated' - on the right had pane - look at the parameter settings.

I hope this can help.