question

Upvotes
Accepted
262 12 15 17

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

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.


tick-history-rest-api
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Upvotes
Accepted
78.1k 246 52 72

@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"
        }
    ]
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

@jirapongse.phuriphanvichai Thank you.
Please confirm if the final call is to use "ExtractedFileId": "VjF8MHgwNzdkNjVlODU0Nzc1YzVifA", to download related files?

<https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/ReportExtractions('2000000239094096')/Files >

@Beera.Rajesh

Yes, you can use the ExtractedFileId to get the file.

Extractions/ExtractedFiles('VjF8fDc5NzY1NzY1NQ')/$value 

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.