Feature request: add format to FieldInfoObject in /fields response (Custom Data Source API with multilevel hierarchies)

Answered
Eduardo Cruz asked on November 6, 2025

Hello Flexmonster Team,

Context
We are using multilevel hierarchies on the server side with the Custom Data Source API. Our implementation relies on the /fields request to provide field metadata for the Pivot.

Today, the FieldInfoObject returned by /fields does not support a way to declare measure formatting on the server. As a result, we are forced to repeat the formatting inside the report slice (e.g., report.slice.measures[].format) in multiple places. This leads to duplication, larger report payloads, and inconsistencies when the same measure is reused across reports or dynamically added to the slice.

Request
Please consider extending the FieldInfoObject to include an optional format property for measures in the /fields response. Ideally it would support:

  • either an inline format object (same schema as named formats in the report), or
  • a string referencing a named format defined in report.formats.

Proposed behavior

  • If format is provided by the server in /fields, it becomes the default formatting for that measure whenever it appears in the slice or is dragged from the Field List.
  • Backward compatible: if format is absent, current behavior remains unchanged.
  • Precedence: if a format is explicitly set in the slice for a particular measure instance, the slice-specific format continues to override the server default.

Why this helps

 

  • Eliminates duplication of formatting definitions across slices/reports.
  • Centralizes governance of measure presentation (currency, decimals, separators, percent).
  • Reduces client-side code and risk of inconsistency.
  • Improves maintainability and reduces payload size.

Thanks
Eduardo

1 answer

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster November 7, 2025

Hello, Eduardo!

Thank you for contacting us.

Our team agrees that it would be useful to have default formatting set for each measure, which is not removed when updating the slice. We have added your feature request to our Customers' Wishlist and will notify you about any updates on the matter.

Feel free to reach out to us if any other questions arise.

Kind regards,
Solomiia

Please sign in or register to submit your answer