how to use API for downloading data generated by schedules created by GUI.

@satish.shioshankar.gaidhane, this can be done in several steps:

1) Retrieve the Report Extraction ID(s)

You can use the following method to find the schedule IDs and report extraction IDs for recently completed
extractions:

Send a GET request to this endpoint:

https://hosted.datascopeapi.reuters.com/restapi/v1/Extractions/ReportExtractionGetCompleted()

Results extract:

{
    "@odata.context": "https://hosted.datascopeapi.reuters.com/restapi/v1/$metadata#ReportExtractions",
    "value": [        {
            "ReportExtractionId": "2000000001094891",
            "ScheduleId": "0x05c876cdb03b2fd6",
            "Status": "Completed",
            "DetailedStatus": "Done",
            "ExtractionDateUtc": "2017-07-05T15:24:11.106Z",
            "ScheduleName": "Test2_ElektronTS_EoD_ISN",
            "IsTriggered": false
        },
        {
            "ReportExtractionId": "264698982",
            "ScheduleId": "0x05c876beb0bb2fd6",
            "Status": "Completed",
            "DetailedStatus": "Done",
            "ExtractionDateUtc": "2017-07-05T15:23:09.676Z",
            "ScheduleName": "Test_TandC_ISN",
            "IsTriggered": false,
            "ExtractionStartUtc": "2017-07-05T15:23:10.000Z",
            "ExtractionEndUtc": "2017-07-05T15:23:11.000Z"
        },...

If required you can search for specific schedules in the results, by ID or name.

Save the ReportExtractionId for the schedules of interest.

From here on, it is similar to the REST API Tutorial 10, starting from this step. In a nutshell, you first retrieve the extraction report, then the files:

2) Retrieve the Extraction Report(s)

For each schedule of interest, send a GET request to this endpoint (note that we pass the ReportExtractionId (retrieved in the previous step) as a parameter, directly in the URL):

https://hosted.datascopeapi.reuters.com/restapi/v1/Extractions/ReportExtractions('2000000001094891')/Files

Typical results:

{
    "@odata.context": "https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#ExtractedFiles",
    "value": [
        {
            "ExtractedFileId": "VjF8fDMwMzUzMDIwOQ",
            "ReportExtractionId": "2000000001094891",
            "FileType": "RicMaintenanceNote",
            "ExtractedFileName": "Test2_ElektronTS_EoD_ISN.ric.csv",
            "LastWriteTimeUtc": "2017-07-05T15:24:23.338Z",
            "ContentsExists": true,
            "Size": 90,
            "ReceivedDateUtc": "2017-07-05T15:24:23.338Z"
        },
        {
            "ExtractedFileId": "VjF8fDMwMzUzMDIwOA",
            "ReportExtractionId": "2000000001094891",
            "FileType": "Full",
            "ExtractedFileName": "Test2_ElektronTS_EoD_ISN.csv",
            "LastWriteTimeUtc": "2017-07-05T15:24:23.333Z",
            "ContentsExists": true,
            "Size": 143,
            "ReceivedDateUtc": "2017-07-05T15:24:23.333Z"
        },
        {
            "ExtractedFileId": "VjF8fDMwMzUzMDIwNw",
            "ReportExtractionId": "2000000001094891",
            "FileType": "Note",
            "ExtractedFileName": "Test2_ElektronTS_EoD_ISN.csv.notes.txt",
            "LastWriteTimeUtc": "2017-07-05T15:24:23.340Z",
            "ContentsExists": true,
            "Size": 2064,
            "ReceivedDateUtc": "2017-07-05T15:24:23.340Z"
        }
    ]
}

Save the ExtractedFileId for the files of interest.

3) Retrieve the Extraction Report(s)

Retrieve each file of interest, by sending a GET request to this endpoint (note that we pass the ReportExtractionId (retrieved in the previous step) as a parameter, directly in the URL):

https://hosted.datascopeapi.reuters.com/restapi/v1/Extractions/ExtractedFiles('VjF8fDMwMzUzMDIwOA')/$value

That is strange, a GET to https://hosted.datascopeapi.reuters.com/restapi/v1/Extractions/ExtractedFiles('VjFwNWNhNdfgdfDdiNzEyZWIzMDI2fA')/$value should retrieve the file. Let me double check.

@satish.shioshankar.gaidhane

Do you use curl to run the step 2? I guess that the '$value' might be treated as variable, so the "$value" will be removed from the endpoint. Could you please add "\" before the $value?

Below is the example.

curl -H "Content-Type: Accept-Encoding: gzip, deflate" -H "Prefer: respond-async" -H "Authorization:<Token>" -X GET https://hosted.datascopeapi.reuters.com/restapi/v1/Extractions/ExtractedFiles\(\'VjF8MHgwNWM2MjUyY2VjOWIzMDM2fA\'\)/\$value