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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
5 3 3 5

I am unable to download EOD data for 11 exchanges -> NMQ, NSQ,NYQ,TFF,BTQ,VTX,ICA,ASQ,PCQ,FKA,NAQ.

Hi ,

I am unable to download EOD data for 11 exchanges -> NMQ, NSQ,NYQ,TFF,BTQ,VTX,ICA,ASQ,PCQ,FKA,NAQ.

I came across the following error message.

{"error":{"message":"RawExtractionResult of id '' not found. "}}.

I am able to download the data for other exchanges, I use the following link

#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.EndOfDayPricingExtractionRequest", "ContentFieldNames.

Is EOD data applicable for these exchanges? If yes, Please help where am I going wrong?

Thanks!

dss-rest-apidssdatascope-selecttick-history-rest-apipricing
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.

Upvotes
Accepted
648 5 4 6

@Aishwarya.s1

Your end point to get extraction ID should be below

https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/ExtractRaw

once extraction completes then extraction id is generated and that you need to use from below end point.

https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/RawExtractionResults('0x0681239e3cc03e4d')/$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.

For some of the exchanges I am able to download the data using Extaction id. And for some exchanges, i.e. when i request for historical instrument lists, I dont get extraction id instead I get Job id and I am able to download the data via Job id. Is it fine to download the data via JOB ID? is it likely to cause any issue?

Upvotes
13.7k 26 8 12

@Aishwarya.s1,

To answer your comment of 21 February:

EndOfDayPricingExtractionRequest is a DSS call, not a TRTH call, so I am guessing you are a DSS customer, please correct me if I am wrong. There is often some confusion because these 2 products use the same servers ...

There are 2 ways to request the data:

1) To get JSON formatted data

You can use either one of this endpoint:

https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/ExtractWithNotes

or this (deprecated) endpoint:

https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/Extract

These will either deliver the data directly or time out. In case of a timeout it delivers a location URL including an ExtractionId, which can then be used to retrieve the data when available. This is all described in the DSS REST API Tutorial 2.

2) To get compressed CSV formatted data

You use a different endpoint:

https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/ExtractRaw

The returned location URL will contain an ExtractionId, but when the data is ready you will receive a JobId that you must then use in an additional step to retrieve the data. The workflow is different. This is described in the DSS REST API Tutorial 14.

Conclusion

There is no problem, both ways are valid, but the workflows are different. Both deliver the same data content, but in a different format.

I hope this helps clarify what you observe, and helps you choose the most appropriate workflow.

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.