Is there a DSS API to pull usage per template?

steven.giallanza

Here is a quick API snippet to run DSS usage reports

{
"ExtractionUsageCriteria": {
"EndDateTime":"2022-03-01T12:00:00",
"StartDateTime":"2022-01-01T12:00:00"
}
}

What we are looking to pull is usage specific to a template for a specific date range (ex; per day).

zoya faberov

Hello @steven.giallanza ,

Please see DSS REST API Reference tree- Usage section, for all Usage reports that are made available, do not believe there is specific report of "usage per template".

The report that you are looking at GetExtractionUsageInstrumentSummary is probably the closest to what you need:

{{protocol}}{{host}}{{api}}/Usage/GetExtractionUsageInstrumentSummary
{
    "ExtractionUsageCriteria": {
        "StartDateTime": "2021-01-01T00:00:00Z",
        "EndDateTime": "2021-11-01T00:00:00Z"

    }
}

as it returns template information and can be ranged by dates:

{
    "@odata.context": "https://selectapi.datascope.refinitiv.com/RestApi/v1/$metadata#DataScope.Select.Api.Usage.ExtractionUsageInstrumentSummaryResult",
    "Records": [
        {
            "AssetClass": "CMBS",
            "SubClass": "NONE",
 "ReportTemplate": "SCH",
            "SubTemplate": "NONE",
            "Count": 5,
            "EquityFairValue": 0,
            "FixedIncomeValuations": 0
        },
        {
            "AssetClass": "COMM",
            "SubClass": "HISTORICAL",
 "ReportTemplate": "ET2",
            "SubTemplate": "NONE",
            "Count": 3,
            "EquityFairValue": 0,
            "FixedIncomeValuations": 0
        },
        {
            "AssetClass": "CORP",
            "SubClass": "INVGDE",
   "ReportTemplate": "CMP",
            "SubTemplate": "NONE",
            "Count": 1,
            "EquityFairValue": 0,
            "FixedIncomeValuations": 0
        },
...