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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
everton.solon avatar image
9 ●0 ●1 ●3

No permission to use the template using the endpoint "EndOfDayPricingReportTemplate"

When using the approach suggested by you, in the link below, I received the following message from DSS:
"https://community.developers.refinitiv.com/questions/66020/which-dss-api-context-should-i-use-to-send-multipl.html "

Message: No permission for template "EndOfDayPricingReportTemplate".

I tried the following part of the code because my user account has permission for the "Terms and Conditions" template, but I haven't received any lines:

var extractionRequest = new TermsAndConditionsExtractionRequest
{
    IdentifierList = InstrumentIdentifierList.Create(
        new[] { new InstrumentIdentifier { Identifier = "ABCDEFGHIJKL", IdentifierType.Isin } }, null, false),
    ContentFieldNames = new[] {"RIC", "ISIN"},
    Condition = new TermsAndConditionsCondition
    {
        IssuerAssetClassType = IssuerAssetClassType.AllSupportedAssets,
        ExcludeWarrants = false,
        StartDate = new DateTimeOffset(new DateTime(2015, 1, 1)), 
        FixedIncomeRatingSources = FixedIncomeRatingSource.StandardAndPoors,
    }
};

Obs: Identifier = "ABCDEFGHIJKL" is not the real identifier in this example.

Do you know if this template could be useful for me? If so, what do I need to do to recover the data?

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.

everton.solon avatar image everton.solon

My needs is to send multiple ISINs and receive their respective "RIC Codes".

For example:

ISIN BRB1234569 -> RIC ABCD12

ISIN BRB4569012 -> RIC FGHIJ34

3 Answers

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

Hello @everton.solon,

You should be able to use TermsAndConditions request, if you are permissioned for it. It can be used to map multiple instruments to RICs, including ISINs, for example:

{
    "ExtractionRequest": {
        "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.TermsAndConditionsExtractionRequest",
        "ContentFieldNames": [
           "RIC", "CUSIP", "ISIN", "SEDOL", "Issuer OrgID", "Currency Code"
        ],
        "IdentifierList": {
            "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
            "InstrumentIdentifiers": [
                { "Identifier": "00209tab1", "IdentifierType": "Cusip" },
                { "Identifier": "US4592001014", "IdentifierType": "Isin" },
                { "Identifier": "BRB1234569", "IdentifierType": "Isin" },
                { "Identifier": "BRB4569012", "IdentifierType": "Isin" }
            ]
        }
    }
}

However, it seems that the last two are not valid ISINs, from my testing, they appear to return

 "Contents": [
        {
            "IdentifierType": "Cusip",
            "Identifier": "00209TAB1",
            "RIC": "00209TAB1=RRPS",
            "CUSIP": "00209TAB1",
            "ISIN": "US00209TAB17",
            "SEDOL": "B7SDDX3",
            "Issuer OrgID": "172642",
            "Currency Code": "USD"
        },
        {
            "IdentifierType": "Isin",
            "Identifier": "US4592001014",
            "RIC": "IBM.N",
            "CUSIP": "459200101",
            "ISIN": "US4592001014",
            "SEDOL": "2005973",
            "Issuer OrgID": "18228",
            "Currency Code": "USD"
        },
        {
            "IdentifierType": "Isin",
            "Identifier": "BRB1234569",
            "Error": "Not found"
        },
        {
            "IdentifierType": "Isin",
            "Identifier": "BRB4569012",
            "Error": "Not found"
        }
    ],

Perhaps this is what is preventing you from requesting TermsAndConditions on them.

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
everton.solon avatar image
9 ●0 ●1 ●3

I got it! Many thanks @zoya.farberov!
I have one more question. How many rows the DDS API can fetch in a post?

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.

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

Hello @everton.solon,

It differs by the request type, please see:

Extraction Limits By Report Template for the complete information, you will need to login with your DSS cred.

For Terms&Conditions it's 50000 instruments.

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.

Click below to post an Idea Post Idea