Hallo All,
I have below CompositeExtractionRequest extraction request where when requested for ISIN some values return with TRADE date and also values for rest of the field but some without any TRADE date and rest of the field also return nulls without ISIN. It returns values ony with Ric and Contributor Code.
What is the reason for this ? Do i am doing wrong in the extraction request ? How to avoid this ? Its the same problem with many ISIN which i am providing in extraction request.
requestBody = {
"ExtractionRequest": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.CompositeExtractionRequest",
"ContentFieldNames": [
"ISIN","RIC","Trade Date","Market MIC","Market Segment MIC","Average Volume - 30 Days","Average Volume - 90 Days","Close on Close Volatility - 90 Days","Dollar Daily Value Average - 30 Days","Outstanding Shares - Issue Shares Amount","Contributor Code","Ask Price","Bid Price"
],
"IdentifierList": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
"InstrumentIdentifiers": [{
"Identifier": "CH0012005267",
"IdentifierType": "Isin",
"Source": "*"
}]
,
"ValidationOptions": {
"AllowHistoricalInstruments": "false"
},
"UseUserPreferencesForValidationOptions": "false"
},
"Condition": {
"ScalableCurrency": "true"
}
}
}
Below is the response in which i have highlighted the issue IN BOLD:
CH0012005267,NOVN.S,2022/07/19,XSWX,XSWX,4219458,4816834,14.971828980,305899908.5634673,2182788588,SWX,83.31,83.29
CH0012005267,0QLR.L,2022/07/18,XLOM,XLOM,1511075,1479031,14.118781748,112782750.0957487,2182788588,LSE,84.24,80.14
CH0012005267,NVSEF.PK,2022/07/18,PINC,PINC,32729,28331,22.986970525,2336471.721173684,2182788588,PNK,,
CH0012005267,NOVNN.MX,2022/07/18,XMEX,XMEX,2,,,200.382721176,2182788588,MEX,,
CH0012005267,NOVZn.D,2022/07/18,DUSB,DUSB,0,0,0,0,2182788588,DUS,,
CH0012005267,NOVZn.F,2022/07/18,FRAB,FRAB,0,0,0,0,2182788588,FRA,,
CH0012005267,NOVNz.BS,2022/07/18,BATE,BATE,1104677,1315643,15.947665245,81979372.70800282,2182788588,BTE,82.21,82.08
CH0012005267,NOVNz.CHI,2022/07/19,CHIX,CHIX,712031,709784,14.290179052,57881684.67594057,2182788588,CHI,83.37,
CH0012005267,NOVNz.AQX,2022/07/19,AQXE,AQXE,194348,193342,14.634670140,16014191.209961094,2182788588,AQX,83.37,83.33
CH0012005267,NOVNz.TQ,2022/07/19,TRQX,TRQX,105318,109151,14.834651165,8337248.688679502,2182788588,TRQ,,
CH0012005267,NOVNz.SIG,2022/07/18,SGMX,SGMX,22170,21474,13.985876989,1733487.138010152,2182788588,SIG,,
CH0012005267,NOVZn.MU,2022/07/18,MUNB,MUNB,0,0,0,0,2182788588,MUN,,
CH0012005267,NOVN.BN,2022/07/18,XBRN,XBRN,42,73,16.522471238,2374.759305569,2182788588,BRN,,80
CH0012005267,NOVZn.TG,2022/07/18,XGAT,XGAT,0,0,0,0,2182788588,TDG,,
CH0012005267,NOVZn.HA,2022/07/18,HANB,HANB,0,0,0,0,2182788588,HAN,,
CH0012005267,NOT.QTX,2022/07/18,DUSD,DUSD,,,,,2182788588,QTX,,
CH0012005267,NOVZn.SG,2022/07/18,STUB,STUB,0,0,0,0,2182788588,STU,,
CH0012005267,NOVZn.H,2022/07/18,HAMB,HAMB,0,0,0,0,2182788588,HAM,,
CH0012005267,NOVZn.BE,2022/07/18,BERB,BERB,0,0,0,0,2182788588,BER,,
CH0012005267,NOVNN.BIV,2022/07/18,BIVA,BIVA,0,,,0,2182788588,BIV,,
CH0012005267,NOVNz.BCO,2022/07/18,BOTC,BOTC,1834803,1774221,14.368760339,147959092.04938638,2182788588,BCO,,
CH0012005267,NOVNN.MCO,2022/07/18,XXXX,XXXX,2,,,201.612810560,2182788588,MXQ,,
CH0012005267,NOVZn.DEU,2022/07/18,,,0,0,0,0,2182788588,DEU,,
CH0012005267,NOTd.BCO,2022/07/18,BOTC,BOTC,18929,17566,22.355695063,1453338.430398658,2182788588,BCO,,
CH0012005267,NOVN.MI^G19,2019/07/19,MTAH,MTAH,302,393,19.364743134,19917.374490182,2182788588,MIL,,
CH0012005267,NOVNz.SIG^G19,2019/06/28,SGMX,SGMX,6820,7869,24.453098215,626192.728241352,2182788588,SIG,,
CH0012005267,NOTd.CHI^G19,2019/06/28,CHIX,CHIX,1453,1729,16.589917727,118790.915431983,2182788588,CHI,80.64,79.64
CH0012005267,NOTd.BS^G19,2019/06/28,BATE,BATE,1091,1117,17.278550102,80387.890870660,2182788588,BTE,80.64,79.64
CH0012005267,NOTd.TQ^G19,2019/06/28,TRQX,TRQX,105,202,16.148915368,7854.412059371,2182788588,TRQ,,
CH0012005267,NOTd.AQX^G19,2019/06/28,AQXE,AQXE,0,0,0,0,2182788588,AQX,80.97,80.04
CH0012005267,NOVNz.ED^K19,2019/11/15,EQTC,EQTC,0,0,0,0,2182788588,EQD,92.72,85.59
CH0012005267,NOVZn.DE^I19,2019/09/20,XETB,XETB,0,4969,8.754861865,0,2182788588,GER,,
CH0012005267,NOVZn.TI^G19,2019/07/19,ETLX,ETLX,258,432,17.149677643,11072.394859620,2182788588,ETX,,
CH0012005267,NOVZn.GTX,2022/07/18,MUND,MUND,,,,,2182788588,GTX,,
CH0012005267,NOVN.xt,2022/07/18,,,9932431,9949949,14.316806511,749940614.551463,2182788588,XDS,,
CH0012005267,NOVNCHF.xbo,2022/07/18,,,4798542,4912643,14.623660482,356860948.0547263,2182788588,XBO,82.54,82.42
CH0012005267,0QLRs.TRE,2022/07/18,ECHO,ECHO,1015585,1226715,14.116057049,71725701.55722623,2182788588,LSE,,
CH0012005267,NOVNz.BCU,2022/07/18,CAPA,CAPA,,,,,2182788588,BCU,86.22,77.94
CH0012005267,0QLRs.TRU,2022/07/18,ECEU,ECEU,,,,,2182788588,TRU,,
,NVSEF.PQ,,,,,,,,,OTC,,
CH0012005267,NOTde.IODO^F21,,IMCE,IMCE,,,,,2182788588,TUP,,
CH0012005267,NOTde.IEDM^F21,,IMCE,IMCE,,,,,2182788588,TUP,,
,NOVNs.TWEM,,,,,,,,,TWA,,
CH0012005267,NOTde.TWEA^B21,,TREA,TREA,,,,,2182788588,TWA,,
CH0012005267,NOTde.IGDM^F21,,IMCE,IMCE,,,,,2182788588,TUP,,
CH0012005267,NOVNs.TWEM^G21,,TREU,TREU,,,,,2182788588,TWA,,
,NOTde.TBEA,,,,,,,,,TBE,,
CH0012005267,0GQ9.L^E08,,,,,,,,2182788588,LSE,,
CH0012005267,NOVNq.L^K07,2007/11/19,XLON,XLON,23696,8499,12.030534814,1780799.038804425,2182788588,LSE,,
,NOTde.ICEM,,,,,,,,,TUP,,
CH0012005267,NOVZn.HA^D06,2006/04/07,,,0,12,4.991040141,0,2182788588,HAN,,
CH0012005267,NOVq.L^F99,,,,18281,36061,17.350784427,25625277.6563787,2182788588,LSE,,
CH0012005267,NOVNs.TWEA^B21,,TREA,TREA,,,,,2182788588,TWA,,
CH0012005267,NOVN.xEUR^A09,2009/01/16,,,,,,,2182788588,XDS,,
CH0012005267,0HKE.L^F09,2009/06/26,XLOM,XLOM,,,,,2182788588,LSE,,
CH0012005267,NOVZnde.INS^K08,2008/10/31,,,0,0,,0,2182788588,CXE,,
CH0012005267,NOVNEUR.xt^I11,,,,,,,,2182788588,XDS,,
CH0012005267,NOVNz.EDv^K19,2019/11/15,EQTC,EQTC,0,0,,0,2182788588,EQD,,
CH0012005267,NOVNs.STp^C22,2022/03/22,NAPA,NAPA,,,,,2182788588,NAA,,
CH0012005267,NOVNs.ENp^K21,2021/11/08,XAPA,XAPA,,,,,2182788588,EXT,,
CH0012005267,NOVNs.ENp^A22,2021/12/31,XAPA,XAPA,,,,,2182788588,EXT,,
CH0012005267,NOVNs.MCp^B22,2022/02/09,BMEA,BMEA,,,,,2182788588,BMA,,
CH0012005267,NOVNs.ENp^C22,2022/03/23,XAPA,XAPA,,,,,2182788588,EXT,,
CH0012005267,NOVNs.VIp,2022/07/18,APAW,APAW,,,,,2182788588,VIA,,
CH0012005267,NOVNs.BUp^E22,2022/05/30,KELR,KELR,,,,,2182788588,BUA,,
CH0012005267,NOVNs.STp^F22,2022/06/03,NAPA,NAPA,,,,,2182788588,NAA,,
CH0012005267,NOVNs.ENp^G22,2022/07/12,XAPA,XAPA,,,,,2182788588,EXT,,
CH0012005267,NOVNs.BUp,2022/07/18,KELR,KELR,,,,,2182788588,BUA,,
CH0012005267,NOVNs.BUp^I21,2021/09/24,KELR,KELR,,,,,2182788588,BUA,,
CH0012005267,NOVNs.ENp^I21,2021/09/15,XAPA,XAPA,,,,,2182788588,EXT,,
CH0012005267,NOVNs.MCp^H21,2021/08/03,BMEA,BMEA,,,,,2182788588,BMA,,
CH0012005267,NOVNEUR.xbo^J20,2020/10/15,,,0,0,,0,2182788588,XBO,,
CH0012005267,NOVNs.VIp^B22,2022/02/22,APAW,APAW,,,,,2182788588,VIA,,
CH0012005267,NOVNs.STp^F21,2021/06/03,NAPA,NAPA,,,,,2182788588,NAA,,
CH0012005267,NOVNs.STp^K20,2020/11/11,NAPA,NAPA,,,,,2182788588,NAA,,
CH0012005267,NOVNz.NXT^G19,2019/06/28,XSMP,XSMP,,,,,2182788588,EBT,,
CH0012005267,NOTd.NXT^F19,2019/06/17,XSMP,XSMP,,,,,2182788588,EBT,,
CH0012005267,NOTd.BCU,2022/07/18,CAPA,CAPA,,,,,2182788588,BCU,84.357,76.323
CH0012005267,NOVNz.EDM^K19,2019/11/15,EQTC,EQTC,,,,,2182788588,EQD,,
CH0012005267,NOTde.BUp^I21,2021/09/03,KELR,KELR,,,,,2182788588,BUA,,
CH0012005267,NOTde.ENp^B21,2021/02/18,XAPA,XAPA,,,,,2182788588,EXT,,
CH0012005267,NOTde.STp^I20,2020/09/01,NAPA,NAPA,,,,,2182788588,NAA,,
CH0012005267,NOVNtah.MI^G19,2021/01/19,MTAH,MTAH,0,0,,0,2182788588,MIL,,72
CH0012005267,NOVNs.Vip^L20,2020/12/30,APAW,APAW,,,,,2182788588,VIA,,
