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?

Find more posts tagged with

extraction

dss-rest-api

Accepted answers

Jirapongse

@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".

All comments

Jirapongse

@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".

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'

EXPLORE OUR SITES