Client have the problem with LSEG-data API, The Eikon API has worked very well with no problems

shivananda.panegaon

Please find the below Client query, kindly look into it the query please:
Query:

I have used the Eikon API for quite a few years now. I rewrote the code to use the LSEG-data API.

- The Eikon API has worked very well with no problems

- The LSEG-data API has problems.

The following code works when configured for the Eikon API worked fine. Configured for LSEG-data causes problems. It is not the code, it is the LSEG-data API that is not behaving correctly.

df = ld.get_data( universe=['BP.L',"GM.N",'F.N','STLAM.MI','JPM.N','META.OQ','HD.N','VOWG.DE', 'MCK.N', 'SHEL.L', 'COST.OQ'],

fields = ['TR.RICCode','TR.OrganizationID','TR.CommonName','TR.IR.RatingSourceCode','TR.IR.RatingScopeDescription','TR.IR.RatingSourceDescription','TR.IR.Rating','TR.IR.RatingDate','TR.IO.Outlook','TR.IO.OutlookDate',' TR.IO.OutlookEndDate','TR.IW.WatchType','TR.IW.WatchTypeDescription','TR.IW.WatchDate','TR.IW.WatchEndDate','TR.IR.VerifiedDate','TR.IR.RatingEndorsement'],

parameters = {'IssuerRatingSrc':'DIS', 'IssuerWatchSrc':'DIS' ,'IssuerOutlookSrc':'DIS', 'RatingScope':'DMS', 'Null':'Blank'})

df.to_csv(rf'C:\Data_aaPython\Paul_Test_Credit Dominion_2.txt', header=True, sep='\t', index=False)

print (df)

The ‘TR.IO.OutlookEndDate’ column of data is shifted to the last column rather than being positioned after ‘TR.IO.OutlookDate’. As a result, all the columns after ‘TR.IO.OutlookDate’ are in the wrong position creating a problem for the code that is looking for specific data. This does not happen with the Eikon API.

Jirapongse

@shivananda.panegaon

Thank you for reaching out to us.

I think it relates to a space character in the ' TR.IO.OutlookEndDate' field.

If I remove it ('TR.IO.OutlookEndDate'), the data will return properly.

df = ld.get_data( 
    universe=['BP.L',"GM.N",'F.N','STLAM.MI','JPM.N','META.OQ','HD.N','VOWG.DE', 'MCK.N', 'SHEL.L', 'COST.OQ'],
    fields = [
        'TR.RICCode',
        'TR.OrganizationID',
        'TR.CommonName',
        'TR.IR.RatingSourceCode',
        'TR.IR.RatingScopeDescription',
        'TR.IR.RatingSourceDescription',
        'TR.IR.Rating',
        'TR.IR.RatingDate',
        'TR.IO.Outlook',
        'TR.IO.OutlookDate',
        'TR.IO.OutlookEndDate',
        'TR.IW.WatchType',
        'TR.IW.WatchTypeDescription',
        'TR.IW.WatchDate',
        'TR.IW.WatchEndDate',
        'TR.IR.VerifiedDate',
        'TR.IR.RatingEndorsement'],
    parameters = {'IssuerRatingSrc':'DIS', 'IssuerWatchSrc':'DIS' ,'IssuerOutlookSrc':'DIS', 'RatingScope':'DMS', 'Null':'Blank'})


df