question

Upvotes
Accepted
64 3 9 11

outputformat for report template

I try to change splitor from "," to ";" because event note contains " ' " in the text.

I got error

{
"error": {
"message": "Malformed request payload: For the property name \"OutputFormat\" in the JSON request the value could not be parsed successfully. Please check the casing or spelling of the property."
}
}

This is my request. what file i need to use?

{"@odata.type":"#ThomsonReuters.Dss.Api.Extractions.ReportTemplates.CorporateActionsStandardReportTemplate","ShowColumnHeaders":false,"Name":"test1Name_TTemplate","Headers":[],"Trailers":[],"ContentFields":[{"FieldName":"Corporate Actions ID","Format":null},{"FieldName":"Corporate Actions Type","Format":null},{"FieldName":"Corporate Action Notes","Format":null},{"FieldName":"Delete Marker","Format":null},{"FieldName":"Event Status","Format":null},{"FieldName":"Capital Change Announcement Date","Format":null},{"FieldName":"Capital Change Deal Date","Format":null},{"FieldName":"Capital Change Ex Date","Format":null},{"FieldName":"Effective Date","Format":null},{"FieldName":"Capital Change Event Type","Format":null},{"FieldName":"Actual Adjustment Factor","Format":{"@odata.type":"#ThomsonReuters.Dss.Api.Extractions.ReportTemplates.ContentFieldNumberFormat","DecimalPlaces":12,"DecimalSeparator":"Period","UseLeadingZero":false,"NegativeSignPosition":"Before","UseThousandSeparator":false,"UseTrailingZero":false}},{"FieldName":"New Shares Terms","Format":null},{"FieldName":"Old Shares Terms","Format":null},{"FieldName":"Dividend Pay Date","Format":null},{"FieldName":"Dividend Announcement Date","Format":null},{"FieldName":"Dividend Ex Date","Format":null},{"FieldName":"Dividend Payment Type","Format":null},{"FieldName":"Dividend Rate","Format":{"@odata.type":"#ThomsonReuters.Dss.Api.Extractions.ReportTemplates.ContentFieldNumberFormat","DecimalPlaces":12,"DecimalSeparator":"Period","UseLeadingZero":false,"NegativeSignPosition":"Before","UseThousandSeparator":false,"UseTrailingZero":false}},{"FieldName":"Currency Code","Format":null}],"Condition":{"ReportDateRangeType":"Range","QueryStartDate":"2006-01-01T00:00:00.000Z","QueryEndDate":"2017-04-27T23:59:59.999Z","IncludeInstrumentsWithNoEvents":true,"IncludeNullDates":false,"ExcludeDeletedEvents":true,"IncludeCapitalChangeEvents":true,"IncludeDividendEvents":true,"IncludeEarningsEvents":false,"IncludeMergersAndAcquisitionsEvents":false,"IncludeNominalValueEvents":false,"IncludePublicEquityOfferingsEvents":false,"IncludeSharesOutstandingEvents":false,"IncludeVotingRightsEvents":false,"CorporateActionsCapitalChangeType":"CapitalChangeAnnouncementDate","CorporateActionsDividendsType":"DividendAnnouncementDate","OutputFormat":"DelimitedValues","Delimiter":"Semicolon"}}

tick-history-rest-api
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Upvotes
Accepted
64 3 9 11

solved thanks

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

@bin, would you be so kind as to post a reply explaining how you solved this ? That would be of great help to other people who might run into a similar situation. Thanks in advance.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.