Is there a DSS API to pull usage per template?

Options


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).

picture1.png


Tagged:

Best Answer

  • zoya faberov
    zoya faberov ✭✭✭✭✭
    Answer ✓

    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
    },
    ...