How I create a request to set 12 in your TRTH REST API V2 via Java. how I set Dividend Rate use 1...

Manigandan.R

...2 DecimalPlaces?

decimal-places.txt

Find more posts tagged with

tick-history-rest-api

Accepted answers

veerapath.rungruengrayubkul

@Manigandan.R

From the provided request message, you are using On Demand extraction.

As far as I know (refer to this question), there is no method to set ouput format (i.e. decimal place, ThousandSeparator) for the On Demand extraction.

However, the method to set output format is available for the Schedule extraction. User can do this once creating Report template. Please see this tutorial for more information about the Schedule extraction.

Also, below is the example of request message creating CorporateActionsStandardReportTemplate to retreive 12 decimal places for "Dividend Rate" field.

POST https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/CorporateActionsStandardReportTemplates

{
    "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ReportTemplates.CorporateActionsStandardReportTemplate",
    "ShowColumnHeaders": false,
    "Name": "CorpoateActionsTestTemplate",
    "ContentFields": [
        {
            "FieldName": "Dividend Rate",
            "Format": {
                "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ReportTemplates.ContentFieldNumberFormat",
                "DecimalPlaces": 12,
                "DecimalSeparator": "Period",
                "UseLeadingZero": false,
                "NegativeSignPosition": "Before",
                "ThousandSeparator": "Comma",
                "UseThousandSeparator": true,
                "UseTrailingZero": false
              }
        },
        {
            "FieldName": "Dividend Record Date",
            "Format": null
        }
    ],
    "Condition": {
        ...
    }
}

All comments

veerapath.rungruengrayubkul

@Manigandan.R

From the provided request message, you are using On Demand extraction.

As far as I know (refer to this question), there is no method to set ouput format (i.e. decimal place, ThousandSeparator) for the On Demand extraction.

Also, below is the example of request message creating CorporateActionsStandardReportTemplate to retreive 12 decimal places for "Dividend Rate" field.

POST https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/CorporateActionsStandardReportTemplates

{
    "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ReportTemplates.CorporateActionsStandardReportTemplate",
    "ShowColumnHeaders": false,
    "Name": "CorpoateActionsTestTemplate",
    "ContentFields": [
        {
            "FieldName": "Dividend Rate",
            "Format": {
                "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ReportTemplates.ContentFieldNumberFormat",
                "DecimalPlaces": 12,
                "DecimalSeparator": "Period",
                "UseLeadingZero": false,
                "NegativeSignPosition": "Before",
                "ThousandSeparator": "Comma",
                "UseThousandSeparator": true,
                "UseTrailingZero": false
              }
        },
        {
            "FieldName": "Dividend Record Date",
            "Format": null
        }
    ],
    "Condition": {
        ...
    }
}

Manigandan.R

veerapath.rungruengrayubkul

It is problem for me, because I will request data via Java interface rather than gui. Do you plain to change the API soon add this functon, what is the estimate time? because it cause lot of different between the TRTH v1 and TRTH v2 via Programming interface.

Nipat Kunvutipongsak

Below are the additional links consist of answers to your queries -

https://community.developers.refinitiv.com/questions/14095/do-you-have-sample-to-use-scheduler-to-get-corp-ev.html
https://community.developers.refinitiv.com/questions/14125/whats-url-i-should-use-to-create-corporate-actions.html
https://community.developers.refinitiv.com/questions/14157/outputformat-for-report-template.html

EXPLORE OUR SITES