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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
d.sukhanov avatar image
1 ●0 ●0 ●0

Cross Scaling Factor for PriceHistoryExtractionRequest

Hello!

How can I get cross scaling factor for PriceHistoryExtractionRequest (https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/ExtractWithNotes)?

For example, I made the following query : 

{
  "ExtractionRequest": {
    "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.PriceHistoryExtractionRequest",
    "ContentFieldNames": [
      "Ask Price",
      "Cross Scaling Factor"
    ],
    "IdentifierList": {
      "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
      "InstrumentIdentifiers": [
        {
          "Identifier": "JPYUSD=X",
          "IdentifierType": "Ric"
        }
      ],
      "ValidationOptions": null,
      "UseUserPreferencesForValidationOptions": false
    },
    "Condition": {
      "ReportDateRangeType": "Range",
      "QueryStartDate": "2021-03-12T00:00:00.000Z",
      "QueryEndDate": "2021-04-12T23:59:59.000Z"
    }
  }
}

and I received error

{"error": {"message": "Validation Error:\r\n\r\nInvalid content FieldName \"Cross Scaling Factor\""}}

If used "FXIR Scaling Factor", I also receive error:

{"error": {"message": "Validation Error:\r\n\r\nInvalid content FieldName \"FXIR Scaling Factor\""}}
dss-rest-apidatascope-selectdss
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.

6 Answers

Upvotes
Accepted
zoya faberov avatar image
23k ●22 ●9 ●14

Hello @d.sukhanov01,

Only field names that are defined for this type of request, per specification, can be passed. Other fields, not defined, will result in errors. You can get the complete list of fields defined for PriceHistoryExtractionRequest by request:

GET {
                {protocol}}{
                {host}}{
                {api}}Extractions/GetValidContentFieldTypes(ReportTemplateType=ThomsonReuters.Dss.Api.Extractions.ReportTemplates.ReportTemplateTypes'PriceHistory')

Or look it up in REST API Reference Tree -> PriceHistoryExtractionRequest

This field is not part of PriceHistoryExtractionRequest spec.

---

One can search up the relevant information via Refinitiv DataScope Select Data Content Guide. From my search

Terms and ConditionsCross Currency FlagY/N flag indicating if the bonds principal currency is different from that of the underlying asset.Terms and ConditionsCurrency CodeCurrency code for the trading instrument or corporate actions event.Terms and ConditionsCurrency Code DescriptionDescription of Currency Code.


Seem relevant to what you are looking for.

---

However, if this is not it, the best way for a customer to identify the required content within a product is to submit a content inquiry directly to Refinitiv content experts via Refinitiv Helpdesk Online -> Content. This forum is of most help with API usage. In this case, I have opened one on your behalf, case # 09796975.

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.

Upvotes
Gurpreet avatar image
13k ●32 ●12 ●18

Hi @d.sukhanov01,

Cross Scaling Factor is not a valid field for Price History report template. Please see the available fields for this report at REST API help on DSS website.

You can also get the list of fields by invoking the endpoint:

Extractions/GetValidExtractionFieldNames(ReportTemplateType=

and specifying the Price History report template

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.

Upvotes
d.sukhanov avatar image
1 ●0 ●0 ●0

@Gurpreet and @zoya.farberov, how can I receive value Cross Scaling Factor for historic rage of exchange rates?

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.

Upvotes
zoya faberov avatar image
23k ●22 ●9 ●14

@d.sukhanov01,

Suggest to await, for the content experts, to verify, via the opened investigation case.

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.

Upvotes
zoya faberov avatar image
23k ●22 ●9 ●14

Hello @d.sukhanov01,

The guidance from content was ".. Cross Scaling Factor ... field is not supported on Price History Report template, however this field is supported only on Intraday Pricing and Premium EOD Pricing Report templates...".

Please note, that Intraday Pricing report and Premium EOD do not support date range, consequently, there is no option to extract Historical data by using these requests.

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.

Upvotes
d.sukhanov avatar image
1 ●0 ●0 ●0

@zoya.farberov, I know it. But I interested it for history....

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.

zoya faberov avatar image zoya faberov

@d.sukhanov01,

Understood. I would suggest submitting an enhancement request, either via Feedback forum -> Enhancement -> Product=Datascope and including the complete details of what you are looking for, or discussing the enhancement with your Refinitiv account manager so they can help by submitting on your behalf.

If multiple clients are captured as looking for the same or similar feature, the enhancement on the product is prioritized.

Click below to post an Idea Post Idea