Hi @benedict.chiu,

I have done some tests and found similar result. According to API Reference Tree, the ReportExtractions and ExtractedFiles exist in the DataScope Select's databases for a limited time. Currently, that time window is 45 days. However, it seems that some ReportExtractions within this period are not listed in results of GetCompletedByScheduleId.

For workaround, you can use ExtractFiles/GetAll to get the same result as Web UI. The GetAll retrieves all types of ExtractedFiles (i.e. result and Note files), so you need to filter only the FileType = ExtractedFileType.Full. Also, the result also includes ExtractedFile of on demand extraction which is not listed on Web UI. You may need to filter the file started with "_OnD_" prefix out.

Below is the sample code.

var firstPage = ExtractionsContext.ExtractedFileOperations.GetAll();
//Output
System.Console.WriteLine("FIRST PAGE:");
foreach (var extractedFile in firstPage)
{
    if (extractedFile.FileType == ExtractedFileType.Full)
    System.Console.WriteLine("Filename: {0}, Size: {1}, ReceivedDate: {2}",
    extractedFile.ExtractedFileName, extractedFile.Size, extractedFile.ReceivedDateUtc);
}

Hi @benedict.chiu

Do you mean that you can get extracted result but it doesn't have all extracts? If so, this could be the incomplete output issue stated in this advisory.

Most Tick History reports deliver output as a gzip file. If a report is large, it delivers its output as several smaller gzip files concatenated into a single large gzip file. The issue is that some HTTP client does not support concatenated gzip files.

To avoid this issue, you need to disable AutomaticDecompression, download gzip file, and then decompress the gzip file using function which supports concatenated gzip file. Sample C# codes are provided in page 4-5 of the advisory. For further information, please refer to the .Net SDK Tutorial 5 which illustrates various ways of downloading and saving extraction data from TRTH.