For a deeper look into our DataScope Select REST API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvote
Accepted
80 2 2 8

DSS REST API get file content

We want to download the content of a rate file via a DSS REST API call.

Looking at the documentation we executed the following calls:

1. Authentication

POST https://hosted.datascopeapi.reuters.com/RestApi/v1/Authentication/RequestToken

2. LastExtraction

GET https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/Schedules('0x053821f5f5340856')/LastExtraction

3. Files

GET https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/ReportExtractions('15042211')/Files

4. Value

GET https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/ExtractedFiles('VjF8fDcyODY0MzY=')/$value

The file we downloaded was the XML rate file (ExtractedFileType.Full). Our understanding is that the id of that file changes with every new extraction. Is that correct?

Is there any way of setting that file id to be the same for every extraction?

Is there any call available in the API that would allow us to download the rate file for the last extraction by making just 1 call?

dss-rest-apidatascope-selectdssrest-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.

escalated to Troy Dalldorf

Use "Ask an Expert" to contact Rick Weyrauch

Hi mdoberschuetz, if this answer is correct can you accept it? Thanks Neil

@mdoberschuetz

Thank you for your participation in the forum.

Are any of the replies below satisfactory in resolving your query?

If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.

Otherwise please post again offering further insight into your question.

Thanks,

AHS

@mdoberschuetz

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,
AHS

Upvote
Accepted
465 3 5 3

Based on your request, we have added this feature to our 10.7 release. These are the new endpoints we have added that will be consistent for a schedule allowing you to retrieve the most recent extraction results with the same url.

../Extractions/Schedules('0x053821f5f5340856')/LastExtraction/$value

../Extractions/Schedules('0x053821f5f5340856')/LastExtraction/FullFile/$value

../Extractions/Schedules('0x053821f5f5340856')/LastExtraction/NotesFile/$value

../Extractions/Schedules('0x053821f5f5340856')/LastExtraction/RicMaintenanceFile/$value

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.

We have noticed 10.7 was released last Saturday. Are the endpoints above available? Can I find release notes anywhere?

The documentation and release notes will soon be published, in the documentation section of the portal.

@mdoberschuetz

DSS 10.7 documentation and release notes are now available under the DSS REST Documentation tab.

Upvotes
1.1k 5 3 5

Currently there is not, but we are considering a new endpoint along these lines:

GET https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/Schedules('0x053821f5f5340856')/LastExtraction/$value

That would always take you to the full results of the last extraction. The term "full results" is used because it would never return partial values during embargo conditions, but instead would only return data once the full result set is available.

One thing that would help get this feature implemented the quickest would be for you to notify your customer service representative you have a product enhancement request as follows: Please add a new Rest API endpoint that provides reusable, single-link access to the full results of a given schedule's LastExtraction.

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.

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.