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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
1 0 0 5

Calling the API for specific ccy pairs

I am using json to build the request.

The below works fine. I can see the results:

#RIC,Domain,Date-Time,GMT Offset,Type,High Bid,Low Bid,Close Bid,High Ask,Low Ask,Close Ask BRL=,Market Price,2019-07-08T14:00:00.000000000Z,+0,Intraday 10Min,3.8096,3.8055,3.8058,3.811,3.8069,3.8083 BRL=,Market Price,2019-07-08T14:10:00.000000000Z,+0,Intraday 10Min,3.8101,3.8055,3.8074,3.8115,3.8069,3.8083 BRL=,Market Price,2019-07-08T14:20:00.000000000Z,+0,Intraday 10Min,3.8106,3.8045,3.8085,3.812,3.8059,3.8097

$jsonRequest = '

{

"ExtractionRequest": {

"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.TickHistoryIntradaySummariesExtractionRequest",

"ContentFieldNames": [

"Close Ask",

"Close Bid",

"High Ask",

"High Bid",

"Low Ask",

"Low Bid"

],

"IdentifierList": {

"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",

"InstrumentIdentifiers": [

{

"Identifier": "BRL=",

"IdentifierType": "Ric"

}

],

"ValidationOptions": null,

"UseUserPreferencesForValidationOptions": false

},

"Condition": {

"MessageTimeStampIn": "GmtUtc",

"ReportDateRangeType": "Range",

"QueryStartDate": "2019-07-08T15:00:00",

"QueryEndDate": "2019-07-08T15:30:00",

"SummaryInterval": "TenMinutes",

"TimebarPersistence": true,

"DisplaySourceRIC": false

}

}

}

'

But the below returns nothing:

$jsonRequest = '

{

"ExtractionRequest": {

"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.TickHistoryIntradaySummariesExtractionRequest",

"ContentFieldNames": [

"Close Ask",

"Close Bid",

"High Ask",

"High Bid",

"Low Ask",

"Low Bid"

],

"IdentifierList": {

"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",

"InstrumentIdentifiers": [

{

"Identifier": "TWD=",

"IdentifierType": "Ric"

}

],

"ValidationOptions": null,

"UseUserPreferencesForValidationOptions": false

},

"Condition": {

"MessageTimeStampIn": "GmtUtc",

"ReportDateRangeType": "Range",

"QueryStartDate": "2019-07-08T15:00:00",

"QueryEndDate": "2019-07-08T15:30:00",

"SummaryInterval": "TenMinutes",

"TimebarPersistence": true,

"DisplaySourceRIC": false

}

}

}

'

The only thing I have changed is the instrument identifier from BRL= to TWD=. It looks like a permissions issue to the account?

dss-rest-apidssdatascope-selectrest-apijson
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
15.2k 40 12 19

Hi @maria.kouppari, You will have to contact your Refinitiv account manager who can help with modifying user privileges.

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
15.2k 40 12 19

Must be the permission issue. I could execute this request for TWD= and am able to successfully get data:

#RIC,Domain,Date-Time,GMT Offset,Type,High Bid,Low Bid,Close Bid,High Ask,Low Ask,Close Ask
TWD=,Market Price,2019-07-08T19:00:00.000000000Z,+0,Intraday 10Min,31.177,31.166,31.177,31.197,31.187,31.187
TWD=,Market Price,2019-07-08T19:10:00.000000000Z,+0,Intraday 10Min,31.178,31.167,31.167,31.198,31.188,31.197
TWD=,Market Price,2019-07-08T19:20:00.000000000Z,+0,Intraday 10Min,31.178,31.167,31.167,31.198,31.188,31.197
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
1 0 0 5

Could someone check the permissions of the account and add the missing access?

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.