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?
My needs is to send multiple ISINs and receive their respective "RIC Codes".
For example:
ISIN BRB1234569 -> RIC ABCD12
ISIN BRB4569012 -> RIC FGHIJ34
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.
I got it! Many thanks @zoya.farberov!
I have one more question. How many rows the DDS API can fetch in a post?
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.