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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
f.cipriani avatar image
5 ●0 ●0 ●3

API issue - response has no data although client is getting 200 OK

I'm trying to download data for EURUSD, but I get no data my query are:

requestUrl = 'https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/ExtractRaw'

requestBody = {

  "ExtractionRequest": {

    "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.TickHistoryTimeAndSalesExtractionRequest",

    "ContentFieldNames": [

      "Trade - Price",

      "Trade - Volume",

      "Trade - Exchange Time"

    ],

    "IdentifierList": {

      "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",

      "InstrumentIdentifiers": [

        { "Identifier": "EUR=", "IdentifierType": "Ric" }

      ]

    },

    "Condition": {

      "MessageTimeStampIn": "GmtUtc",

      "ApplyCorrectionsAndCancellations": False,

      "ReportDateRangeType": "Range",

      "QueryStartDate": "2015-09-29T00:00:00.000Z",

      "QueryEndDate": "2015-09-29T12:00:00.000Z",

      "DisplaySourceRIC": True

    }

  }

}



after 200 at Location a do the get at:


requestUrl = f"https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/RawExtractionResults('{job_id}')/$value"

with job_id = JobId


but a get no row just header


same thing when I do:


requestUrl = 'https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/ExtractRaw'

requestBody = {

  "ExtractionRequest": {

    "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.TickHistoryMarketDepthExtractionRequest",

    "ContentFieldNames": [

      "Ask Price",

      "Ask Size",

      "Bid Price",

      "Bid Size",
        
      "Number of Buyers",

      "Number of Sellers",

    ],

    "IdentifierList": {

      "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",

      "InstrumentIdentifiers": [

        { "Identifier": "EUR=", "IdentifierType": "Ric" }

      ]

    },

    "Condition": {

      "View": "NormalizedLL2",

      "NumberOfLevels": 10,

      "MessageTimeStampIn": "GmtUtc",

      "ReportDateRangeType": "Range",

      "QueryStartDate": "2016-09-29T09:00:00.000Z",

      "QueryEndDate": "2016-09-29T12:00:00.000Z",

      "DisplaySourceRIC": True

    }

  }

}


what I'm doing wrong?


dss-rest-apiextraction
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

1 Answer

Upvote
Accepted
Jirapongse avatar image
38.1k ●71 ●35 ●53

@f.cipriani

You need to check the notes. You get the notes in the body of an HTTP response when an HTTP response is 200.

I used the same request and got the following notes. 

{
...
    "Notes": [
        "Extraction Services Version 15.2.42847 (ee8959b2766d), Built Oct 19 2021 09:36:41\nUser ID: 9008895\nExtraction ID: 2000000329933071\nCorrelation ID: CiD/9008895/AAAAAA.07c9c2101d2d5019/RA\nSchedule: 0x07c9c2101d3d5019 (ID = 0x0000000000000000)\nInput List (1 items):  (ID = 0x07c9c2101d3d5019) Created: 11/16/2021 10:08:09 Last Modified: 11/16/2021 10:08:09\nReport Template (6 fields): _OnD_0x07c9c2101d3d5019 (ID = 0x07c9c2101d6d5019) Created: 11/16/2021 10:07:28 Last Modified: 11/16/2021 10:07:28\nSchedule dispatched via message queue (0x07c9c2101d3d5019)\nSchedule Time: 11/16/2021 10:07:32\nProcessing started at 11/16/2021 10:07:32\nProcessing completed successfully at 11/16/2021 10:08:09\nExtraction finished at 11/16/2021 10:08:09 UTC, with servers: x03q13\nInstrument <RIC,EUR=> expanded to 1 RIC: EUR=.\nTotal instruments after instrument expansion = 1\n\n(RIC,EUR=,RCT)  row suppressed for lack of 'Distribution Rights - Tick History never allowed for PE 0' permission.\nReport suppressed because no instruments are permitted\n"
    ]
}

It shows that "... row suppressed for lack of 'Distribution Rights - Tick History never allowed for PE 0' permission".

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

f.cipriani avatar image f.cipriani

there was a problem with the refinitiv ecosystem

Refinitiv Tick History Custom Extractions were disrupted for customers globally between 08:00 and 12:14 GMT owing to an issue at Refinitiv. Customers were getting an error message as row suppressed for lack of Distribution Rights - Tick History never allowed for PE permission or Report suppressed because no instruments are permitted. Service was restored at 12:14 GMT on 16-Nov-21 after Refinitiv resolved the issue. Affected Platforms: GUI (Custom) and REST API



now I have a new message:

Instrument <RIC,EUR=> expanded to 1 RIC: EUR=.\nTotal instruments after instrument expansion = 1\n\nManifest: #RIC,Domain,Start,End,Status,Count\nManifest: EUR=,Market Price,,,Inactive,0\n'
f.cipriani avatar image f.cipriani f.cipriani

https://community.developers.refinitiv.com/questions/87368/api-issue-response-has-no-data-although-client-is-1.html

Click below to post an Idea Post Idea