Archive file is corrupt.

mihanix.it
mihanix.it Newcomer
in TRTH

I am trying to extract my request (TickHistoryTimeAndSalesExtractionRequest) but the recieved file is corrupt so I can't unarchivate it.

My request is: 

{
    "ExtractionRequest": {
        "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.TickHistoryTimeAndSalesExtractionRequest",
        "ContentFieldNames": [
            "Auction - Exchange Time",
            "Auction - Price",
            "Auction - Qualifiers",
            "Auction - Volume",
            "Quote - Bid Price",
            "Quote - Bid Size",
            "Quote - Ask Price",
            "Quote - Ask Size",
            "Quote - Bid Tick",
            "Quote - Bid Yield",
            "Quote - Ask Yield"],
       "IdentifierList": {
            "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
            "InstrumentIdentifiers": [{"Identifier":"AAPL.O","IdentifierType":"Ric"},{"Identifier":"HOLX.O","IdentifierType":"Ric"},{"Identifier":"CBOE.O","IdentifierType":"Ric"},{"Identifier":"CINF.O","IdentifierType":"Ric"},{"Identifier":"CTAS.O","IdentifierType":"Ric"},{"Identifier":"CMCSA.O","IdentifierType":"Ric"},{"Identifier":"NDAQ.O","IdentifierType":"Ric"},{"Identifier":"GRMN.O","IdentifierType":"Ric"},{"Identifier":"MAR.O","IdentifierType":"Ric"},{"Identifier":"LKQ.O","IdentifierType":"Ric"},{"Identifier":"ALGN.O","IdentifierType":"Ric"},{"Identifier":"ADI.O","IdentifierType":"Ric"},{"Identifier":"CTSH.O","IdentifierType":"Ric"},{"Identifier":"TRIP.O","IdentifierType":"Ric"},{"Identifier":"TTWO.O","IdentifierType":"Ric"},{"Identifier":"VRSK.O","IdentifierType":"Ric"},{"Identifier":"PEP.O","IdentifierType":"Ric"},{"Identifier":"TROW.O","IdentifierType":"Ric"},{"Identifier":"EBAY.O","IdentifierType":"Ric"},{"Identifier":"IDXX.O","IdentifierType":"Ric"},{"Identifier":"GT.O","IdentifierType":"Ric"},{"Identifier":"ILMN.O","IdentifierType":"Ric"},{"Identifier":"FLIR.O","IdentifierType":"Ric"},{"Identifier":"HSIC.O","IdentifierType":"Ric"},{"Identifier":"FAST.O","IdentifierType":"Ric"},{"Identifier":"ETFC.O","IdentifierType":"Ric"},{"Identifier":"NTRS.O","IdentifierType":"Ric"},{"Identifier":"ORLY.O","IdentifierType":"Ric"},{"Identifier":"CTXS.O","IdentifierType":"Ric"},{"Identifier":"EXPE.O","IdentifierType":"Ric"},{"Identifier":"ADBE.O","IdentifierType":"Ric"},{"Identifier":"AKAM.O","IdentifierType":"Ric"},{"Identifier":"HAS.O","IdentifierType":"Ric"},{"Identifier":"ESRX.O","IdentifierType":"Ric"},{"Identifier":"FOXA.O","IdentifierType":"Ric"},{"Identifier":"MNST.O","IdentifierType":"Ric"},{"Identifier":"EA.O","IdentifierType":"Ric"},{"Identifier":"ANSS.O","IdentifierType":"Ric"},{"Identifier":"TSCO.O","IdentifierType":"Ric"},{"Identifier":"CSCO.O","IdentifierType":"Ric"},{"Identifier":"FOX.O","IdentifierType":"Ric"},{"Identifier":"NKTR.O","IdentifierType":"Ric"},{"Identifier":"FB.O","IdentifierType":"Ric"},{"Identifier":"QCOM.O","IdentifierType":"Ric"},{"Identifier":"HBAN.O","IdentifierType":"Ric"},{"Identifier":"SWKS.O","IdentifierType":"Ric"},{"Identifier":"CHRW.O","IdentifierType":"Ric"},{"Identifier":"ABMD.O","IdentifierType":"Ric"},{"Identifier":"STX.O","IdentifierType":"Ric"},{"Identifier":"INTU.O","IdentifierType":"Ric"},{"Identifier":"GOOGL.O","IdentifierType":"Ric"},{"Identifier":"AMZN.O","IdentifierType":"Ric"},{"Identifier":"NVDA.O","IdentifierType":"Ric"},{"Identifier":"ULTA.O","IdentifierType":"Ric"},{"Identifier":"CHTR.O","IdentifierType":"Ric"},{"Identifier":"ATVI.O","IdentifierType":"Ric"},{"Identifier":"PAYX.O","IdentifierType":"Ric"},{"Identifier":"DLTR.O","IdentifierType":"Ric"},{"Identifier":"WYNN.O","IdentifierType":"Ric"},{"Identifier":"MYL.O","IdentifierType":"Ric"},{"Identifier":"BKNG.O","IdentifierType":"Ric"},{"Identifier":"NFLX.O","IdentifierType":"Ric"},{"Identifier":"FITB.O","IdentifierType":"Ric"},{"Identifier":"CELG.O","IdentifierType":"Ric"},{"Identifier":"SBUX.O","IdentifierType":"Ric"},{"Identifier":"AAL.O","IdentifierType":"Ric"},{"Identifier":"PCAR.O","IdentifierType":"Ric"},{"Identifier":"PBCT.O","IdentifierType":"Ric"},{"Identifier":"WLTW.O","IdentifierType":"Ric"},{"Identifier":"FISV.O","IdentifierType":"Ric"},{"Identifier":"ISRG.O","IdentifierType":"Ric"},{"Identifier":"MDLZ.O","IdentifierType":"Ric"},{"Identifier":"KHC.O","IdentifierType":"Ric"},{"Identifier":"AVGO.O","IdentifierType":"Ric"},{"Identifier":"WDC.O","IdentifierType":"Ric"},{"Identifier":"ALXN.O","IdentifierType":"Ric"},{"Identifier":"XEL.O","IdentifierType":"Ric"},{"Identifier":"MCHP.O","IdentifierType":"Ric"},{"Identifier":"ADSK.O","IdentifierType":"Ric"},{"Identifier":"XLNX.O","IdentifierType":"Ric"},{"Identifier":"XRAY.O","IdentifierType":"Ric"},{"Identifier":"CPRT.O","IdentifierType":"Ric"},{"Identifier":"REGN.O","IdentifierType":"Ric"},{"Identifier":"SYMC.O","IdentifierType":"Ric"},{"Identifier":"VRSN.O","IdentifierType":"Ric"},{"Identifier":"NWS.O","IdentifierType":"Ric"},{"Identifier":"SNPS.O","IdentifierType":"Ric"},{"Identifier":"VIAB.O","IdentifierType":"Ric"},{"Identifier":"MAT.O","IdentifierType":"Ric"},{"Identifier":"CSX.O","IdentifierType":"Ric"},{"Identifier":"WBA.O","IdentifierType":"Ric"},{"Identifier":"IPGP.O","IdentifierType":"Ric"},{"Identifier":"FFIV.O","IdentifierType":"Ric"},{"Identifier":"MSFT.O","IdentifierType":"Ric"},{"Identifier":"LRCX.O","IdentifierType":"Ric"},{"Identifier":"SIVB.O","IdentifierType":"Ric"},{"Identifier":"MU.O","IdentifierType":"Ric"},{"Identifier":"PYPL.O","IdentifierType":"Ric"},{"Identifier":"DISCA.O","IdentifierType":"Ric"},{"Identifier":"BIIB.O","IdentifierType":"Ric"},{"Identifier":"NTAP.O","IdentifierType":"Ric"},{"Identifier":"AMD.O","IdentifierType":"Ric"},{"Identifier":"DISCK.O","IdentifierType":"Ric"},{"Identifier":"TEL.O","IdentifierType":"Ric"},{"Identifier":"INFO.O","IdentifierType":"Ric"},{"Identifier":"AMAT.O","IdentifierType":"Ric"},{"Identifier":"AMGN.O","IdentifierType":"Ric"},{"Identifier":"COST.O","IdentifierType":"Ric"},{"Identifier":"VRTX.O","IdentifierType":"Ric"},{"Identifier":"CERN.O","IdentifierType":"Ric"},{"Identifier":"INCY.O","IdentifierType":"Ric"},{"Identifier":"PFG.O","IdentifierType":"Ric"},{"Identifier":"EQIX.O","IdentifierType":"Ric"},{"Identifier":"GOOG.O","IdentifierType":"Ric"},{"Identifier":"KLAC.O","IdentifierType":"Ric"},{"Identifier":"TXN.O","IdentifierType":"Ric"},{"Identifier":"CME.O","IdentifierType":"Ric"},{"Identifier":"ADP.O","IdentifierType":"Ric"},{"Identifier":"NWSA.O","IdentifierType":"Ric"},{"Identifier":"BHF.O","IdentifierType":"Ric"},{"Identifier":"JBHT.O","IdentifierType":"Ric"},{"Identifier":"ZION.O","IdentifierType":"Ric"},{"Identifier":"EXPD.O","IdentifierType":"Ric"},{"Identifier":"ROST.O","IdentifierType":"Ric"},{"Identifier":"SBAC.O","IdentifierType":"Ric"},{"Identifier":"INTC.O","IdentifierType":"Ric"},{"Identifier":"QRVO.O","IdentifierType":"Ric"},{"Identifier":"DISH.O","IdentifierType":"Ric"},{"Identifier":"GILD.O","IdentifierType":"Ric"},{"Identifier":"CDNS.O","IdentifierType":"Ric"},{"Identifier":"SRCL.O","IdentifierType":"Ric"}
            ],
            "UseUserPreferencesForValidationOptions" : "False"},
        "Condition": {
            "MessageTimeStampIn": "GmtUtc",
            "ReportDateRangeType": "Range",
            "QueryStartDate": "2018-07-01T23:45:00.000Z",
            "QueryEndDate": "2018-07-30T12:30:00.000Z",
            "DisplaySourceRIC": "True"}
    }

}

What should I do ?

Tagged:

Best Answer

  • Christiaan Meihsl
    Christiaan Meihsl LSEG
    Answer ✓

    @mihanix.it, seeing the size of your request the file must be quite large. You do not show us the code you used to download the data, but I guess it needs adapting, because not all coding techniques and libraries are appropriate for such large data files.

    I suggest you start by reading this advisory, which explains the issues you can encounter, and how to avoid them.

    Our code samples are built following the recommendations in that advisory, you can also copy / paste out of them.

    If this does not help, please post the code you use to download the data, we might be able to see what needs changing.

Categories