Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

How to work with Year/Quarter/Month/day dates in Custom API?

Answered
Cedric Kalume asked on August 25, 2020

Hello,
 
I can get the members request to work but I don’t know how to format the select request for the pivot table
could you please give me the /select response format

2 answers

Public
Vera Didenko Flexmonster August 27, 2020

Hello, 
 
Thank you for reaching out to us. 
 
Our team would like to explain that the built-in year/quarter/month/day date data type is not implemented for the custom data source API. 
However, it is possible to create such a date data structure by combining separate fields into a multilevel hierarchy.
For example, it is possible to create separate fields representing each level: "year", "quarter", "month", and "day". Then these fields can be united to create a multilevel hierarchy that will represent the year/quarter/month/day date. The multilevel hierarchy can be configured via the mapping property.
 
Also, for multilevel hierarchies to work for the custom data source API, advanced filters need to be implemented on your server. 
Please see the following Support Forum thread for more details: https://www.flexmonster.com/question/is-it-possible-to-describe-hierarchies-with-the-custom-data-source-api/
 
For a better understanding of the required response structure for the /select request, please see the requests and responses when a hierarchy level is selected in the following JSFiddle example: https://jsfiddle.net/flexmonster/o4jywt38/ (by inspecting the page and navigating to the network tab). 
 
Please let us know if this helps. If any further questions arise, please feel free to reach out. 
 
Kind regards, 
Vera

Public
Cedric Kalume August 28, 2020

thank you this should solve my issue

Please login or Register to Submit Answer