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?

Best Answer

Answers

  • 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
  • Could someone check the permissions of the account and add the missing access?