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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
16 0 0 3

Currency not populated (set to null)

I tried to send in the folllowing request to DSS end point.


{
    "ExtractionRequest": {
        "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.PriceHistoryExtractionRequest",
        "ContentFieldNames": [
            "Trade Date",
            "Universal Close Price",
            "Currency Code",
            "Mid Dirty Price",
            "Modified Duration",
            "FXIR Scaling Factor"
        ],
        "IdentifierList": {
            "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
            "InstrumentIdentifiers": [
                
                {
                    "Identifier": "IE00BMYDM794",
                    "IdentifierType": "Isin"
                }
            ]
        },
        "Condition": {
            "AdjustedPrices": true,
            "QueryStartDate": "2022-01-03T00:00:00+01:00",
            "QueryEndDate": "2023-01-09T00:00:00+01:00"
        }
    }
}


I see no currency populated in the response field. A sample element looked like this.

        {
            "IdentifierType": "Isin",
            "Identifier": "IE00BMYDM794",
            "Trade Date": "2022-01-03",
            "Universal Close Price": null,
            "Currency Code": null,
            "Mid Dirty Price": null,
            "Modified Duration": null,
            "FXIR Scaling Factor": null
        }


Is it normal to see null values for currency code ? What are the workarounds / best practices to get the currency of the ISIN then ?

dss-rest-api#product#contenton-demand-extraction
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.

1 Answer

· Write an Answer
Upvotes
Accepted
80.2k 259 52 75

@ramsundar.govindarajan

Thanks for reaching out to us.

I got the same data (null) as yours. You need to contact the Datascope Select support team directly via MyRefinitiv to verify the content.

However, if I set the source of the ISIN code in the request, the currency code is populated properly.

{
    "ExtractionRequest": {
        "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.PriceHistoryExtractionRequest",
        "ContentFieldNames": [
            "Trade Date",
            "Universal Close Price",
            "Currency Code",
            "Mid Dirty Price",
            "Modified Duration",
            "FXIR Scaling Factor"
        ],
        "IdentifierList": {
            "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
            "InstrumentIdentifiers": [
                
                {
                    "Identifier": "IE00BMYDM794",
                    "Source": "FRA",
                    "IdentifierType": "Isin"
                }
            ]
        },
        "Condition": {
            "AdjustedPrices": true,
            "QueryStartDate": "2023-01-03T00:00:00+01:00",
            "QueryEndDate": "2023-01-09T00:00:00+01:00"
        }
    }
}

The output is:

        {
            "IdentifierType": "Isin",
            "Identifier": "IE00BMYDM794",
            "Trade Date": "2023-01-03",
            "Universal Close Price": 4.654,
            "Currency Code": "EUR",
            "Mid Dirty Price": null,
            "Modified Duration": null,
            "FXIR Scaling Factor": null
        },
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.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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