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

IoannisG
IoannisG Newcomer
in Eikon Data APIs

... 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?

Tagged:

Best Answer

  • jason.ramchandani01
    jason.ramchandani01 admin
    Answer ✓

    @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

    1717688156181.png

    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.

Categories