question

Upvotes
Accepted
Beera.Rajesh avatar image
262 ●8 ●9 ●15

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 5.0 MiB each and 10.0 MiB total.

1 Answer

Upvotes
Accepted
Jirapongse avatar image
38.1k ●71 ●35 ●53

@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 5.0 MiB each and 10.0 MiB total.

Beera.Rajesh avatar image Beera.Rajesh

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

Jirapongse avatar image Jirapongse Beera.Rajesh

@Beera.Rajesh

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

Extractions/ExtractedFiles('VjF8fDc5NzY1NzY1NQ')/$value
Click below to post an Idea Post Idea