Another problem: sometimes, for some requests the server returns empty values. If I rerun the query for the symbol with missing data, I get a correct response.
This is an example of a relatively big query, so I will post only the logs:
Request with 100 RICs:
json = {'Entity': {'E': 'DataGrid_StandardAsync', 'W': {'requests': [{'instruments': ['ADM.N', 'ADNT.N', 'ADT.N', 'ADX.N', 'AEE.N', 'AEFC.N', 'AEG.N', 'AEM.N', 'AEO.N', 'AER.N', 'AES.N', 'AESI.N', 'AFB.N', 'AFG.N', 'AFGB.N', 'AFGC.N', 'AFGD.N', 'AFGE.N', 'AFL.N', 'AG.N', 'AGCO.N', 'AGD.N', 'AGI.N', 'AGL.N', 'AGM.N', 'AGM_pd.N', 'AGM_pe.N', 'AGM_pf.N', 'AGM_pg.N', 'AGMa.N', 'AGO.N', 'AGRO.N', 'AGS.N', 'AGX.N', 'AHH.N', 'AHH_pa.N', 'AHL_pd.N', 'AHL_pe.N', 'AHL_pf.N', 'AHM.N', 'AHR.N', 'AHT.N', 'AHT_pd.N', 'AHT_pf.N', 'AHT_pg.N', 'AHT_ph.N', 'AHT_pi.N', 'AI.N', 'AIFD.N', 'AIG.N', 'AIN.N', 'AIO.N', 'AIR.N', 'AIT.N', 'AIV.N', 'AIZ.N', 'AIZN.N', 'AJG.N', 'AKA.N', 'AKOa.N', 'AKOb.N', 'AKR.N', 'AL.N', 'ALB.N', 'ALB_pa.N', 'ALC.N', 'ALE.N', 'ALEX.N', 'ALG.N', 'ALIT.N', 'ALK.N', 'ALL.N', 'ALLE.N', 'ALLY.N', 'ALL_pb.N', 'ALL_ph.N', 'ALL_pi.N', 'ALL_pj.N', 'ALSN.N', 'ALTG.N', 'ALTG_pa.N', 'ALUR.N', 'ALUR_t.N', 'ALV.N', 'ALVU.N', 'ALX.N', 'AM.N', 'AMBC.N', 'AMBP.N', 'AMBP_t.N', 'AMC.N', 'AMCR.N', 'AME.N', 'AMG.N', 'AMH.N', 'AMH_pg.N', 'AMH_ph.N', 'AMN.N', 'AMP.N', 'AMPS.N'], 'fields': [{'name': 'TR.COMPANYMARKETCAP'}, {'name': 'TR.GICSINDUSTRYCODE'}, {'name': 'TR.GICSINDUSTRYGROUPCODE'}, {'name': 'TR.GICSSECTORCODE'}, {'name': 'TR.GICSSUBINDUSTRYCODE'}, {'name': 'TR.ISINCODE'}, {'name': 'TR.RICCODE'}, {'name': 'TR.SEDOLCODE'}], 'parameters': {'SDATE': '2025-04-10'}}]}}}
Response:
text = {"responses":[{"columnHeadersCount":1,"data":[["ADM.N",21357324468.48,302020,3020,30,30202010,"US0394831020","ADM.N","2047317"],["ADNT.N",888847218.87,251010,2510,25,25101010,"IE00BD845X29","ADNT.N","BD845X2"],["ADT.N",6513392980.34,253020,2530,25,25302020,"US00090Q1031","ADT.N","BFWCP81"],["ADX.N",2130413627.52,"","","","","US0062121043","ADX.N","2007203"],["AEE.N",26129649358.8,551030,5510,55,55103010,"US0236081024","AEE.N","2050832"],["AEFC.N","","","","","","US00775V1044","AEFC.N","BK59DD5"],["AEG.N",9437213424.20605,403010,4030,40,40301020,"","AEG.N",""],["AEM.N",55740962055.1193,151040,1510,15,15104030,"CA0084741085","AEM.N","2009834"],["AEO.N",1842450609.36,255040,2550,25,25504010,"","AEO.N",""],["AER.N",16879600043.25,201070,2010,20,20107010,"NL0000687663","AER.N","B1HHKD3"],["AES.N",7332575634.1,551050,5510,55,55105010,"US00130H1059","AES.N","2002479"],["AESI.N",1660890752.64,101010,1010,10,10101020,"US6420451089","AESI.N","BL6JGD2"],["AFB.N",284287417.04,"","","","","US01864U1060","AFB.N","2842783"],["AFG.N",10453536517.82,403010,4030,40,40301040,"US0259321042","AFG.N","2134532"],["AFGB.N",10453536517.82,403010,4030,40,40301040,"US0259328070","AFGB.N","BDFZ743"],["AFGC.N",10453536517.82,403010,4030,40,40301040,"US0259328807","AFGC.N","BJQY934"],["AFGD.N",10453536517.82,403010,4030,40,40301040,"US0259328724","AFGD.N","BMWJ1L6"],["AFGE.N",10453536517.82,403010,4030,40,40301040,"US0259328641","AFGE.N","BN76JV5"],["AFL.N",57135872328,403010,4030,40,40301020,"US0010551028","AFL.N","2026361"],["AG.N",2913147209.12017,151040,1510,15,15104045,"","AG.N",""],["AGCO.N",6258176794.74,201060,2010,20,20106015,"US0010841023","AGCO.N","2010278"],["AGD.N",223785729,"","","","","US00302M1062","AGD.N","BG1Z1K2"],["AGI.N",11683222829.9702,151040,1510,15,15104030,"CA0115321089","AGI.N","BYNBW45"],["AGL.N",2267666863,351020,3510,35,35102015,"","AGL.N",""],["AGM.N",1767533339.45,402010,4020,40,40201050,"","AGM.N",""],["AGM_pd.N",1767533339.45,402010,4020,40,40201050,"US3131488682","AGM_pd.N","BK6S6K9"],["AGM_pe.N",1767533339.45,402010,4020,40,40201050,"US3131488500","AGM_pe.N","BMZN5R9"],["AGM_pf.N",1767533339.45,402010,4020,40,40201050,"US3131488435","AGM_pf.N","BKY44P0"],["AGM_pg.N",1767533339.45,402010,4020,40,40201050,"US3131488351","AGM_pg.N","BMBQGR9"],["AGMa.N",1767533339.45,402010,4020,40,40201050,"","AGMa.N",""],["AGO.N",3992891546.16,403010,4030,40,40301040,"","AGO.N",""],["AGRO.N",1115255019.06,302020,3020,30,30202030,"","AGRO.N",""],["AGS.N",492213296.57,253010,2530,25,25301010,"","AGS.N",""],["AGX.N",1881521532,201030,2010,20,20103010,"","AGX.N",""],["AHH.N",660607097.64,601010,6010,60,60101010,"","AHH.N",""],["AHH_pa.N",660607097.64,601010,6010,60,60101010,"US04208T2078","AHH_pa.N","BK645V1"],["AHL_pd.N",275110000,403010,4030,40,40301040,"BMG053841620","AHL_pd.N","BD915N2"],["AHL_pe.N",275110000,403010,4030,40,40301040,"BMG053842040","AHL_pe.N","BKDJPD1"],["AHL_pf.N",null,403010,4030,40,40301040,"BMG053841703","AHL_pf.N","BS0CHC2"],["AHM.N",null,"","","","",null,null,null],["AHR.N",4563090943.2,601050,6010,60,60105010,"US3981823038","AHR.N","BQWNKQ4"],["AHT.N",33380465.26,601030,6010,60,60103010,"","AHT.N",""],["AHT_pd.N",33380465.26,601030,6010,60,60103010,"US0441034065","AHT_pd.N","B23NM25"],["AHT_pf.N",33380465.26,601030,6010,60,60103010,"US0441036045","AHT_pf.N","BZ77ZD6"],["AHT_pg.N",33380465.26,601030,6010,60,60103010,"US0441037035","AHT_pg.N","BYMPGX5"],["AHT_ph.N",33380465.26,601030,6010,60,60103010,"US0441038025","AHT_ph.N","BF2N6M5"],["AHT_pi.N",33380465.26,601030,6010,60,60103010,"US0441038850","AHT_pi.N","BZ7MMX0"],["AI.N",2694596056.6,451030,4510,45,45103010,"","AI.N",""],["AIFD.N",49763487.03,"","","","","US29287L5021","AIFD.N","BNZHS24"],["AIG.N",47489942091.75,403010,4030,40,40301040,"US0268747849","AIG.N","2027342"],["AIN.N",1962694583.1,201060,2010,20,20106020,"","AIN.N",""],["AIO.N",668280122.06,"","","","","US92838Y1001","AIO.N","BLBNHT2"],["AIR.N",1881008084.2,201010,2010,20,20101010,"","AIR.N",""],["AIT.N",8469092412.72,201070,2010,20,20107010,"US03820C1053","AIT.N","2086309"],["AIV.N",1064757405,601060,6010,60,60106010,"","AIV.N",""],["AIZ.N",9681186150.48,403010,4030,40,40301040,"US04621X1081","AIZ.N","2331430"],["AIZN.N",9681186150.48,403010,4030,40,40301040,"US04621X3061","AIZN.N","BLD4BS0"],["AJG.N",83297939707.44,403010,4030,40,40301010,"US3635761097","AJG.N","2359506"],["AKA.N",115592951.5,255040,2550,25,25504010,"US00152K2006","AKA.N","BKPJGF8"],["AKOa.N",2974417398.67333,302010,3020,30,30201030,"US29081P2048","AKOa.N","2299765"],["AKOb.N",2974417398.67333,302010,3020,30,30201030,"","AKOb.N",""],["AKR.N",2224183235.82,601070,6010,60,60107010,"","AKR.N",""],["AL.N",4550831977.2,201070,2010,20,20107010,"US00912X3026","AL.N","B3XS562"],["ALB.N",6436662575.28,151010,1510,15,15101050,"US0126531013","ALB.N","2046853"],["ALB_pa.N",6436662575.28,151010,1510,15,15101050,"US0126532003","ALB_pa.N","BPCTR42"],["ALC.N",43943009838.455,351010,3510,35,35101020,"CH0432492467","ALC.N","BJXBP41"],["ALE.N",3744927469.01,551010,5510,55,55101010,"","ALE.N",""],["ALEX.N",1163382624,601010,6010,60,60101010,"US0144911049","ALEX.N","B827VB2"],["ALG.N",2043533181.04,201060,2010,20,20106015,"US0113111076","ALG.N","2021634"],["ALIT.N",2710017253.7,202020,2020,20,20202010,"US01626W1018","ALIT.N","BNG7BZ7"],["ALK.N",5463681950.35,203020,2030,20,20302010,"US0116591092","ALK.N","2012605"],["ALL.N",50564319697.92,403010,4030,40,40301040,"US0200021014","ALL.N","2019952"],["ALLE.N",10534326050.08,201020,2010,20,20102010,"IE00BFRT3W74","ALLE.N","BFRT3W7"],["ALLY.N",9825255879.74,402020,4020,40,40202010,"US02005N1000","ALLY.N","B72XK05"],["ALL_pb.N",null,403010,4030,40,40301040,"US0200023093","ALL_pb.N","B87XV26"],["ALL_ph.N",50564319697.92,403010,4030,40,40301040,"US0200028381","ALL_ph.N","BKDKS91"],["ALL_pi.N",50564319697.92,403010,4030,40,40301040,"US0200028126","ALL_pi.N","BK727P2"],["ALL_pj.N",null,403010,4030,40,40301040,"US0200027888","ALL_pj.N","BNBXR41"],["ALSN.N",7553604575.99,201060,2010,20,20106010,"US01973R1014","ALSN.N","B4PZ892"],["ALTG.N",140639473.2,201070,2010,20,20107010,"","ALTG.N",""],["ALTG_pa.N",140639473.2,201070,2010,20,20107010,"US02128L2051","ALTG_pa.N","BMFQ222"],["ALUR.N",14073975.64,253020,2530,25,25302020,"US02008G2012","ALUR.N","BR84PL8"],["ALUR_t.N","",253020,2530,25,25302020,"US02008G1105","ALUR_t.N","BPJJT49"],["ALV.N",6161254885.4,251010,2510,25,25101010,"US0528001094","ALV.N","2064253"],["ALVU.N",null,"","","","",null,null,null],["ALX.N",1017831824.1,601070,6010,60,60107010,"","ALX.N",""],["AM.N",7600263280,101020,1010,10,10102040,"","AM.N",""],["AMBC.N",302886292.1,403010,4030,40,40301040,"","AMBC.N",""],["AMBP.N",1571949911.18,151030,1510,15,15103010,"LU2369833749","AMBP.N","BMWT6B1"],["AMBP_t.N","",151030,1510,15,15103010,"LU2369834044","AMBP_t.N","BMWT699"],["AMC.N",1261293416,502020,5020,50,50202010,"","AMC.N",""],["AMCR.N",13036995772.24,151030,1510,15,15103020,"JE00BJ1F3079","AMCR.N","BJ1F307"],["AME.N",36324178572.2,201040,2010,20,20104010,"US0311001004","AME.N","2089212"],["AMG.N",4491829359.42,402030,4020,40,40203010,"US0082521081","AMG.N","2127899"],["AMH.N",12711301130.64,601060,6010,60,60106020,"US02665T3068","AMH.N","BCF5RR9"],["AMH_pg.N",12711301130.64,601060,6010,60,60106020,"US02665T8760","AMH_pg.N","BDFG5B9"],["AMH_ph.N",12711301130.64,601060,6010,60,60106020,"US02665T8687","AMH_ph.N","BFY78Q3"],["AMN.N",734980525.24,351020,3510,35,35102015,"US0017441017","AMN.N","2813552"],["AMP.N",43740987193.12,402030,4020,40,40203010,"US03076C1062","AMP.N","B0J7D57"],["AMPS.N",804477041.56,551050,5510,55,55105020,"","AMPS.N",""]],"error":[{"code":416,"col":1,"message":"Unable to collect data for the field 'TR.CompanyMarketCap' and some specific identifier(s).","row":38},{"code":416,"col":1,"message":"Unable to collect data for the field 'TR.CompanyMarketCap' and some specific identifier(s).","row":39},{"code":416,"col":6,"message":"Unable to collect data for the field 'TR.ISINCode' and some specific identifier(s).","row":39},{"code":416,"col":7,"message":"Unable to collect data for the field 'TR.RICCode' and some specific identifier(s).","row":39},{"code":416,"col":8,"message":"Unable to collect data for the field 'TR.SEDOLCode' and some specific identifier(s).","row":39},{"code":416,"col":1,"message":"Unable to collect data for the field 'TR.CompanyMarketCap' and some specific identifier(s).","row":74},{"code":416,"col":1,"message":"Unable to collect data for the field 'TR.CompanyMarketCap' and some specific identifier(s).","row":77},{"code":416,"col":1,"message":"Unable to collect data for the field 'TR.CompanyMarketCap' and some specific identifier(s).","row":84},{"code":416,"col":6,"message":"Unable to collect data for the field 'TR.ISINCode' and some specific identifier(s).","row":84},{"code":416,"col":7,"message":"Unable to collect data for the field 'TR.RICCode' and some specific identifier(s).","row":84},{"code":416,"col":8,"message":"Unable to collect data for the field 'TR.SEDOLCode' and some specific identifier(s).","row":84}],"headerOrientation":"horizontal","headers":[[{"displayName":"Instrument"},{"displayName":"Company Market Cap","field":"TR.COMPANYMARKETCAP"},{"displayName":"GICS Industry Code","field":"TR.GICSINDUSTRYCODE"},{"displayName":"GICS Industry Group Code","field":"TR.GICSINDUSTRYGROUPCODE"},{"displayName":"GICS Sector Code","field":"TR.GICSSECTORCODE"},{"displayName":"GICS Sub-Industry Code","field":"TR.GICSSUBINDUSTRYCODE"},{"displayName":"ISIN Code","field":"TR.ISINCODE"},{"displayName":"RIC Code","field":"TR.RICCODE"},{"displayName":"SEDOL Code","field":"TR.SEDOLCODE"}]],"rowHeadersCount":1,"totalColumnsCount":9,"totalRowsCount":101}]}
Some RICs without ISIN and SEDOL:
["AIR.N",1881008084.2,201010,2010,20,20101010,"","AIR.N",""]
["AHT.N",33380465.26,601030,6010,60,60103010,"","AHT.N",""]
["ALX.N",1017831824.1,601070,6010,60,60107010,"","ALX.N",""]
Now, as example, I send request only for these 3 RICs:
All data is present.
What's going on there? How can I rely on the response from the server if it looks like a random behavior?
Please advise on how we should deal with this.
FYI, I sent the same request the second time and I've got more data. (not sure if something else is missing).
