where can I set the Formatting of "Include Thousand Separator" in a Reporttemplate via API

In DataScopeSelect I can set the "Include Thousand Separator" for a Reporttemplate via

ReportTemplate - Fields - Edit Fields - Formatting Number.

Where can I set this, if I create a Report via API ?

Best Answer

  • Christiaan Meihsl
    Answer ✓

    @joern.oberbeck,

    In the request, you define an object named Headers, containing an element called ShowThousandsSeparator.

    Here is an example HTTP body for the creation of an EndOfDayPricingReport template:

    {
    "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ReportTemplates.EndOfDayPricingReportTemplate",
    "ShowColumnHeaders": false,
    "Name": "myEodTemplateName",
    "Headers": [
    { "ShowThousandsSeparator": true }
    ],
    "Trailers": [],
    "ContentFields": [
    { "FieldName": "Instrument ID" },
    { "FieldName": "Security Description" },
    { "FieldName": "Universal Close Price Date" },
    { "FieldName": "Universal Close Price" }
    ],
    "Condition": null
    }

Answers