Tick History Client want their GUI custom extractions output files downloaded to their system aut...

Beera.Rajesh

...omatically with no manual intervention. As Tick History does not support FTP, looking for a way to do the same through API

Tick History Client want their GUI custom extractions output files downloaded to their system automatically with no manual intervention. As Tick History does not support FTP, looking for a way to do the same through API

I found this way:

Step1: Check for files available for download:

END POINT: https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/ExtractedFiles

HEADERS:

Authorization:Token <Token Value>
Prefer:odata.track-changes; respond-async; odata.maxpagesize=25

Step 2: Download the output file using "ExtractedFileId": "VjF8fDc5NzI3MDI2OQ",

END POINT: https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/ExtractedFiles('VjF8fDc5NzI3MDI2OQ')/$value

HEADERS:

Authorization:Token <Token Value>

Prefer:respond-async

Content-Type:application/json

Accept-Encoding:gzip, deflate

But Extractions/ExtractedFiles is giving full list of files (historical and current day) every time we do this call will cause duplicate downloads, Is there a way to get output files by date / any other API call which looks for current day extractions and download the available files.

Jirapongse

@Beera.Rajesh

I think the client can use /Extractions/ReportExtractionGetCompletedByDateRange(StartDate=2021-03-23T00:00:00.000Z,EndDate=2021-03-23T23:59:00.000Z) to get all extractions Pending, Processing, or Completed that match the specified date range.

It will return the ReportExtractionId.

        {
            "ReportExtractionId": "515075714",
            "ScheduleId": "0x077cf62db1e75b7a",
            "Status": "Completed",
            "DetailedStatus": "Done",
            "ExtractionDateUtc": "2021-03-23T08:40:51.503Z",
            "ScheduleName": "03.23.2021 08.40.28",
            "IsTriggered": false,
            "ExtractionStartUtc": "2021-03-23T08:40:52.000Z",
            "ExtractionEndUtc": "2021-03-23T08:40:55.000Z"
        }

Then, use the ReportExtractionId with Extractions/ReportExtractions('515075714')/Files to get files.

 [
        {
            "ExtractedFileId": "VjF8fDc5NzY1NzY1Ng",
            "ReportExtractionId": "515075714",
            "ScheduleId": "0x077cf62db1e75b7a",
            "FileType": "RicMaintenanceNote",
            "ExtractedFileName": "testextractedfile1.ric.csv",
            "LastWriteTimeUtc": "2021-03-23T08:40:55.432Z",
            "ContentsExists": true,
            "Size": 0,
            "ReceivedDateUtc": "2021-03-23T08:40:55.432Z"
        },
        {
            "ExtractedFileId": "VjF8fDc5NzY1NzY1NQ",
            "ReportExtractionId": "515075714",
            "ScheduleId": "0x077cf62db1e75b7a",
            "FileType": "Full",
            "ExtractedFileName": "testextractedfile1.csv",
            "LastWriteTimeUtc": "2021-03-23T08:40:55.423Z",
            "ContentsExists": true,
            "Size": 105,
            "ReceivedDateUtc": "2021-03-23T08:40:55.423Z"
        },
        {
            "ExtractedFileId": "VjF8fDc5NzY1NzY1NA",
            "ReportExtractionId": "515075714",
            "ScheduleId": "0x077cf62db1e75b7a",
            "FileType": "Note",
            "ExtractedFileName": "testextractedfile1.csv.notes.txt",
            "LastWriteTimeUtc": "2021-03-23T08:40:55.437Z",
            "ContentsExists": true,
            "Size": 1544,
            "ReceivedDateUtc": "2021-03-23T08:40:55.437Z"
        }
    ]