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

Options
Beera.Rajesh
Beera.Rajesh LSEG
in TRTH

...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.


Tagged:

Best Answer

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    Answer ✓

    @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"
            }
        ]

Answers

Categories